Modules

SQL Server Integration Services (SSIS)

 

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
Course Level Duration
Advanced 8 days (40 Hours)
 
Pre-requisite Tools and Technologies
Database Design, SQL (Advanced), Data Warehouse Architecture Microsoft SQL Server, SQL Server Data Tools
 
Original Price Now Price
£1800 £1300