This module is designed for those who want to learn how to implement a data warehouse and perform ETL (Extract Transform and Load) using SQL Server Integration Services (SSIS).

At the end of this module, participants should be able to:

• Connect to multiple data sources
• Extract data from multiple sources
• Save data temporarily in a staging database
• Transform data in staging database
• Load transformed data into the data warehouse
• Create SSIS packages
• Understand and work with variables, expressions, parameters and environmental variables
• Carry out various types of data transformation
• Build incremental ETL
• Deploy and configure SSIS packages