SQL Server Integration Services (SSIS)

Return to schedule

register-button24

Course Title SQL Server Integration Services (SSIS)
Course Number 900-065-EQ
Platform Windows
Duration 21 hours
Gouvernement du Québec fee (taxes incl.)
$42
General Public fee (taxes incl.)
$473.72
Schedule Saturday 9:00 a.m. – 4:30 p.m.
(30 minute lunch)
Dates February 3, 10, 17
Prerequisites SQL Level 2 or working knowledge of relational databases (database design skills
Target Audience Participants interested in acquiring the knowledge and skills needed to implement Microsoft SQL Server Integration Services (SSIS)
Instructor Khattar Daou
Location Brittain Hall – lab BH-214

NB. This is a non-credit course. Certificate provided for all participants who have completed 80% of course hours

*Textbook:

SQL Server 2016 Integration Services Cookbook | Christian Cote | ISBN: 978-1786461827 © 2017 | Packt Publishing Limited.

Course Description:

Microsoft SQL Server Integration Services (SSIS) is a platform for building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.

The primary objective of this course is to provide students with the knowledge and skills to use SSIS Designer to create a simple Microsoft SQL Server Integration Services package. The created package takes then data from a flat file, reformats the data, and then inserts the reformatted data into a fact table.

This course walks you through SSIS Designer to create a simple ETL package that includes looping, configurations, error flow logic and logging.

 

Topics to be covered:

Module 1 – Overview of SQL Server Integration Services

Overview of SSIS

Integration Services (SSIS) Development and Management Tools

Integration Services (SSIS) Projects and Solutions

Install/ Upgrade Integration Services

Change Data Capture (SSIS)

Integration Services (SSIS) Connections

Control Flow

Integration Services Containers

Integration Services Tasks

Precedence Constraints

 

Module 2 – Create a simple ETL package

Create a Project and Basic Package with SSIS

Adding Looping with SSIS

Add Logging with SSIS

Add Error Flow Redirection with SSIS

Add SSIS Package Configurations for the Package Deployment Model

Using Parameters with the Project Deployment Model in SSIS

 

Module 2 – Deploy Packages with SSIS

Preparing to Create the Deployment Bundle

Create the Deployment Bundle in SSIS

Install SSIS Packages

TOP