IESSIS2: Immersion Event on Advanced SQL Server Integration Services
(Retired – no longer offered as a public class)
This 400-level, 5-day, advanced SSIS training class was created to help technology professionals take their SQL Server Integration Services (SSIS) skills to the next level. Developed by Tim Mitchell and Andy Leonard, the training is focused around lectures and emphasizes a demonstration approach.
If you are looking to take your SQL Server Integration Services (SSIS) skills to the next level, this course is for you. From data flow internals to error handling patterns, and auditing/logging to catalog customization, we will illustrate and demonstrate SSIS Design Patterns to help bring you to the next level in your SSIS skill set.
Target audience: Database professionals, application developers, and business intelligence practitioners interested in expanding their existing SSIS skill set.
Prerequisites: One year experience with SQL Server and SQL Server Integration Services is required before attending this training.
Instructor: Andy Leonard, Tim Mitchell
Module 1: The SSIS Catalog
- Catalog overview
Module 2: Managing Security in SSIS
- Package security
- Securing sensitive parameters
- Runtime security
- Securing the catalog itself
Module 3: Performance Design Patterns for SSIS
- Overview of SSIS performance
- Troubleshooting methods
- Performance tips
Module 4: What’s New in SSIS 2016
- Overview of new features
Module 5: SSIS Testing Patterns
- Why test?
- Design patterns for test-ready packages
- Design time vs. runtime testing
- Performance testing
- Testing error logic
- Instrumenting SSIS
Module 6: Scripting in SSIS
- Overview of scripting in SSIS
- Scripting tools
Module 7: Managing Data Quality in SSIS
- Overview of Data Quality Services
- Practical applications
Module 8: Data Flow Internals
- Inside the Data Flow
- Incremental Loads
- Performance Strategy
Module 9: Advanced Load Patterns in SSIS
- Incremental loads
Module 10: Error Handling
- What could go wrong?
- Design patterns
- Control Flow tools
- Data Flow tools
Module 11: Gotchas in SSIS
- Problem domains
Module 12: Incremental Load Design Patterns
- What are incremental loads
- Source incremental load patterns
- Destination incremental load patterns
- Slowly-changing dimension patterns
Module 13: Biml
- Biml Language Structure
- BimlScript Language Structure
- Metadata Management
If you have any questions not answered by our F.A.Q., please contact us.