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

Rating:
93% of 100
This 5-day instructor led course describes how to implement a data warehouse platform to support a BI solution.
  • Virtual Classroom

    Learning Style
  • Intermediate

    Difficulty
  • 5 Days

    Course Duration
  • 5 Days

    SATV Value
Upcoming Dates
When you subscribe, you get:
Master subscription plan gives you access to this course PLUS:

  • 640+ high impact technical, end user and leadership courses
  • Includes courses in multi-modality - online self-paced + Virtual Classroom courses
  • Peer to peer learning and access to expert mentors
  • Learner and Manager Analytics
  • Access to Cognitive Learning Research platform to troubleshoot project issues
7-Day FREE Trial
On Sale!
Now Only $1,999.00 Regular Price $3,499.00
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.)
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

Audience:

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. 

Prerequisites:

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:

More Information
Brand Microsoft
Lab Access Yes
Technology Microsoft
Learning Style Virtual Classroom
Difficulty Intermediate
Course Duration 5 Days
Language English
SATV Value 5 Days
VPA Eligible VPA Eligible
Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account
Sales Support

Sales (866) 991-3924

Mon-Fri. 8am-6pm CST

Have Questions? Ask Us.

Why QuickStart

Turn Training Into A Personalized Learning Experience


  • Problem Solving through ExpertConnect & Peer-To-Peer Learning
  • Find The Quickest Path To Learn With Career Paths
  • Access All Courses With Master Subscription
  • Manage Your Team With Learning Analytics
  • Virtual Classroom Training & Self-Paced Learning
  • Integrate With Your LMS Through API's