Advanced SSIS Training Class

Advanced SSIS training class with Tim Mitchell

The Advanced SSIS training course is designed for ETL professional with at least 2 years experience using SSIS. This can be either a 3- or 4-day course, depending on whether lab exercises are included.

Advanced SSIS Training Class (3- or 4-day course)

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, I will illustrate and demonstrate design patterns to help bring you to the next level in your SSIS skillset.  In this course, I will discuss and demonstrate advanced SSIS concepts including:

• Data flow internals
• Performance design patterns
• Learning how to fail properly
• Security in SSIS
• Deployment design patterns
• Data quality
• Metadata management patterns
• Biml
• Known limitations of SSIS, and workarounds for them
• ETL data edge cases

This course is designed for data professionals with some experience (at least 1 year) with developing and maintaining SQL Server Integration Services assets. The courseware contains optional lab exercises for attendees to follow along. In addition, the advanced SSIS training class can be coupled with a consulting engagement (for private classes), during which I train attendees and then immediately help them start applying some of what they’ve learned on their own systems.

This course is available via onsite delivery at your company, or occasionally as a public class. Public classes will be announced in advance on my blog and in my newsletter.