Advanced SSIS

Module 0 - 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)
 Module 01D - Loading a Data Warehouse (Loading a Type 2 Dimension)
 Module 01E - Loading a Data Warehouse (Upsert Pattern)
 Module 01F - Loading a Data Warehouse (Scaling Out Dimension Loads)
 Module 02 - Loading a Fact Table
 Module 03A - Incremental Load Pattern (Using a Control Table)
 Module 03B - Incremental Load Pattern (Change Data Capture)
 Module 04A - Performance Tuning (Source Optimization)
 Module 04B - Performance Tuning (Transform Optimization)
 Module 04C - Performance Tuning (Destination Optimization)
 Module 05A - Scaling out SSIS (Process Task)
 Module 05B - Scaling out SSIS (Process Tasks with T-SQL)
 Module 06A - Restartability Patterns in SSIS (Checkpoints)
 Module 06B - Restartability Patterns in SSIS (Transactions)
 Module 07A - SSIS Scripting (Basics)
 Module 07B - SSIS Scripting (Common Examples)
 Module 08A - Data De-Duplication (Fuzzy Grouping)
 Module 08B - Data De-Duplication (Fuzzy Lookup)
 Module 09A - Advanced Design Patterns (Term Extraction)
 Module 09B - Advanced Design Patterns (Unpivot Transform)
 Module 09C - Advanced Design Patterns (Data Mining)
 Module 10A - SSIS Administration (Deployment)
 Module 10B - SSIS Administration (Environments)
 Module 11A - Data Quality (Data Profiling Task)
 Module 11B - Data Quality (Data Quality Services)