Montreal College of Information Technology
Collège des technologies de l’information de Montréal English flagEN FlagFR

CERTIFICATES

ETL Development with SQL Server and SSIS
OVERVIEW

This certification course provides the knowledge and abilities needed to set up a Microsoft SQL Server database. The course covers deploying new SQL Server instances and migrating existing installations for both on-premises, Azure SQL Server deployment,  create and implement a data warehouse solution. Students will gain knowledge of how to build a data warehouse with Microsoft SQL Server, execute ETL using SQL Server Integration Services, validate and purge data with SQL Server Data Quality Services, and use SQL Server Master Data Services.

Schedule: Monday, Wednesday, Friday - 6pm - 9pm

KEY FEATURES

  • ETL Development with SQL Server and SSIS

    Get trained by industry Experts

    Our courses are delivered by professionals with years of experience having learned first-hand the best, in-demand techniques, concepts, and latest tools.
  • ETL Development with SQL Server and SSIS

    Official Certification curriculum

    Our curriculum is kept up to date with the latest official Certification syllabus and making you getting ready to take the exam.
  • ETL Development with SQL Server and SSIS

    Tax Credit

    Claim up to 25% of tuition fees and education tax credit.
  • ETL Development with SQL Server and SSIS

    Discount on Certification Voucher

    Upto 50 percent discount voucher will be provided.
  • ETL Development with SQL Server and SSIS

    24/7 Lab access

    Our students have access to their labs and course materials at any hour of the day to maximize their learning potential and guarantee success.

COURSE OUTLINE

ETL Development with SQL Server and SSIS

This module describes data warehouse concepts and architecture consideration.

This module describes the main hardware considerations for building a data warehouse.

This module describes how you go about designing and implementing a schema for a data warehouse.

This module introduces Columnstore Indexes.

This module describes Azure SQL Data Warehouses and how to implement them.

At the end of this module you will be able to implement data flow in a SSIS package.

This module describes implementing control flow in an SSIS package.

This module describes how to debug and troubleshoot SSIS packages.

This module describes how to implement an SSIS solution that supports incremental DW loads and changing data.

This module describes how to implement data cleansing by using Microsoft Data Quality services.

This module describes how to implement master data services to enforce data integrity at source.

This module describes how to extend SSIS with custom scripts and components.

This module describes how to deploy and configure SSIS packages.

This module describes how to debug and troubleshoot SSIS packages.

SKILLS ACQUIRED

WHO SHOULD APPLY?

This certificate is ideal for database professionals who are looking to fulfil a Business Intelligence Developer role looking to focus on creating BI solutions, including Data Warehouse implementation, ETL, and data cleansing.
The certificate is for data professionals and business intelligence professionals who want to learn how to perform data analysis using Power BI accurately.
This certificate is also for individuals who develop reports that visualize data from the data platform technologies in the cloud and on-premises. In addition, the certificate is also great for recent graduates who are looking to expand their skillset into Power BI.
This certificate is also for individuals who develop reports that visualize data from the data platform technologies in the cloud and on-premises. In addition, the certificate is also great for recent graduates who are looking to expand their skillset into Power BI.

Eligibility and Requirements

Learners need to possess an undergraduate degree or a high school diploma.

 

Prerequisite

Knowledge of SQL programming language is required to learn this certification course.

ETL Development with SQL Server and SSIS Certification.

 

Upon completing this cerification course you will:

  • Receive an industry-recognized certificate from MCIT.
  •  
  • Be prepared for the official ETL Development with SQL Server and SSIS Certification.

INSTRUCTOR SPOTLIGHT

CALENDAR

— F.A.Q —

All of our exceptionally skilled instructors have a decent experience of training and industry experience and are AW certified in the respective field. Each of them through a rigorous selection procedure that included profile screening, technical examination, and a training demo. 
Definitely. Please feel free to contact our office, we will be more than happy to work with you to meet your training needs.
Yes, there are vouchers to take the official exam.
Upon completion of the certification course classes you will be provided with an MCIT certificate.