Introduction to SSIS
Gain expertise in design, execution, real-world application building in this SSIS class. Hands-on labs, SSIS package creation, ETL challenges. Excel in using SSIS for real-world scenarios.
- Course Info
- Instructor
- System Requirements
- What to know beforehand
Course Description
Course Outline ( Free Preview)
SSIS - What you need to get started
Module 00 - Getting Started
Module 01 - SQL Server Integration Services Overview
Module 02A - Introduction to the Development Environment (Introduction to SQL Server Data Tools) 26 min.
Module 02B - Introduction to the Development Environment (Connection Managers) 17 min.
Module 02C - Introduction to the Development Environment (Precedence Contraints and Control Flow Tasks) 31 min.
Module 03A - Loading Data with the Data Flow (Common Sources) 25 min.
Module 03B - Loading Data with the Data Flow (Common Transforms) 41 min.
Module 03C - Loading Data with the Data Flow (Common Destinations) 31 min.
Module 04A - Using Variables, Parameters and Expressions (Using Variable and Parameters) 16 min.
Module 04B - Using Variables, Parameters and Expressions (SSIS Expression Language and Parameterized Objects) 22 min.
Module 05A - Using Containers (Grouping, Sequence and For Loop Container) 18 min.
Module 05B - Using Containers (For Each Loop Container) 25 min.
Module 06 - Troubleshooting SSIS 16 min.
Module 07A - Loading a Dimension (Designing a Data Warehouse) 37 min.
Module 07B - Loading a Dimension (Loading Dimension Tables) 28 min.
Module 08 - Loading a Fact Table 27 min.
Module 09 - Deploying SSIS Packages 20 min.
Module 10 - Configuring SSIS Packages for Portability 22 min.
Module 11 - SSIS Server Executions 25 min.
Module 12 - Setting Up Auditing and Notification 15 min.
This course includes:
- 7+ hours of training
- 21 Modules
- * Access on mobile and browser
- Certificate of Completion
