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.
- 13 October 2023
- 36 hours
- Request info
- Talk to an Advisor
Schedule: Monday, Wednesday, Friday - 6pm - 9pm
KEY FEATURES
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.
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.
Tax Credit
Claim up to 25% of tuition fees and education tax credit.
Discount on Certification Voucher
Upto 50 percent discount voucher will be provided.
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?
While we encourage all interested applicants to apply, to enter our certification program you must be :
Interested in gaining IT knowledge and enter into real world IT domain, switching carears in IT or applying for entry level positions
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.
