Design, develop, deploy, and operate SQL Server Integration Services (SSIS) solutions.

What Does this Course Cover?

In this course you are going to learn how to use Microsoft SQL Server 2025 Integration Services to automate a variety of data management operations, such as data extraction, transformation and loading, file management, migrating data between data systems, etc. You are also going to gain first-hand experience in Integration Services solution development, deployment, configuration, administration, execution, and monitoring.
This 4-day instructor-led training course focuses on developing and managing automated data management processes in an enterprise. The course is centered around a typical data warehouse management solution implementing the ETL (Extract-Transform-Load) data management concept, where data is extracted from one or more sources, transformed, cleansed, and validated, to finally be loaded into one or more destinations of a data warehouse (or a data mart) for use in Business Intelligence operations.
In the hands-on labs at the end of each module, you are going to learn first-hand how to automate data management operations using Integration Services, as well as how to develop efficient and scalable data warehouse management solutions – either on your own, or as part of a development team.

Target Audience

This course is intended for database professionals in charge of existing ETL or data warehousing solutions, as well as those who are just starting with ETL or data warehousing. The course helps junior developers gain their first experience working with Integration Services, provides seasoned developers with new insights and opportunities to improve their knowledge, and offers development team leads new perspectives on the development of efficient and scalable data management solutions.
The target audience for this session are IT professionals, database administrators, and developers, interested in data integration, data warehouse management, and the delivery of Integration Services solutions from development to production.

Prerequisites

It is recommended that the students are familiar with the Microsoft Windows operating system, its components and services, and the Windows security model.
Basic experience with Microsoft SQL Server, working with databases and data objects, is recommended but not required.
The students should have at least an understanding of business intelligence and data integration at conceptual level.
No prior experience with SQL Server Integration Services is required.

Course Objectives

Upon completion of this course, the student is going to be able to:
• Examine and understand existing SSIS projects and packages.
• Design and develop new SSIS projects and packages.
• Automate file and data management operations.
• Understand and implement ETL concepts in data warehouse maintenance of star-schema (as well as snowflake-schema) data stores, including dimension and fact table ETL.
• Automate data transfer into SQL Server Analysis Services databases.
• Optimize data extraction, transformation, and loading.
• Configure, deploy, administer, execute, and monitor the execution of, SSIS packages.

Course Outline