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
“The Informatica B2B session was awesome, the materials were accurate and Jean was a really good instructor”
- James Martin, Manager, Business Intelligence, Large US Company
The trainers clear and obvious enthusiasm for number crunching, analytics, and teaching others is infectious. He doesn’t waste time, shows exactly what you need to know and is genuinely hilarious.
Every one of my employees had tons of positive stuff to say.
- Benjamin G, MXSG Analysis and Integration Chief, US Air Force
“Instructor was very passionate about the subject and definitely helped me to stay engaged. Great pace, great knowledge, and instructor was amazing overall :) ”
- John Smith, Analyst, Dept. of Homeland Security
