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.