When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Data Warehouse & ETL with SQL Server, SSIS, SSDT & TSQL
Learn to design data warehouses, build ETL pipelines, deploy SSIS packages, and deliver business intelligence
This Course Includes
udemy
4.6 (149 reviews )
5h 51m 
english
Online - Self Paced
professional certificate
Udemy
About Data Warehouse & ETL with SQL Server, SSIS, SSDT & TSQL
This beginner-friendly course guides you through building an enterprise data warehouse solution using Microsoft SQL Server, SQL Server Integration Services (SSIS), and SQL Server Data Tools (SSDT). You’ll gain hands-on experience designing, implementing, and managing a data warehouse, with a focus on ETL processes, data modeling, and reporting. Step-by-step labs help you set up your environment, create SSIS packages, and transform raw data into valuable business insights.
What You’ll Learn
Set up SQL Server , SSDT, and Visual Studio
Attach and explore the AdventureWorksDW sample database
Understand data warehouse concepts, architecture, and hardware considerations
Design and implement fact and dimension tables
Choose between star and snowflake schema designs
Build ETL solutions with SSIS, including incremental extraction and loading
Create and debug SSIS packages (control flow, data flow, logging, error handling)
Cleanse data using Data Quality Services (DQS) and enforce integrity with Master Data Services (MDS)
Deploy, configure, and execute SSIS packages
Consume and analyse data with SSRS and SSAS
By the End of This Course
You’ll have the skills to design and implement a complete data warehouse solution, build robust ETL pipelines, and deliver business intelligence using Microsoft’s data platform.
What you’ll build
An operational data warehouse with SQL Server ETL solutions supporting incremental loads Reports and analytics with SSRS/SSAS
Who this course is for
Aspiring data warehouse or BI developers
SQL Server users who want to expand into ETL and data warehousing
Anyone interested in learning data warehousing with Microsoft tools
What You Will Learn?
- Deploy and Configure SSIS packages. .
- Design and implement a data warehouse .
- Implement Data Flow in an SSIS Package .
- Implement Control Flow in an SSIS Package .
- Debug and Troubleshoot SSIS packages. .
- Implement an ETL solution that supports incremental data extraction .
- Implement data cleansing by using Microsoft Data Quality Services. .
- Implement Master Data Services to enforce data integrity .
- Extract and load modified data .
- Consume data in a data warehouse.