IL - MOC 20767: Implementing a SQL Data Warehouse

Course Overview

In this course, you will learn how to implement a data warehouse platform to support a business intelligence (BI) solution. You will discover how to create a data warehouse, how to implement extract, transform, and load (ETL) with SQL Server Integration Services (SSIS), and how to validate and cleanse data with Data Quality Services (DQS) and Master Data Services.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.

Course Details
  • Duration: 5 Days
  • Level: 300

Who this course is designed for
  • Database professionals who need to fulfill a BI developer role focused on hands-on work by creating BI solutions, including data warehouse implementation, ETL and data cleansing
  • Database professionals responsible for implementing a data warehouse, developing SSIS packages for data ETL, enforcing data integrity using Microsoft Data Services and cleansing data using Data Quality Services

What You Will Learn

  • Overview of data warehousing
  • Considerations for building a data warehouse
  • Design and implementation for a data warehouse
  • Columnstore indexes
  • Azure SQL Data Warehouse
  • Implement control flow in an SSIS package
  • Debug and troubleshoot SSIS packages
  • Incremental ETL and modified data extraction
  • Master Data Services concepts and implementation
  • Deploy and configure SSIS packages
  • BI tools with Azure SQL Data Warehouse


  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of relational databases.
  • Some experience with database design

Learning Format

  • Onsite at your location
  • Virtual Training

Contact the experts at Opsgility to schedule this class at your location or to discuss a more comprehensive readiness solution for your organization. Contact us to enroll or book a class

Contact Us
Looking for on-demand training?