55321 Data Analyst

SQL Server Integration Services

The SQL Server Integration Services (SSIS) course provides a comprehensive overview of SSIS, a powerful data integration and workflow application platform for SQL Server. Students will learn to use the Import/Export Wizard, work with solutions and projects, understand basic control flow, and explore common tasks. The course delves into data flow sources, destinations, transformations, dynamic package creation, containers, troubleshooting, and package reliability. Additionally, students will learn how to deploy to the SSIS Catalog, install and administer SSIS, and secure the SSIS Catalog. Throughout the course, hands-on labs help students gain practical experience and apply their knowledge to real-world scenarios.

Prerequisites

Participants should have an understanding of databases and have taken the Introduction to SQL Databases course before taking this course.

Course Modules

1. SSIS Overview
2. Working with Solutions and Projects
3. Basic Control Flow
4. Common Tasks
5. Data Flow Sources and Destinations
6. Data Flow Transformations
7. Making Packages Dynamic
8. Containers
9. Troubleshooting and Package Reliability
10. Deploying to the SSIS Catalog
11. Installing and Administering SSIS
12. Securing the SSIS Catalog