Course Description
Data warehousing is a solution organizations use to centralize business data for reporting and analysis. This five-day instructor-led course focuses on teaching individuals how to create a data warehouse with SQL Server 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.
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