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

CERTIFICATES

Data Integration and Transformation (ETL)
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

  • Data Integration and Transformation (ETL)

    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.
  • Data Integration and Transformation (ETL)

    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.
  • Data Integration and Transformation (ETL)

    Tax Credit

    Claim up to 25% of tuition fees and education tax credit.
  • Data Integration and Transformation (ETL)

    Discount on Certification Voucher

    Upto 50 percent discount voucher will be provided.
  • Data Integration and Transformation (ETL)

    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 on column store indexes in Microsoft BI covers their implementation for optimizing data retrieval and analytics. It explores how column store indexes enhance query performance by storing data in a columnar format, facilitating faster analytics and aggregation operations. Students learn to leverage column store indexes in Microsoft BI for efficient data scanning and analytical workloads, improving overall query performance in business intelligence scenarios.

In this module, students explore the advantages of Azure SQL Data Warehouse, understanding its scalability and integration benefits. They then delve into implementing and developing Azure SQL Data Warehouse, learning setup, database design, and optimization techniques.

In this module, users explore SSIS to craft efficient ETL solutions, mastering data extraction, transformation, and loading. They learn to design workflows, configure data flow tasks, and implement transformations for seamless data movement within SQL Server environments. The curriculum focuses on leveraging SSIS for robust ETL processes, enabling users to build scalable data pipelines.

This module introduces Control Flow, focusing on managing program execution through loops, conditionals, and branching. It covers the fundamentals of directing logical pathways within code, enabling students to apply control flow statements for effective program control and decision-making. Students gain a foundational understanding of how control structures govern code execution and logical pathways in programming.

Debugging and Troubleshooting SSIS Packages involve identifying and resolving issues within SQL Server Integration Services workflows. Students learn techniques to identify errors, monitor package execution, and resolve common SSIS errors using tools like breakpoints and data viewers.

Implementing an Incremental ETL (Extract, Transform, Load) Process involves designing workflows that update only the changed or new data since the last ETL run. Students learn to create strategies and methodologies within SSIS or other ETL tools to identify, extract, transform, and load only the incremental changes, minimizing processing time and resource utilization.

Within this module, students explore methodologies to enforce and maintain data quality standards. They learn techniques in SSIS or ETL tools for data validation, cleansing, and error handling. The curriculum covers data profiling, applying constraints, and cleansing practices to ensure high-quality, reliable data for operational and analytical use.

This module introduces Master Data Services (MDS), covering its role in centralizing and managing organizational master data. Students explore creating data models, managing entities, and implementing data governance within MDS. The curriculum focuses on MDS fundamentals, emphasizing its capacity to ensure data consistency and reliability across the organization.

In this module, students learn the process of deploying and configuring SSIS packages for production environments. They explore deployment strategies, package configurations, and security considerations within SQL Server Integration Services. The curriculum covers best practices for deploying, configuring, and securing SSIS packages, ensuring smooth and efficient execution in enterprise environments.

This module guides students in effectively accessing and utilizing data stored in a data warehouse. It covers querying, reporting, and extracting insights from warehouse data using different tools and methodologies. Students learn how to leverage data for business intelligence, analytics, and reporting purposes, enhancing their understanding of data utilization within a warehouse context.

SKILLS ACQUIRED

WHO SHOULD APPLY?

This certificate is ideal for database professionals who are looking to fulfill 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 take this certification course.

ETL Development with SQL Server and SSIS Certification.

 

Upon completing this certification 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.