UMSL logo

Computer Education & Training Center


Transact-SQL Programming (T-SQL) Classes

Learn SQL programming in the Microsoft environment using Transact-SQL to extend the capabilities of SQL commands.

Virtual Classes: Our SQL Programming 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 Transact-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.

SQL Programming, Level 1

(Prerequisite: Intermediate Applications of SQL or equivalent experience.) This course introduces SQL Server programming using Transact-SQL, Microsoft's proprietary extension to the SQL language. Learn how Transact- SQL can help you increase the flexibility and usefulness of your database applications. Write and execute blocks of code that interact with your SQL Server data by combining SQL statements with Transact-SQL programming constructs. Learn how to declare and reference variables and use cursors to process rows returned by a query. Additional topics include writing conditional and looping structures to control the flow of your statements and using the Try...Catch construct to handle exceptions.  [Course Outline]
Fee: $399

Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
E2525 Tues., Jan. 25 & Wed., Jan. 26Virtual/WCBeth Arrowsmith

SQL Programming, Level 2

(Prerequisite: SQL Programming: Level 1 or equivalent experience.) Extend and apply your knowledge of Transact-SQL by incorporating common programming constructs with various SQL commands and functions. Learn to write practical, reusable functions and call these user-defined functions from SQL expressions. Understand how to use triggers and practice writing triggers that respond to data manipulation events, such as inserting, updating, and deleting records. Additional topics include using output parameters and working with dynamic SQL.  [Course Outline]
Fee: $399

Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
E2526 Tues., Feb. 8 & Wed., Feb. 9Virtual/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 Server Integration and Services.

For more information, please email