20767C - Implementing a SQL Data Warehouse

20767C - Implementing a SQL Data Warehouse


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.


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.


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.

Course Details

Course Ref:


Course Duration:

5 Days

Course Location:


Course Dates:

Please call for dates...

Course Price (Excl VAT):


Course Downloads

Send course details to a colleague


   To book or for further information, please telephone 0191 515 3355 or e-mail us at sales@mtc-training.co.uk