Microsoft/Implementing a SQL 2016 Data Warehouse (SSIS)/20767C/70-767


Implementing a SQL 2016 Data Warehouse (SSIS) Certification Training Course Overview

Implementing SQL Data Warehouse (SSIS) training course imparts core skills on the implementation of data warehouse platform for supporting a BI solution. Participants enrolled for this SQL Data Warehouse certification will learn to create the data warehouse with Microsoft SQL Server 2016 and Azure SQL Data Warehouse. The course also covers the Implementation of ETL using Integration Services, validation and cleansing of data using Data Quality Services and Master Data Services.

Implementing SQL Data Warehouse course is ideal for database professionals, BI developers, and professionals who are responsible for creating BI solutions in an enterprise environment.

SSIS Tasks

SSIS is an ETL tool that performs various operations like loading the data based on need, executes data related calculations and defines a workflow for the process and tasks.

Types of Data Warehouse

There are three types of data warehouse:

  • Operational Data Store – An Operational Data Store (ODS) is a type of database that processes data from multiple sources and sends it to the corresponding operational system and data warehouse. Since an ODS is used to store short term data, it serves as an intermediate database.
  • Enterprise Data Warehouse – An Enterprise Data Warehouse is a common database that holds all the business data and makes it available across the company for analysis and planning purposes.
  • Data Mart – A data mart is responsible for serving a particular group by making the specific set of data available to that group so that the users don’t have to waste their precious time and efforts in searching for the data they need.
This course prepares you for Exam 70-767. Download Course Contents Test your current knowledge Qubits42

Implementing a SQL 2016 Data Warehouse (SSIS) Course schedule & Prices

Course Details Schedule
Live Virtual Classroom (Instructor-Led)
Duration : 5 Days (10 Days for 4 Hours/Day)
Fee : 1,600 (Includes Taxes) 
9 AM - 5 PM (Flexible Time Slots for 4 hours option)






Client's Location
As per mutual convenience
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request

Special Solutions for Corporate Clients! Click here

Special Solutions for Corporate Clients Click here

Get Quote

Course Prerequisites

  • Designing a normalized database.
  • Creating tables and relationships.
  • Querying with Transact-SQL.
  • Some exposure to basic programming constructs (such as looping and branching).


Upon Completion of this Course, you will accomplish following:-

  • Understand the components of a data warehousing solution
  • Implement a logical and physical design to create a data warehouse
  • Implement a physical design for a data warehouse
  • Understand SSIS for implementing data flows
  • Create dynamic packages using parameters and variables
  • Implement Data Quality Services and Master Data Services
  • Implement custom components for extending SSIS
  • Implement Business Intelligence and its common scenarios in this SQL Data Warehouse certification training

Give an edge to your career with Microsoft certification training courses. Students can join the classes for 20767: SSIS Training for Implementing a SQL 2016 Data Warehouse (SSIS) at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.