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.

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

Introduction to SQL Server Integration Services

(Prerequisite: Introduction to SQL or equivalent experience.) This course introduces the Business Intelligence Development Studio and the use of various elements in building an ETL package, including Forloop and Foreach containers, Data Flow tasks, and Connection Managers. Topics covered include Data Flow tasks and Connection Managers. You will also work with Derived Column Transformation to concatenate column data. Additional topics include Sequence Containers and Conditional Split Transformation, Merge Join Transformation including Sort Transformation, tables, procedures, users, schema, triggers, primary keys, foreign keys, and indexes. [Course Outline]
Fee: $239

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E1591 Tues., Apr. 6Virtual/WCBeth Arrowsmith

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. Discover tools helpful when dealing with large amounts of data, including Cache, Lookup, and Row Count Transformations. Practice working with user-created and system variables and learn about SSIS expressions. Understand how the Fuzzy Grouping Transformation can aid data integrity and data cleansing operations. Additional topics include using a Recordset Destination as the source in a Foreach Loop and working with Parameters in OLE DB sources. [Course Outline]
Fee: $239

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E1592 Tues., Apr. 13Virtual/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: $239

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E1593 Tues., Apr. 20Virtual/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, SQL Programming (Transact-SQL), and SQL Server Administration.