UMSL logo

Computer Education & Training Center

Transact-SQL

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.

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

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

SQL Programming, Level 1

(Prerequisite: Intermediate Applications of SQL or equivalent experience. If you do not have any programming experience, it is recommended that you take the Introduction to Programming Concepts course.) This course introduces SQL Server programming using Transact-SQL. 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
E1145 Thurs., Nov. 5 & Fri., Nov. 6Virtual/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
E1146 Thurs., Nov. 19 & Fri., Nov. 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 Server Integration Services, SQL Server Administration, and SQL Server Relational Database Design.