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.
Overview
COURSE DIFFICULTY
COURSE DURATION
8h 10m
Skills Learned
After completing this online training course, students will be able to:
Build ETL packages using SQL Server Integration Services
Write T-SQL queries for data retrieval and manipulation
Optimize query and server performance
Implement data quality processes with Data Quality Services
Data Engineers, SQL Developers
Foundational SQL Server knowledge
01. Class Introduction
02. Loading a Data Warehouse (Why a Data Warehouse)
03. Loading a Data Warehouse (Loading a Dimension Table)
04. Loading a Data Warehouse (Loading a Type 1 Dimension)
05. Loading a Data Warehouse (Loading a Type 2 Dimension)
06. Loading a Data Warehouse (Upsert Pattern)
07. Loading a Data Warehouse (Scaling Out Dimension Loads)
08. Loading a Fact Table
09. Incremental Load Pattern (Using a Control Table)
10. Incremental Load Pattern (Change Data Capture)
11. Performance Tuning (Source Optimization)
12. Performance Tuning (Transform Optimization)
13. Performance Tuning (Destination Optimization)
14. Scaling out SSIS (Process Task)
15. Scaling out SSIS (Process Tasks with T-SQL)
16. Restartability Patterns in SSIS (Checkpoints)
17. Restartability Patterns in SSIS (Transactions)
18. SSIS Scripting (Basics)
19. SSIS Scripting (Common Examples)
20. Data De-Duplication (Fuzzy Grouping)
21. Data De-Duplication (Fuzzy Lookup)
22. Advanced Design Patterns (Term Extraction)
23. Advanced Design Patterns (Unpivot Transform)
24. Advanced Design Patterns (Data Mining)
25. SSIS Administration (Deployment)
26. SSIS Administration (Environments)
27. Data Quality (Data Profiling Task)
28. Data Quality (Data Quality Services)
29. Master Child Design Pattern
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Build ETL packages using SQL Server Integration Services
Write T-SQL queries for data retrieval and manipulation
Optimize query and server performance
Implement data quality processes with Data Quality Services
WHO SHOULD ATTEND
Data Engineers, SQL Developers
PREREQUISITES
Foundational SQL Server knowledge
COURSE OUTLINE
01. Class Introduction
02. Loading a Data Warehouse (Why a Data Warehouse)
03. Loading a Data Warehouse (Loading a Dimension Table)
04. Loading a Data Warehouse (Loading a Type 1 Dimension)
05. Loading a Data Warehouse (Loading a Type 2 Dimension)
06. Loading a Data Warehouse (Upsert Pattern)
07. Loading a Data Warehouse (Scaling Out Dimension Loads)
08. Loading a Fact Table
09. Incremental Load Pattern (Using a Control Table)
10. Incremental Load Pattern (Change Data Capture)
11. Performance Tuning (Source Optimization)
12. Performance Tuning (Transform Optimization)
13. Performance Tuning (Destination Optimization)
14. Scaling out SSIS (Process Task)
15. Scaling out SSIS (Process Tasks with T-SQL)
16. Restartability Patterns in SSIS (Checkpoints)
17. Restartability Patterns in SSIS (Transactions)
18. SSIS Scripting (Basics)
19. SSIS Scripting (Common Examples)
20. Data De-Duplication (Fuzzy Grouping)
21. Data De-Duplication (Fuzzy Lookup)
22. Advanced Design Patterns (Term Extraction)
23. Advanced Design Patterns (Unpivot Transform)
24. Advanced Design Patterns (Data Mining)
25. SSIS Administration (Deployment)
26. SSIS Administration (Environments)
27. Data Quality (Data Profiling Task)
28. Data Quality (Data Quality Services)
29. Master Child Design Pattern
