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.

  • 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 Stored Procedures

(Prerequisite: Intermediate Applications of SQL or equivalent experience. This course introduces SQL Server programming stored procedures. Understand how stored procedures, also known as stored procs or procs, are queries and commands (select/update/delete/insert) permanently stored in the database, making them always available. Learn how to use pre-compiled stored procedures to speed up slower queries. Discover how to use If, existence checks, and returns to handle business logic, so queries return what is needed, when it is needed. Additional topics include using Variables and parameters to make commands more universal for ease with runs on different dates or accounts.
Fee: $279

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E2656 Fri., Apr. 22Virtual/WCBeth Arrowsmith
E3191 Fri., Sept. 9Virtual/WCBeth Arrowsmith

Intermediate SQL Stored Procedures

(Prerequisite: Introduction to SQL Stored Procedures or equivalent experience.) Discover how to extend and apply your knowledge of SQL by incorporating common programming constructs with various SQL commands and functions. Increase the functionality by using Case logic in your procedures which allows you to classify based on business logic. Learn to use transactions, so that if a multi-table or multi-step data change cannot occur, no changes are made. Use loops and cursors to handle SQL logic that needs to repeat in a specific order. Use Try-Catch for alternatives or to give appropriate warnings when SQL cannot complete a command. Learn to put Dynamic SQL into your stored procedures, allowing you to modify sort order, where clauses, or even the table used.
Fee: $279

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E2657 Fri., Apr. 29Virtual/WCBeth Arrowsmith
E3192 Fri., Sept. 16Virtual/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 info@cetc.umsl.edu.