SSIS Training in Lyon

SQL Server Integration Services (SSIS) serves as a key component of Microsoft SQL Server, offering a robust platform for data integration and workflow applications. It is primarily utilized for data migration, warehousing, and transformation tasks.

This instructor-led live training (available online or on-site) targets intermediate-level data professionals and developers eager to master the design of advanced SSIS data flows, transformations, and the management of Slowly Changing Dimensions (SCD) within data warehousing contexts.

Upon completion of this training, participants will be equipped to:

• Design and implement resilient data flows using SSIS.
• Interact with diverse data sources, destinations, and transformation components.
• Implement Slowly Changing Dimensions (SCD) to manage historical data changes.
• Effectively deploy, execute, and troubleshoot SSIS packages.

Course Format

• Interactive lectures and discussions.
• Extensive exercises and practical practice.
• Hands-on implementation within a live-lab environment.

Customization Options

• To request a customized training session for this course, please contact us to make arrangements.

This instructor-led, live training in Lyon (online or onsite) is aimed at beginner-level data professionals who wish to learn how to design, implement, and manage SSIS packages to perform data integration and transformation tasks.

By the end of this training, participants will be able to:

• Understand the architecture and components of SSIS.
• Design and implement ETL processes using SSIS.
• Use SSIS tools to develop, deploy, and manage data integration solutions.
• Troubleshoot and optimize SSIS packages for performance and reliability.

This instructor-led, live training in Lyon (online or onsite) is designed for developers and database administrators at beginner to intermediate levels who wish to develop proficiency in SQL Server 2012 Integration Services.

By the end of this training, participants will be able to:

• Grasp the core principles of ETL and the role of SSIS.
• Create, deploy, and manage SSIS packages.
• Design and implement Control Flow to define the sequence of tasks within a package.
• Implement Workflow and configure constraints to ensure effective task execution.
• Construct Data Flows to extract, transform, and load data.
• Utilize Variables and Containers to increase package flexibility.
• Manage Transactions to maintain data consistency.
• Implement robust error handling and debugging techniques.
• Set up Logging for tracking and monitoring purposes.
• Handle Slowly Changing Dimensions to manage evolving data.
• Deploy a Package for production use.
• Implement Security measures to safeguard sensitive data.
• Utilize Scripting to extend SSIS functionality.
• Apply Best Practices for building efficient and maintainable SSIS solutions.