Database Developer (Mssql, Ssrs, & Ssis)

Free Download Database Developer (Mssql, Ssrs, & Ssis)
Published 8/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.40 GB | Duration: 6h 12m
Mastering Data Management and Integration: Database Developer Proficiency in MSSQL, SSRS, & SSIS

What you’ll learn
Understanding the role and importance of a Database Developer in modern data-centric organizations.
Installing and configuring Microsoft SQL Server (MSSQL) for database development.
Creating and managing relational database structures using T-SQL and MSSQL.
Writing SQL queries to retrieve, filter, sort, and aggregate data from databases.
Designing and developing interactive and visually appealing reports using SQL Server Reporting Services (SSRS).
Designing ETL workflows using SQL Server Integration Services (SSIS).
Building data flow tasks to extract data from various sources and transform it for destination systems.
Building data flow tasks to extract data from various sources and transform it for destination systems.
Requirements
Basic Computer Skills: Students should have a fundamental understanding of how to operate a computer, navigate through files and folders, and use software applications.
Familiarity with Databases: A basic understanding of databases and their concepts, such as tables, rows, columns, and relationships, will be beneficial.
SQL Fundamentals: Familiarity with SQL (Structured Query Language) basics, including writing SELECT queries, is recommended as the course will involve more advanced SQL topics.
Basic Programming Concepts: While not mandatory, having some knowledge of programming concepts will help students grasp scripting and custom logic aspects in SSIS.
Computer and Software Requirements: Students will need access to a computer with internet connectivity. They should have software like Microsoft SQL Server, SQL Server Management Studio (SSMS), SQL Server Data Tools (SSDT), and any necessary tools for remote learning, depending on the course delivery method.
Understanding of Business Data: A general awareness of business data and its importance in decision-making processes can be helpful when working with databases and reports.
Microsoft Office Skills: Basic skills in using Microsoft Office applications (such as Excel) can aid in understanding reporting concepts and data manipulation.
Willingness to Learn: Enthusiasm for learning about databases, reporting, and data integration is crucial. These areas can be complex, but a willingness to learn and practice will be valuable.
Description
Welcome to this course on Database Development with a focus on Microsoft SQL Server (MSSQL), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS). In this course, we will embark on a journey into the world of data management and integration, equipping you with the skills and knowledge needed to excel as a proficient Database Developer.In today’s data-driven landscape, effective management and utilization of data are paramount for organizations to make informed decisions, enhance efficiency, and drive innovation. As a Database Developer, you will play a pivotal role in designing, optimizing, and maintaining databases, ensuring seamless data flow, and enabling valuable insights through reports and data integration workflows.Course Highlights:Throughout this course, you will delve into the intricacies of Microsoft SQL Server, a leading Relational Database Management System (RDBMS). You will gain hands-on experience in crafting SQL queries to retrieve and manipulate data, designing efficient database structures, and ensuring data integrity.You will also dive into the world of SQL Server Reporting Services (SSRS), exploring how to design and deliver insightful reports that empower organizations with visualized data. From creating interactive dashboards to producing pixel-perfect printed reports, you will learn to leverage SSRS to present data in compelling and accessible ways.Furthermore, the course will guide you through SQL Server Integration Services (SSIS), your gateway to orchestrating data workflows, transforming data, and loading it into various destinations. You will learn to build ETL (Extract, Transform, Load) processes, automate data movement, and ensure data quality across different systems.Course Objectives:By the end of this course, you will be equipped with the skills to:Design and create efficient database structures using MSSQL.Craft complex SQL queries for data retrieval, manipulation, and analysis.Develop interactive and visually appealing reports using SSRS.Create ETL workflows, transforming and loading data with SSIS.Who Should Enroll:This course is designed for aspiring and current Database Developers, SQL Developers, Business Intelligence Developers, and anyone seeking a solid foundation in database management, reporting, and data integration. Whether you’re new to the field or looking to enhance your existing skills, this course is tailored to accommodate learners at various levels of expertise.Prepare to embark on a transformative learning journey that will empower you to contribute significantly to data-driven decision-making processes. Get ready to explore the dynamic world of databases, reporting, and data integration with Microsoft SQL Server, SSRS, and SSIS. Let’s dive in!
Overview
Section 1: Introduction to Database Development and MSSQL
Lecture 1 Introduction
Lecture 2 Understanding the role of a database developer
Lecture 3 Introduction to relational databases and MSSQL
Lecture 4 Installing and configuring MSSQL Server
Lecture 5 SQL Server Management Studio (SSMS) overview
Lecture 6 Basic SQL queries: SELECT, INSERT, UPDATE, DELETE
Lecture 7 Data types, constraints, and normalization principles
Lecture 8 Introduction to T-SQL programming
Section 2: Microsoft SQL Server Setup
Lecture 9 What is SQL Server
Lecture 10 SQL Server Editions
Lecture 11 SQL Server Installation Requirements
Lecture 12 Download SQL Server
Lecture 13 Install SQL Server
Lecture 14 SQL Server Configuration Manager
Lecture 15 Install SQL Server Management Studio
Lecture 16 Connect to SQL Server using SSMS
Lecture 17 Install sample database
Section 3: Visual Studio Setup
Lecture 18 What is Visual Studio
Lecture 19 Visual Studio Installation Requirements
Lecture 20 Install Visual Studio
Lecture 21 Visual Studio workloads
Lecture 22 Install SQL Server Data Tools
Lecture 23 Install SSDT Templates
Section 4: Creating a Report
Lecture 24 What is SSRS
Lecture 25 Install SQL Server Reporting Services
Lecture 26 Requirements to configure report server
Lecture 27 Configure Report Server
Lecture 28 Create a report server project
Lecture 29 Create a report definition file
Lecture 30 Configure a data source for the report
Lecture 31 Define a dataset for the report
Lecture 32 Add a table to the report
Lecture 33 Format the report
Lecture 34 Grouping data in the report
Lecture 35 Adding Totals to the report
Lecture 36 Previewing the report
Lecture 37 Exporting the report
Lecture 38 Publishing Reports
Section 5: Implementing ETL with SSIS
Lecture 39 Introduction to SSIS and ETL Concepts
Lecture 40 What is SSIS
Lecture 41 Installing SQL Server Integration Service
Lecture 42 Create a a new SSIS Project
Lecture 43 SSIS designer
Lecture 44 Add and configure a flat file connection manager
Lecture 45 Remapping column data types
Lecture 46 Add and configure an OLE DB connection manager
Lecture 47 Add a data flow task to package
Lecture 48 Add and Configure flat file source
Lecture 49 Add and configure lookup transformations
Lecture 50 Add and configure lookup datekey transformations
Lecture 51 Add and configure OLE DB Destination
Lecture 52 Test and Run SSIS Package
Section 6: AGGREGATE FUNCTIONS
Lecture 53 Introduction to Aggregate Functions
Lecture 54 AVG Function
Lecture 55 Count Function
Lecture 56 Max Function
Lecture 57 Min Function
Lecture 58 SUM Function
Lecture 59 Using Multiple Aggregate Functions
Lecture 60 Grouping Data
Section 7: Table Joins
Lecture 61 Table-Join-Introduction
Lecture 62 Why-Table-Joins
Lecture 63 RIGHT-OUTER-JOIN
Lecture 64 LEFT-OUTER-JOIN
Lecture 65 INNER-JOIN
Lecture 66 FULL OUTER JOIN
Section 8: Filtering Records
Lecture 67 Introduction
Lecture 68 Filtering-with-basic-comparisons
Lecture 69 Filtering with equality filters
Lecture 70 Filtering with logical comparison
Lecture 71 Filtering with String Comparison
Section 9: Sorting Data
Lecture 72 Introduction
Lecture 73 sorting by ascending
Lecture 74 Sorting by descending order
Lecture 75 sorting-by-multiple-columns
Aspiring Database Developers: Individuals who are new to the field of database development and want to build a strong foundation in designing, managing, and optimizing databases.,SQL Developers: Those who have experience with SQL but want to expand their skill set to include advanced database development techniques and data integration.,Business Intelligence Developers: Individuals interested in working with data to generate meaningful reports, dashboards, and insights for decision-makers.,IT Professionals: IT professionals looking to enhance their skills and specialize in database development and data integration using Microsoft SQL Server tools.,Data Analysts: Data analysts who want to explore data transformation and integration techniques for enhancing their analytical capabilities.,Database Administrators (DBAs): DBAs who want to expand their skill set beyond database administration to include database development and data integration tasks.,Software Engineers: Software developers who want to broaden their knowledge to include database design and integration into their applications.,Technology Enthusiasts: Individuals with a passion for technology and data who want to explore the world of databases, reporting, and data integration.,Career Changers: Professionals looking to transition into a career in the technology industry, especially those interested in database-related roles.,Students and Graduates: Students pursuing degrees in computer science, information technology, or related fields who want to gain practical skills in database development.,Self-Learners: Anyone with a strong desire to learn and master the concepts and tools of database development, reporting, and data integration.
Homepage

www.udemy.com/course/database-developer-mssql-ssrs-ssis/