<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=612681139262614&amp;ev=PageView&amp;noscript=1">
Skip to content

Need help? Talk to an expert: phone(904) 638-5743

Home / SQL Server / Advanced SSIS

Advanced SSIS

Our Advanced SSIS course, ideal for the advanced ETL developer, tackles real-world ETL challenges. Learn effective SSIS usage in your enterprise from experts. Expect comprehensive training with in-depth discussion in many areas.

Free Community Plan View Pricing Plans
  • Course Info
  • Instructor
  • System Requirements
  • What to know beforehand

Course Description

For the advanced ETL developer and the SSIS user looking to become more effective, our Advanced SSIS course teaches how to use SSIS in your enterprise to solve common extract, transform and load (ETL) challenges. Much of this course focuses on implementing common real-world SSIS patterns taught from the experts of SSIS. Be prepared for in-depth SSIS training with advanced discussion in many areas.

Course Outline ( Free Preview)

Advanced SSIS - What you need to get started

Module 00 - Class Introduction

Module 01A - Loading a Data Warehouse (Why a Data Warehouse)

Module 01B - Loading a Data Warehouse (Loading a Dimension Table)

Module 01C - Loading a Data Warehouse (Loading a Type 1 Dimension) 25 min.

Module 01D - Loading a Data Warehouse (Loading a Type 2 Dimension) 18 min.

Module 01E - Loading a Data Warehouse (Upsert Pattern) 21 min.

Module 01F - Loading a Data Warehouse (Scaling Out Dimension Loads) 16 min.

Module 02 - Loading a Fact Table 20 min.

Module 03A - Incremental Load Pattern (Using a Control Table) 26 min.

Module 03B - Incremental Load Pattern (Change Data Capture) 26 min.

Module 04A - Performance Tuning (Source Optimization) 30 min.

Module 04B - Performance Tuning (Transform Optimization) 16 min.

Module 04C - Performance Tuning (Destination Optimization) 10 min.

Module 05A - Scaling out SSIS (Process Task) 26 min.

Module 05B - Scaling out SSIS (Process Tasks with T-SQL) 15 min.

Module 06A - Restartability Patterns in SSIS (Checkpoints) 11 min.

Module 06B - Restartability Patterns in SSIS (Transactions) 16 min.

Module 07A - SSIS Scripting (Basics) 18 min.

Module 07B - SSIS Scripting (Common Examples) 20 min.

Module 08A - Data De-Duplication (Fuzzy Grouping) 20 min.

Module 08B - Data De-Duplication (Fuzzy Lookup) 12 min.

Module 09A - Advanced Design Patterns (Term Extraction) 7 min.

Module 09B - Advanced Design Patterns (Unpivot Transform) 9 min.

Module 09C - Advanced Design Patterns (Data Mining) 10 min.

Module 10A - SSIS Administration (Deployment) 29 min.

Module 10B - SSIS Administration (Environments) 13 min.

Module 11A - Data Quality (Data Profiling Task) 13 min.

Module 11B - Data Quality (Data Quality Services) 22 min.

Module 12 - Master Child Design Pattern 13 min.

This course includes:

  • 8+ hours of training
  • 30 Modules
  • * Access on mobile and browser
  • Certificate of Completion
Free Community Plan View Pricing