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