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.
This five-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server database. The course covers SQL Server provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.
Plus, get prepped for Microsoft exam 70-767, a requirement for MCSA: SQL 2016 BI Development and MCSE: Data Management and Analytics.
LIVE, INSTRUCTOR-LED
TRAINING AT YOUR SITE
Customize Your Team Training Experience
CONTACT USOur FlexVouchers help you lock in your training budgets without having to commit to a traditional 1 voucher = 1 course classroom-only attendance. FlexVouchers expand your purchasing power to modern blended solutions and services that are completely customizable. For details, please call 888-843-8733 or chat live.
Mar 22 - 26
9:00 AM - 4:30 PM EDT
Online (AnyWare)
Apr 19 - 23
9:00 AM - 4:30 PM EDT
Online (AnyWare)
May 17 - 21
9:00 AM - 4:30 PM PDT
Online (AnyWare)
Sep 20 - 24
9:00 AM - 4:30 PM EDT
Herndon, VA / Online (AnyWare)
Oct 18 - 22
9:00 AM - 4:30 PM EDT
New York / Online (AnyWare)
Nov 29 - Dec 3
9:00 AM - 4:30 PM PST
Bellevue / Online (AnyWare)
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 — will run. Guaranteed.This course can help you prepare for the following Microsoft certification exam — 70-767: Implementing a Data Warehouse using SQL
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
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:
Yes! We know your busy work schedule may prevent you from getting to one of our classrooms which is why we offer convenient online training to meet your needs.
Yes! This course is eligible for Microsoft Software Assurance Training Voucher (SATV) redemption.
This course helps prepare you for the Microsoft 70-767 certification exam, Implementing a SQL Data Warehouse (beta).
Yes! It fulfills a requirement for MCSA: SQL 2016 BI Development and MCSE: Data Management and Analytics certifications.
Questions about which training is right for you?
It allows us to direct your request to the appropriate Customer Care team.
Your Training Comes with a 100% Satisfaction Guarantee!*
*Partner-delivered courses may have different terms that apply. Ask for details.