Implementing A SQL Data Warehouse

This course is intended for extract, transform, and load (ETL) and data warehouse developers who create business intelligence (BI) solutions. Their responsibilities include data cleansing, in addition to ETL and data warehouse implementation.

Exam 70-767 Implementing a SQL Data Warehouse

This course is intended for extract, transform, and load (ETL) and data warehouse developers who create business intelligence (BI) solutions. Their responsibilities include data cleansing, in addition to ETL and data warehouse implementation.

Course Content

Design, implement, and maintain a data warehouse (35–40%)

 

  • Design and implement dimension tables
  • Design and implement fact tables
  • Design and implement indexes for a data warehouse workload
  • Design storage for a data warehouse
  • Design and implement partitioned tables and views

Extract, transform, and load data (40–45%)

  • Design and implement an extract, transform, and load (ETL) control flow by using a SQL Server Integration Services (SSIS) package
  • Design and implement an ETL data flow by using an SSIS package
  • Implement an ETL solution that supports incremental data extraction
  • Implement an ETL solution that supports incremental data loading
  • Debug SSIS packages
  • Deploy and configure SSIS packages and projects

Build data quality solutions (15–20%)

  • Create a knowledge base
  • Maintain data quality by using DQS
  • Implement a Master Data Services (MDS) model
  • Manage data by using MDS

JOIN AN UPCOMING CLASS FOR THIS COURSE