IL - MOC 20767: Implementing a SQL Data Warehouse
Instructor-Led Training
Intermediate
5 Days
Onsite or Virtual
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.
Objectives
  • 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
Pre-Requisites
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of relational databases.
  • Some experience with database design
  • Onsite at your location
  • Virtual Training
Dedicated Training
Contact Us Today

Dedicated instructor-led training is designed for group training and is delivered by the experts at Opsgility. Delivery availability is anywhere in the world at your location or using advanced virtual training software.

Benefits
  • Standard or Customized Curriculum
  • Globally Available for Delivery
  • Holistic Learning Plans are Available
  • Industry Recognized Subject Matter Experts