UMSL logo

Computer Education & Training Center

SQL Integration Services

SQL Server Integration Services Classes

When considering data migration, data integration, or data warehousing, using SQL Server Integration Services (SSIS) can assist in the process. By building enterprise extraction, transformation, and loading solutions (ETL), you can perform SSIS maintenance and updates.

Introduction to SQL Server Integration Services

(Prerequisite: Introduction to SQL or equivalent experience.) This course introduces the Business Intelligence Development Studio within SQL Server Data Tools and the use of various elements in building an ETL package, including Control Flow elements, Data Flow tasks, and Connection Managers. Topics covered include building an SSIS package using Control Flow tasks, Data Flow tasks and Connection Managers. You will also work with Derived Column Transformation to concatenate data located in multiple columns. Additional topics include Sequence Containers, Conditional Split Transformations, and Data Viewers. [Course Outline]
Fee: $239

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E8126 Thurs., Sept. 21West CountyFrank Richey
E8352 Tues., Dec. 5West CountyFrank Richey

Intermediate SQL Server Integration Services

(Prerequisites: Introduction to SSIS or equivalent experience.) In this class, you will build on the skills gained in the introductory SSIS course. Learn to work with SSIS variables, parameters and expressions to add flexibility to the Data Flow tasks and connection managers. Discover how to build an in-memory recordset using the Recordset Destination. Understand how to use the data values of an in memory recordset to loop through a second recordset using a Foreach Loop to perform actions on or with the records of the second recordset. Investigate how to use the Row Count Transformation and a precedent constraint to control the package control flow.  [Course Outline]
Fee: $239

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E8127 Fri., Sept. 22West CountyFrank Richey
E8353 Wed., Dec. 6West CountyFrank Richey

Advanced SQL Server Integration Services

(Prerequisite: Intermediate SSIS or equivalent experience.) Learn the techniques of processing incoming data from one or more sources with the intent of cleansing the data prior to loading the cleansed data into your companys production tables. You will tackle the skills necessary with building or adding to a SSIS package for the purpose data deduplication and correction. Learn how to use the Merge, Merge Join or Union All Transformations to join multiple SQL Server or non-SQL Server data sources. Discover how to use the Lookup and Fuzzy Lookup transformations to locate exact matches between the rows of incoming and existing data sources. [Course Outline]
Fee: $239

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E8128 Thurs., Sept. 28West CountyFrank Richey
E8354 Wed., Dec. 13West CountyFrank Richey

Data Cleansing Using DQS and SSIS

(Prerequisite: Introduction to SSIS or equivalent experience.) Discover how to improve the quality of critical business data through the implementation of SQL Server Data Quality Services (DQS) and Integration Services (SSIS). This course introduces the concepts of improving data quality through data profiling, cleansing, and matching. Learn how to profile the data to aid in identifying any data quality issues that may be present within the data and how to create and manage the knowledge bases which are used in the data quality improvement processes. Additional topics include utilizing data matching to discover and eliminate duplicate data, and using knowledge bases to cleanse and standardize the data in DQS and Integration Services packages.  [Course Outline]
Fee: $239

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E8129 Fri., Sept. 29West CountyFrank Richey
E8355 Thurs., Dec. 14West CountyFrank Richey

If you would like to register for a course, call (314) 984-9000 or register online.

Classes are also available in the SQL Language that cover SQL syntax and beginning through advanced commands and queries.

You may also be interested in other SQL Server classes including SQL Server Reporting Services, SQL Programming (Transact-SQL), SQL Server Administration, and SQL Server Relational Database Design.