Accelerated SQL Server 2016 Integration Services.

About This Course

Course Code

Course Type


4 Days


Course Overview


This 4-day instructor led training focuses on developing and managing SSIS 2012 in the enterprise. In this course, you will understand how to design, develop, deploy, and operate SSIS solutions—this involves ETL solutions (extraction, transformation, and loading) from source systems extractions, data integration, SSIS server administration and package execution.

Target Audience

This course is intended for database professionals that are responsible for ETL or DBA activities related to data processing, data architecture planning, or SSIS administration.

The target audience for this session is IT professionals, DBAs and developers who want to learn the details of how to use SSIS to accomplish data integration, data warehouse loading, and how to administer SSIS through the development lifecycle to production.


Course Outline

SECTION A: DW and SSIS Overview and SSIS Core Features

Module 01: SSIS Overview and Core Features

Module 02: Data Warehousing

Module 03: SSIS Control Flow Objects and Features

Module 04: Extracting, Transforming and Loading data using SSIS Data Flows

SECTION B: Applying SSIS to Common Operations

Module 05: Working with Files, Importing and Exporting File Data

Module 06: Optimizing Data Extraction and Data Loading

Module 07: Data Quality and Cleasing

Module 08: Advanced Enterprise Information Management

SECTION C: Applying SSIS in BI and Data Warehouse Solutions

Module 09: Dimension ETL with SSIS

Module 10: Fact ETL with SSIS

Module 11: Project Deployment Model: Execution and Reporting

Module 12: Processing SSAS Objects in SSIS

SECTION D: Deployment

Module 13: Project Deployment

Module 14: Package Deployment

SECTION F: SSIS Solution and Performance Considerations

Module 15: Transactions and Restartability

Module 16: Optimization and Scalability


Dates & Prices

Monday 20th September 2021


Monday 20th September 2021


Monday 6th December 2021


Monday 6th December 2021