55321AC - SQL Server Integration Services Course Overview

The 55321AC - SQL Server Integration Services (SSIS) course is designed to provide learners with comprehensive knowledge and practical skills to utilize SSIS for data integration, Transformation, and Migration tasks. This course lays the foundation for gaining SQL Server Integration Services certification by taking a deep dive into the capabilities of SSIS, starting with the basics suitable for SSIS for beginners and progressing through to more advanced topics.

Participants will learn to perform data imports/exports, understand and work with Control flow tasks, manage data flow with sources and destinations, apply Transformations, and make packages dynamic using parameters and expressions. Additionally, the course covers advanced topics such as troubleshooting, Package reliability, Deploying to the SSIS catalog, and Administering SSIS solutions.

By the end of the course, learners will be well-versed in Securing the SSIS Catalog and will have hands-on experience through extensive lab exercises, setting them on the path to effectively implementing and managing SSIS solutions in their work environments.