SQL Integration Services (SSIS) – Advanced


Return to schedule


Course Title SQL Integration Services (SSIS)- Advanced
Course number 900-092-EQ-02
Platform Windows
Duration 14 hours
Prerequisites SQL Server Integration Services (SSIS) – Introduction
Target Audience This course is not designed for students who are new to SQL Server BI technologies; It is targeted at BI professionals with experience of implementing solutions with SQL Server database Engine, SQL Server Integration Services, SQL Server Analysis Services, and SQL Server Reporting Services.
Dates March 28, April 4
Instructor Khattar Daou
Room BH-407
Schedule Saturday; 9 a.m. – 4:30 p.m. (30 minute lunch)
Gouvernement du Québec fées (taxes incl.) $28.00
General public fees (taxes incl.) $330.20


Recommended Textbook
Exam Ref 70-767 Implementing a SQL Data Warehouse
Jose Chinchilla, Raj Uchhana
Copyright © 2018 by Pearson Education


Course Description

This training course teaches database and business intelligence (BI) professionals how to plan and design a BI solution that is based on Microsoft SQL Server and other Microsoft BI technologies.

This course describes how to implement a BI platform to support information worker analytics. Students will learn how to create a data warehouse with Microsoft SQL Server, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. 

Please note that this is a non-creditcourse.
NB: Certificate provided for all participants who have completed 80% of course hours
Topics Covered in this Course
Weekly Topics

Please note that the instructor reserves the right to modify this schedule

Module 1 Overview of Data Warehousing

This module provides an introduction to the key components of a data warehousing solution and the high-level considerations that you must take into account when you embark on a data warehousing project.

After completing this module, you will be able to:

•       Describe the key elements of a data warehousing solution
•       Describe the key considerations for a data warehousing project.

Module 2 Designing and Implementing a Data Warehouse

In this module, you will learn how to implement the logical and physical architecture of a data warehouse based on industry-proven design principles.

After completing this module, you will be able to:

•       implement a logical design for a data warehouse
•       implement a physical design for a data warehouse

Module 3


Creating an ETL Solution with SSIS

This module discusses considerations for implementing an ETL process, and then focuses on Microsoft SQL Server Integration Services (SSIS) as a platform for building ETL solutions.

After completing this module, you will be able to:

•     Describe the key features of SSIS
•     Explore source data for an ETL solution
•     Implement a data flow by using SSIS