TOIT Training

Log in

Menu
Contact Sales
Roadmap

Advanced SSIS

Last updated: May 6, 2026

Overview

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.

Curriculum

  • 29 Sections
  • 0 Lessons
  • 8 Hours
Expand all sectionsCollapse all sections
  • 01. Class Introduction
    0
    • 02. Loading a Data Warehouse (Why a Data Warehouse)
      0
      • 03. Loading a Data Warehouse (Loading a Dimension Table)
        0
        • 04. Loading a Data Warehouse (Loading a Type 1 Dimension)
          0
          • 05. Loading a Data Warehouse (Loading a Type 2 Dimension)
            0
            • 06. Loading a Data Warehouse (Upsert Pattern)
              0
              • 07. Loading a Data Warehouse (Scaling Out Dimension Loads)
                0
                • 08. Loading a Fact Table
                  0
                  • 09. Incremental Load Pattern (Using a Control Table)
                    0
                    • 10. Incremental Load Pattern (Change Data Capture)
                      0
                      • 11. Performance Tuning (Source Optimization)
                        0
                        • 12. Performance Tuning (Transform Optimization)
                          0
                          • 13. Performance Tuning (Destination Optimization)
                            0
                            • 14. Scaling out SSIS (Process Task)
                              0
                              • 15. Scaling out SSIS (Process Tasks with T-SQL)
                                0
                                • 16. Restartability Patterns in SSIS (Checkpoints)
                                  0
                                  • 17. Restartability Patterns in SSIS (Transactions)
                                    0
                                    • 18. SSIS Scripting (Basics)
                                      0
                                      • 19. SSIS Scripting (Common Examples)
                                        0
                                        • 20. Data De-Duplication (Fuzzy Grouping)
                                          0
                                          • 21. Data De-Duplication (Fuzzy Lookup)
                                            0
                                            • 22. Advanced Design Patterns (Term Extraction)
                                              0
                                              • 23. Advanced Design Patterns (Unpivot Transform)
                                                0
                                                • 24. Advanced Design Patterns (Data Mining)
                                                  0
                                                  • 25. SSIS Administration (Deployment)
                                                    0
                                                    • 26. SSIS Administration (Environments)
                                                      0
                                                      • 27. Data Quality (Data Profiling Task)
                                                        0
                                                        • 28. Data Quality (Data Quality Services)
                                                          0
                                                          • 29. Master Child Design Pattern
                                                            0

                                                            Instructor

                                                            User Avatar
                                                            ToIT
                                                            2 Students
                                                            1351 Courses
                                                            course thumbnail
                                                            Free
                                                            Student:
                                                            0 Students
                                                            Lesson:
                                                            0 Lessons
                                                            Duration: 8 Hours
                                                            Quiz:
                                                            0 Quizzes
                                                            Level: Expert