Microsoft Authorized

20767: Implementing a SQL Data Warehouse (SQL Server 2016)

15,19,22

Microsoft authorized training partner
Live online + classroom batches every week
Includes official courseware and exam voucher
Hands-on labs and full-length mock exams
30-day re-attendance guarantee + advisor support

Group Enrollment with Friends or Colleagues | Get a quote

20767: Implementing a SQL Data Warehouse (SQL Server 2016) training context photo

4,371 Ratings

11.4K

Learners

Official Training Partner

Microsoft

Course Overview

20767: Implementing a SQL Data Warehouse (SQL Server 2016) Course Overview

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® 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 course is based on the objectives of the course version 20767B.

20767: Implementing a SQL Data Warehouse (SQL Server 2016) Course Key Features

100% Money Back Guarantee

Official courseware + exam voucher included
Live online + classroom format options
Hands-on labs and real-world case studies
Simulation tests at the end of training
Up-to-date curriculum aligned to the latest exam version
Includes 5 mock exams, 150 questions each
24×7 learner assistance and support
30-day re-attendance guarantee

Skills Covered

Risk management & governance
Identity and access management
Security architecture & engineering
Communication and network security
Asset security
Security assessment & testing
Security operations
Software development security

Next Cohort Starts On 2 Jul

Days: --
Hours: --
Minutes: --
Seconds: --

Corporate Training

Enterprise training for teams — private cohorts, custom curriculum, L&D reporting.

Explore corporate plans

Benefits

Why this certification pays off

Certified professionals in this domain are in active demand across IT services, banking, and government. Click a designation to see the salary range and the companies hiring most actively for that role.

Designation

Annual Salary (USD)

Source: Glassdoor (indicative)

Hiring Companies

IBM
Vodafone
Cisco
Accenture
Deloitte
TCS

Source: Indeed

Training Options

Pick the format that fits your week

Three ways to take this course — all include official courseware, hands-on labs, and full certification support.

Preferred
Online Bootcamp
Live Instructor-Led
Live cohort over Zoom/Teams.
- Flexi Pass: reschedule within 90 days
- Live online classes recorded for later review
- Includes self-paced e-learning content
- 24×7 learner assistance and support
- Aligned to the latest exam version
Batch starting from
- • 2 Jul 2026, Weekday Class
- • 23 Jul 2026, Weekend Class
View all schedules
25% Off
$1,499$1,999
Enroll Now
Classroom Batch
In-Person Cohort
Full-day immersive training at our hubs.
- Eight hours daily, in-person delivery
- Available in Dubai, Delhi, Mumbai, London, Singapore
- Printed manuals + exam vouchers included
- Lunch, refreshments, hotel pickup at partner hubs
- Exam can be booked onsite at partner test centres
Batch starting from
- • 2 Jul 2026, Classroom Batch (Dubai)
- • 23 Jul 2026, Classroom Batch (Delhi)
View all schedules
17% Off
$2,499$2,999
Enroll Now
Corporate Training
Private Team Cohort
Upskill or reskill your team — on-site, online, or hybrid.
- Blended delivery — self-paced + live + on-site
- Custom curriculum tailored to your tech stack
- Enterprise-grade LMS integration (SCORM / xAPI)
- Dashboards for L&D leaders + per-team reporting
- NDA-friendly, procurement-ready
Pricing
Custom Quote
Volume discounts at any seat count.
Contact Us

Curriculum

Course Curriculum

Eligibility, prerequisites, and a module-by-module breakdown of what you'll cover.

Eligibility

Designed for working professionals with foundational experience in the discipline. A post-secondary degree in computer science, IT, business, or related fields may substitute for up to one year of experience. Part-time work, internships, or relevant certifications can also count toward the requirement.

Pre-requisites

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

Course modules

Click any module to expand the key topics covered.

Module 01 — Introduction & Foundations

Course overview, key terminology, and the foundational concepts every subsequent module builds on.

Key topics

Domain overview
Core terminology
Industry context
Career pathways

Module 02 — Core Frameworks & Standards

The governing frameworks, methodologies, and industry standards that define professional practice.

Key topics

Major frameworks
Industry standards
Compliance landscape
Best-practice checklists

Module 03 — Tooling & Hands-on Labs

The tools, platforms, and lab environments you'll use during and after the course.

Key topics

Tool overview
Lab environment setup
Common workflows
Troubleshooting basics

Module 04 — Real-world Application

Case studies, real client scenarios, and pattern recognition for the situations you'll actually face.

Key topics

Case studies
Client scenarios
Pattern recognition
Decision frameworks

Module 05 — Assessment & Quality

How professionals in this domain assess, validate, and report on the quality of their work.

Key topics

Assessment techniques
Quality control
Reporting standards
Stakeholder updates

Module 06 — Exam Preparation & Beyond

Targeted exam-prep, mock tests, and the post-certification roadmap for career advancement.

Key topics

Exam patterns + tips
Full-length mock exams
Post-cert career paths
Continuing professional development

Exam & Certification

How the official exam works

After course completion, your training advisor helps you schedule the official certification exam — booking the test centre, sending practice mock exams, and supplying the exam voucher at partner pricing where applicable. Pass on first attempt and you'll receive both the official vendor certificate and your SkillCertified completion certificate.

Exam duration
3–6 hours
Questions
100–150
Passing score
70%+
Validity
3 years

Sample SkillCertified Certificate of Course Completion

Sample SkillCertified certificate of completion

Get in touch

Still have questions about
20767: Implementing a SQL Data Warehouse (SQL Server 2016)?

Tell us a bit about yourself — an advisor will reach out within one business hour with answers, schedules, and any group-pricing options.

1-hour response promise
Real humans, not chatbots
No-obligation consultation

Request More Information

Related Programs

20767: Implementing a SQL Data Warehouse (SQL Server 2016)

20767: Implementing a SQL Data Warehouse (SQL Server 2016) Course Overview