In SQL Server 2005 Microsoft introduced SQL Server Integration Services, SSIS, as the replacement to Data Transformation Services, DTS and the primary ETL tool for developers. Over the past 9 years SSIS has evolved and now includes tasks and transformations for Change Data Capture as well as Data Quality Services. This workshop is meant to serve as a tool to prepare for the Microsoft 70-463 exam, Implementing a Data Warehouse with Microsoft SQL Server 2012, as well as provide a comprehensive source of training for SSIS. As there have been changes in SSIS each session points out the differences between each version of SSIS beginning with 2005 through 2014. This workshop is broken into 12 different modules:
Module 1: Introduction to a Data Warehouse
Module 2: ETL
Module 3: Introduction to SSIS
Module 4: Introduction to Control Flow
Module 5: Connection Managers
Module 6: Introduction to Data Flow
Module 7: Advanced Control Flow
Module 8: Advanced Data Flow
Module 9: SSIS Script Tasks and Components
Module 10: Troubleshooting and Debugging
Module 11: Data Quality Services and Master Data Services
Module 12: Deployment Models
Each module covers specific topics relating to SSIS and data warehousing which are presented in the exam as well as in depth examples and real life demonstrations.
All demonstrations are done using the Adventureworks2012 and AdventureworksDW2012 sample databases available
here
To complete all demonstrations only requires SQL Server Enterprise, Enterprise Evaluation, or Developer Edition
Developer Edition is available here
Course Structure/Cost
Upon registration and payment, you will receive an email with instructions on how to test your system in order to view the sessions, as well as a link that will remain active for the 30 day on-demand period.
The course cost is $169 for full SSWUG.ORG members, $199 for non-members and free for PRO members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, office hours and the ability to email questions to the instructor are included with course purchase only.
Group discounts are also available to companies and organizations. To start the group registration process,
Download group registration/discount form