My friends at TechniTrain, the students, and I had a blast during the March 2012 London delivery of From Zero To SSIS! We have decided to do it again in September 2012 with my new Learning SSIS 2012 3-day course!
Please find a course outline here. It is difficult to list everything I cover in the course, but the outline hits the high spots.
This material grew out of my experiences serving as a consultant on short-term engagements and as a manager (and enterprise ETL architect) for a team of forty data integration developers building concurrent, long-term projects in a global enterprise. The information is practical and actionable. I share my mistakes and pain points, hoping students will learn as much from my errors as I did. It is a hands-on course because I believe nothing reinforces hearing like doing. The course is not a survey of all the functionality included in SSIS 2012. Instead, it focuses a proportionate amount of time (and laboratory exercises) on the components of SSIS the data integration developer will use.
The course focuses on data integration development topics during the first section. Data integration topics include a lot of material about the SSIS Data Flow Task (Why? Because SSIS was built to move data.). I also cover Control Flow topics including work flow, Containers, Precedence Constraints, and Loop Containers. The second section covers the topics of Security, Deployment, Execution, Logging, Configurations, SSIS Design Patterns, and ETL Frameworks.
I hope to see you in London 12-14 Sep 2012! Should you have any questions about the course, please contact me by clicking the Email link in the upper right corner of this page.
You may register for the SSIS course here.