UMSL logo

Computer Education & Training Center

SQL Optimize

SQL Optimization Class

Master the art of writing advanced SQL queries by attending a hands-on class at UMSL's Computer Education & Training Center.

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

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 Query Optimization

(Prerequisite: Advanced SQL or equivalent experience.) Understand how the order of query processing may vary in the database from the syntax order in the query because of the SQL Order of Operations. Learn to make your SQL Queries easy to read and modify using formatting, comments, and aliases. Discover how to filter data and the best methods for using the Where and Having clauses. Understand how to analyze and tune your query performance. Learn to manage duplicates and when to use Distinct. Understand how to use union to get the same format of results from two different queries. Topics include using sub-query versus inner join and working with an execution plan. Additional topics include the importance of indexes, the impact of sorting, overriding the Query Optimizer, and using SQL Server statistics to improve query optimization.  [Course Outline]
Fee: $279

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E2220 Fri., Oct. 8Virtual/WCBeth Arrowsmith
E2495 Wed., Feb. 2Virtual/WCBeth Arrowsmith

If you would like to register for a course, call (314) 984-9000 or register online.

Classes are also available in SQL Programming using Transact-SQL to extend the functionality of your database.

You may also be interested in other SQL Server classes including SQL Server Reporting Services, SQL Server Integration Services, and Advanced SQL Queries.

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