Course Description
This five-day instructor-led course focuses on teaching individuals how to create a data warehouse with SQL Server 2014/2016/2019, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
Course Summary
Next Public Course Dates | |
| Prerequisites |
|
| Duration |
|
| Available Formats |
|
| Audience |
|
Course Modules
- Introduction to Data Warehousing
- Data Warehouse Hardware
- Designing and Implementing a Data Warehouse
- Creating an ETL Solution with SSIS
- Implementing Control Flow in an SSIS Package
- Debugging and Troubleshooting SSIS Packages
- Implementing an Incremental ETL Process
- Incorporating Data from the Cloud into a Data Warehouse
- Enforcing Data Quality
- Using Master Data Services
- Extending SQL Server Integration Services
- Deploying and Configuring SSIS Packages
- Consuming Data in a Data Warehouse
Testimonials
“Without a doubt one of the best professional development courses I’ve taken. I would highly recommend.”
- Blaine Clark, KPERS
I enjoyed the class a lot! I had problems with queries, so it was super helpful when Mahesh copies them into the chat. All explanations were thorough and be able to do it was awesome.
- Lisa Kruta, Environmental Coordinator, US Air Force
“The course was comprehensive and interactive, and the trainer really understood the content. I have been able to implement much of what I learned into my daily work activities and have saved a lot of time.”
- Susan Medina, Senior Business Analyst, Advocate Health Care
