any location of your choice Microsoft MOC 20767 SQL Server Training - Dynamics Edge

any location of your choice MOC 20767 SQL Server Training -> Implementing a 2016 SQL Data Warehouse

Dynamics Edge4.67 4.67 out of 50 stars, based on 80 reviews.*
CourseStart DateEnd DateLocationLength

Please select Dynamics Edge Microsoft Official Course 20767 convenient SQL Server training class you can trust that is the best choice for you. Custom courses could be an option for you.

About this course

This 5-day instructor led course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft® SQL Server® 2016 and with Azure SQL Data Warehouse, to implement ETL with SQL Server Integration Services, and to validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

Who Should Attend:

The primary audience for this course are database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.

After completing this course, students will be able to:

Course Outline

Module 1: Introduction to Data Warehousing

Describe data warehouse concepts and architecture considerations.

Lessons

Lab : Exploring a Data Warehouse Solution

Module 2: Planning Data Warehouse Infrastructure

This module describes the main hardware considerations for building a data warehouse.

Lessons

Lab : Planning Data Warehouse Infrastructure

Module 3: Designing and Implementing a Data Warehouse

This module describes how you go about designing and implementing a schema for a data warehouse.

Lessons

Lab : Implementing a Data Warehouse Schema

Module 4: Columnstore Indexes

This module introduces Columnstore Indexes.

Lessons

Lab : Using Columnstore Indexes

Module 5: Implementing an Azure SQL Data Warehouse

This module describes Azure SQL Data Warehouses and how to implement them.

Lessons

Lab : Implementing an Azure SQL Data Warehouse

Module 6: Creating an ETL Solution

At the end of this module you will be able to implement data flow in a SSIS package.

Lessons

Lab : Implementing Data Flow in an SSIS Package

Module 7: Implementing Control Flow in an SSIS Package

This module describes implementing control flow in an SSIS package.

Lessons

Lab : Implementing Control Flow in an SSIS Package
Lab : Using Transactions and Checkpoints

Module 8: Debugging and Troubleshooting SSIS Packages

This module describes how to debug and troubleshoot SSIS packages.

Lessons

Lab : Debugging and Troubleshooting an SSIS Package

Module 9: Implementing an Incremental ETL Process

This module describes how to implement an SSIS solution that supports incremental DW loads and changing data.

Lessons

Lab : Extracting Modified Data
Lab : Loading Incremental Changes

Module 10: Enforcing Data Quality

This module describes how to implement data cleansing by using Microsoft Data Quality services.

Lessons

Lab : Cleansing Data

Module 11: Using Master Data Services

This module describes how to implement master data services to enforce data integrity at source.

Lessons

Lab : Implementing Master Data Services

Module 12: Extending SQL Server Integration Services (SSIS)

This module describes how to extend SSIS with custom scripts and components.

Lessons

Lab : Using Scripts and Custom Components

Module 13: Deploying and Configuring SSIS Packages

This module describes how to deploy and configure SSIS packages.

Lessons

Lab : Deploying and Configuring SSIS Packages

Module 14: Consuming Data in a Data Warehouse

This module describes how to debug and troubleshoot SSIS packages.

Lessons

Lab : Using Business Intelligence Tools

Prerequisites

More SQL Server training classes

*NOTE: if an average rating and rating count are shown on this page, they are based on all reviews associated with Dynamics Edge that are shown on the review page, and are not restricted to reviews only for the particular courses offered on this page.