There are no items in your cart. Continue shopping on our Course Directory page.
Pay now -or- pay later
Pay by credit card at checkout
-or- pay later by invoice, as always.
PDF Add to WishList
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.
This is a Microsoft Official Course (MOC) delivered by a Learning Tree expert instructor.
This course is part of a Microsoft Certification Path and can help you prepare for your MCSA Certification, MCSE Certification, or MCSD Certification.
Describe data warehouse concepts and architecture considerations.
Lessons
Lab: Exploring a Data Warehouse Solution
After completing this module, students will be able to:
This module describes the main hardware considerations for building a data warehouse.
Lessons
Lab: Planning Data Warehouse Infrastructure
After completing this module, students will be able to:
This module describes how you go about designing and implementing a schema for a data warehouse.
Lessons
Lab: Implementing a Data Warehouse Schema
After completing this module, students will be able to:
This module introduces Columnstore Indexes.
Lessons
Lab: Using Columnstore Indexes
After completing this module, students will be able to:
This module describes Azure SQL Data Warehouses and how to implement them.
Lessons
Lab: Implementing an Azure SQL Data Warehouse
After completing this module, students will be able to:
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
After completing this module, students will be able to:
This module describes implementing control flow in an SSIS package.
Lessons
Lab: Implementing Control Flow in an SSIS Package
Lab: Using Transactions and Checkpoints
After completing this module, students will be able to:
This module describes how to debug and troubleshoot SSIS packages.
Lessons
Lab: Debugging and Troubleshooting an SSIS Package
After completing this module, students will be able to:
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
After completing this module, students will be able to:
This module describes how to implement data cleansing by using Microsoft Data Quality services.
Lessons
Lab: Cleansing Data
Lab: De-duplicating Data
After completing this module, students will be able to:
This module describes how to implement master data services to enforce data integrity at source.
Lessons
Lab: Implementing Master Data Services
After completing this module, students will be able to:
This module describes how to extend SSIS with custom scripts and components.
Lessons
Lab: Using Scripts and Custom Components
After completing this module, students will be able to:
This module describes how to deploy and configure SSIS packages.
Lessons
Lab: Deploying and Configuring SSIS Packages
After completing this module, students will be able to:
This module describes how to debug and troubleshoot SSIS packages.
Lessons
Lab: Using Business Intelligence Tools
After completing this module, students will be able to:
Hassle-Free Enrolment: No advance payment required to reserve your seat.
Tuition due 30 days after you attend your course.
Tuition — Standard: $3710 Government: $3260
Apr 29 - May 3
(
5 Days)
9:00 AM - 4:30 PM EDT
Alexandria, VA / Online (AnyWare)
Reserve Your Seat
Jul 22 - 26
(
5 Days)
9:00 AM - 4:30 PM EDT
Ottawa / Online (AnyWare)
Reserve Your Seat
Aug 26 - 30
(
5 Days)
9:00 AM - 4:30 PM EDT
Toronto / Online (AnyWare)
Reserve Your Seat
Sep 16 - 20
(
5 Days)
9:00 AM - 4:30 PM EDT
Herndon, VA / Online (AnyWare)
Reserve Your Seat
Oct 28 - Nov 1
(
5 Days)
9:00 AM - 4:30 PM EDT
Alexandria, VA / Online (AnyWare)
Reserve Your Seat
Jan 6 - 10
(
5 Days)
9:00 AM - 4:30 PM EST
Ottawa / Online (AnyWare)
Reserve Your Seat
Guaranteed to Run
When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time, location — will run. Guaranteed.With a blend of video, text, hands-on labs, and knowledge checks, you will receive the same high quality content as the live event, but you can attend on your own time, at your own pace.
PLUS, we include access to a Microsoft Certified Trainer (MCT) to help you prepare for your certification exam and help you apply your new skills immediately… Learning Tree knows how to bring learning to life!
For enrolling multiple subscribers at the same time, contact us »
Enrolling at least 3 people in this course? Consider bringing this (or any course that can be custom designed) to your preferred location as a private team training.
For details, call 1-888-843-8733 or Click here »
$3710
$3260
$1195*
Course Tuition Includes:
Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm