UMSL logo

Computer Education & Training Center

SQL Queries

Advanced SQL Query Classes

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

Virtual Classes: Our Advanced SQL Query 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 Queries and SQL Data Analysis.

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.

Advanced SQL Queries: Level 1

(Prerequisite: Intermediate Applications of SQL or equivalent experience.) Continue your path to mastery of SQL Commands with more complex queries and advanced features of SQL to access information from a relational database. Work with complex joins from multiple tables, three or more table queries, and learn to reference the same data set multiple times. Understand how to do sub-queries to handle multi-table tasks and when to use sub-queries versus using joins. Review Date Queries and understand how to use the Datename and Datepart functions. Topics include working with aggregate data and using the Over(), Group By, and Having clauses. Additional topics include Top Record/Top Percent queries and using the Rank() and Dense_Rank() functions.  [Course Outline]
Fee: $239

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E1238 Thurs., Oct. 22Virtual/WCBill Barry
E1362 Thurs., Dec. 10Virtual/WCBill Barry
E1508 Tues., Feb. 2Virtual/WCBill Barry

Advanced SQL Queries: Level 2

(Prerequisite: Advanced SQL Queries: Level 1 or equivalent experience.) Take your SQL skills to the next level and learn to write more advanced select queries. Building on the skills learned in the prior SQL classes, enhance your queries with date and string functions. Learn special purpose, irregular pattern, and top value queries. Use correlated subqueries to create running totals and subtotals. Explore metadata queries and schemabinding. Pivoting query results will also be covered.  [Course Outline]
Fee: $239

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E1239 Thurs., Oct. 29Virtual/WCBill Barry
E1363 Thurs., Dec. 17Virtual/WCBill Barry
E1509 Wed., Feb. 3Virtual/WCBill Barry

Advanced SQL Queries: Level 3-Data Analysis

(Prerequisite: Advanced SQL Queries: Level 1 or equivalent experience.) Learn to design effective SQL queries to extract business information from your databases in order to do effective data analysis. Discover how to pull data for survival analysis of customers to better understand your active customer base in order to predict future revenue. Understand the factors that affect customer tenure and how to use SQL to calculate the probabilities of customers staying or leaving. Learn to investigate purchasing patterns and methods for identifying customers. Use SQL to help analyze the frequency of purchases and understand where sales are increasing or decreasing. Additional topics include market basket analysis to better understand customers and what they might purchase. Fee: $239

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E1240 Wed., Nov. 11Virtual/WCBeth Arrowsmith
E1510 Wed., Feb. 10Virtual/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, SQL Server Administration, and SQL Server Relational Database Design.