Implementing a SQL Data Warehouse – Institute of Software Technologies

Implementing a SQL Data Warehouse

Implementing a SQL Data Warehouse

In this 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. This course incorporates material from the Official Microsoft Learning Product 20767: and it can assist you in your preparation for Exam 70-767: Implementing a SQL Data Warehouse.

This course covers the following;

• 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

This course requires the following prerequisites;

• Basic knowledge of the Microsoft Windows operating system and its core functionality.

• Working knowledge of relational databases.

• Some experience with database design

You will learn how to:

• Describe the key elements of a data warehousing solution

• Describe the main hardware consideration for building a data warehouse

• Implement a logical design for a data warehouse

• Implement a physical design for a data warehouse

• Create column store indexes

• Implementing an Azure SQL Data Warehouse

• Describe the key features of SSIS

• Implement control flow by using tasks and precedence constraints

• Create dynamic packages that include variables and parameters

• Debug SSIS packages

• Describe the considerations for implementing an ETL solution

• Implement Data Quality Services

• Implement a Maser Data Services model

• Describe how you can use custom components to extend SSIS

• Deploy SSIS projects

• Describe BI and common BI scenarios

How you will be assessed?



7th Feb 2020


7th March 2020


7th Sept 2020