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.
- What you'll learn
- Course Description
- Course Outline
- Instructor
- System Requirements
- What to know beforehand
What you'll learn
This course includes:
- 8+ hours hours of training
- Access on mobile and browser
- Certificate of Completion
Course Description
This course includes:
- 8+ hours hours of training
- Access on mobile and browser
- Certificate of Completion
Course Outline
Advanced SSIS - What you need to get started
Module 00 - Class Introduction 4 min.
Module 01A - Loading a Data Warehouse (Why a Data Warehouse) 18 min.
Module 01B - Loading a Data Warehouse (Loading a Dimension Table) 27 min.
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 hours of training
- Access on mobile and browser
- Certificate of Completion
Instructor
Mitchell Pearson has been with Pragmatic Works for 11 years as a Data Platform Consultant, Trainer and Team Lead. Mitchell has authored books on SQL Server, Power BI and the Power Platform. Data Platform experience includes designing and implementing enterprise level Business Intelligence solutions with the Microsoft SQL Server stack (T-SQL, SSIS, SSAS, SSRS), the Power Platform, Microsoft Azure and Fabric.
This course includes:
- 8+ hours hours of training
- Access on mobile and browser
- Certificate of Completion
System Requirements
This course includes:
- 8+ hours hours of training
- Access on mobile and browser
- Certificate of Completion
What to know before class
This course includes:
- 8+ hours hours of training
- Access on mobile and browser
- Certificate of Completion