The five-days Microsoft 20767B Implementing a SQL Data Warehouse Certification Course is part 1 of the series of two courses of MCSA 2016: SQL Business Intelligence Development, that validates your skills to create and deploy a data warehouse with Microsoft SQL Server 2016 and Azure SQL Data Warehouse for efficiently implementing the ETL as well as SQL Services.
This course is intended for database professionals who support Business Intelligence solutions, engaged in implanting, validating and cleansing data warehouses.
This course qualifies you for the exam 70-767: Implementing a SQL Data Warehouse Certification.
Module 1: Introduction to Data Warehousing
This module introduces the data warehouse concepts and architecture considerations.
Lessons
Module 2: Planning Data Warehouse Infrastructure
This module introduces the main hardware considerations for building a data warehouse.
Lessons
Module 3: Designing and Implementing a Data Warehouse
This module explains how you go about designing and implementing a schema for a data warehouse.
Lessons
Module 4: Column store Indexes
This module explains the Columnstore Indexes.
Lessons
Module 5: Implementing an Azure SQL Data Warehouse
This module introduces Azure SQL Data Warehouses and how to implement them.
Lessons
Module 6: Creating an ETL Solution
This module will enable you to implement data flow in an SSIS package.
Lessons
Module 7: Implementing Control Flow in an SSIS Package
This module discusses the implementation of control flow in an SSIS package.
Lessons
Module 8: Debugging and Troubleshooting SSIS Packages
This module explains how to debug and troubleshoot SSIS packages.
Lessons
Module 9: Implementing an Incremental ETL Process
This module explains how to implement an SSIS solution that supports incremental DW loads and changing data.
Lessons
Module 10: Enforcing Data Quality
This module explains how to implement data cleansing by using Microsoft Data Quality services.
Lessons
Module 11: Using Master Data Services
This module explains how to implement master data services to enforce data integrity at source.
Lessons
Module 12: Extending SQL Server Integration Services (SSIS)
This module explains how to extend SSIS with custom scripts and components.
Lessons
Module 13: Deploying and Configuring SSIS Packages
This module explains how to deploy and configure SSIS packages.
Lessons
Module 14: Consuming Data in a Data Warehouse
This module explains how to debug and troubleshoot SSIS packages.
Lessons
SQL Server Data Warehouse training course is intended for database professionals who need to accomplish a Business Intelligence Developer role. They will be required to exhibit hands-on work creating BI solutions.
Primary responsibilities will include:
The course requires professionals and learners to meet the following prerequisites:
Name | Code | Fee |
---|---|---|
Implementing a SQL Data Warehouse Certification | 70-767 | USD 108 |
OR