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 |