20767C - Implementing a SQL Data Warehouse
Overview
This five-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server database. The course covers SQL Server provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.
Duration
5 Days
Target Audience
The primary audience for this course are database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.
Topics
Introduction to Data Warehousing
Planning Data Warehouse Infrastructure
Designing and Implementing a Data Warehouse
Columnstore Indexes
Implementing an Azure SQL Data Warehouse
Creating an ETL Solution
Implementing Control Flow in an SSIS Package
Debugging and Troubleshooting SSIS Packages
Implementing a Data Extraction Solution
Enforcing Data Quality
Using Master Data Services
Extending SQL Server Integration Services (SSIS)
Deploying and Configuring SSIS Packages
Consuming Data in a Data Warehouse
A more comprehensive course outline is available in the Course Download section, to the right of this page.