Implementing a Microsoft SQL 2016 Data Warehouse (MS-20767)

This 5-day instructor led course describes how to implement a data warehouse platform to support a BI solution.
Purchase Options
Master Subscription
7-Day FREE Trial
Now Only $1,999.00 Regular Price $3,499.00
/ Year
Team Pricing
  • Buy 5-9 Enrollments And Save 5% ($1,899.00 ea.)
  • Buy 10-19 Enrollments And Save 10% ($1,799.00 ea.)
  • Buy 20-above Enrollments And Save 15% ($1,699.00 ea.)
Individual Course
On Sale!
Now Only $1,995.00 Regular Price $2,995.00
/ Seat
Team Pricing
  • Buy 5-9 Enrollments And Save 10% ($1,796.00 each.)
  • Buy 10-19 Enrollments And Save 15% ($1,696.00 each.)
  • Buy 20-above Enrollments And Save 20% ($1,596.00 each.)
This 5-day instructor led course describes how to implement a data warehouse platform to support a BI solution.

About this course:

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.

This course also prepares the students for the Microsoft 70-767: Implementing a Data Warehouse using SQL certification exam.

The average salary for a Database Administrator is $71,429 per year.

Course Objectives:

After completing this course, students will be able to:

  • Describe the key elements of a data warehousing solution 
  • Describe the main hardware considerations for building a data warehouse 
  • Implement a logical design for a data warehouse  
  • Implement a physical design for a data warehouse
  • Create column store indexes
  • Implementing an Azure SQL Data Warehouse
  • Describe the key features of SSIS
  • Implement a data flow by using SSIS
  • Implement control flow by using tasks and precedence constraints
  • Create dynamic packages that include variables and parameters
  • Debug SSIS packages
  • Describe the considerations for implement an ETL solution
  • Implement Data Quality Services
  • Implement a Master Data Services model
  • Describe how you can use custom components to extend SSIS
  • Deploy SSIS projects
  • Describe BI and common BI scenarios


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. 


In addition to their professional experience, students who attend this training should already have the following technical knowledge: 

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of relational databases.
  • Some experience with database design.

Suggested prerequisites courses:

Career path:

IT Ops & Management Career Path…

More Information
Lab AccessYes
Learning StyleVirtual Instructor-Led
Course Duration5 Days
SATV Value5 Days
VPA EligibleVPA Eligible
Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account
Why QuickStart

Turn Training Into A Personalized Learning Experience

  • Project Problem Solving through ExpertConnect & Peer-To-Peer Learning
  • Career Paths - Find The Quickest Path To What You Need To Learn
  • One Subscription, All Access - Take Multiple Courses & Become An Expert
  • Manage Your Organization Through Learner & Manager Analytics
  • Virtual Instructor-Led Training Supplemented With Self-Paced Learning
  • Integrate With Your LMS Through API's

Sales Support

Sales (866) 991-3924

Mon-Fri. 8am-6pm CST


Ask A Learning Concierge