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.

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
E8295 Mon., Oct. 23 & Tues., Oct. 24West CountyLloyd Abernathy

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
E8296 Mon., Nov. 6 & Tues., Nov. 7West CountyLloyd Abernathy

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.