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.

Virtual Classes: Our SQL Integration Services (SSIS) classes are now available online with an instructor present for the entire course. You will see the instructor's screen throughout the class and you can share your screen if you need individual help from the instructor. You will have time to practice, ask questions, and receive hands-on training. During class, you will be able to access our SQL Server in order to learn SQL.

In-person classes are also available at our West County facility with limited enrollments to promote social distancing. When you register, choose your class section based on how you want to attend the class: virtual or in-person.

  • Select Live Online" if you want to attend virtually from your workplace or home.
  • Choose "West County In-Person" if you want to attend a class at our West County location.

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 include building an SSIS package using Control Flow tasks, Data Flow tasks, and Connection Managers. You will work with Derived Column Transformation to concatenate data located in multiple columns. Other topics include Sequence Containers, Conditional Split Transformations, and Data Viewers.  [Course Outline]
Fee: $279

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E2674 Thurs., Mar. 3Virtual/WCBeth Arrowsmith

Intermediate SQL Server Integration Services

(Prerequisites: Introduction to SSIS or equivalent experience.) 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: $279

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E2675 Fri., Mar. 11Virtual/WCBeth Arrowsmith

Advanced SQL Server Integration Services

Data Cleansing Using SSIS and DQS. (Prerequisite: Intermediate 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 an Integration Services package and DQS packages.  [Course Outline]
Fee: $279

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E2676 Fri., Mar. 18Virtual/WCBeth Arrowsmith

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 and SQL Programming (Transact-SQL).

For more information, please email info@cetc.umsl.edu.