UMSL logo

Computer Education & Training Center

SQL

SQL (Using Microsoft SQL Server) Classes

Our SQL language courses (Introduction to SQL, Intermediate Applications of SQL, and Advanced Applications of SQL) are taught using Microsoft SQL Server. The courses cover generic syntax, so it does not matter which server (SQL Server, Oracle, MySQL, etc.) or version you are using. These courses do not cover special features of any particular SQL package. Students using the MySQL database could also take these classes.

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

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.

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

Introduction to SQL

(Prerequisite: Introduction to Access or equivalent experience with another database.) This course introduces SQL using Microsoft SQL Server to demonstrate generic SQL commands that can be used with a variety of client/server database systems. Learn how to do ad-hoc queries on a database to select the information you need. Understand how to write select statements and use wildcards, logical operators, and calculated columns. Learn to eliminate duplicates and work with date data. Learn how to aggregate data as well as group data, order data, and generate totals. Topics include SQL syntax, data definition language, and data manipulation language. [Course Outline]
Fee: $279

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E2030 Thurs., July 8Virtual/WCBill Barry
E2060 Tues., July 20Virtual/WCBill Barry
E2097 Tues., Aug. 3Virtual/WCBill Barry
E2098 Wed., Aug. 18Virtual/WCBill Barry
E2147 Thurs., Sept. 2Virtual/WCBill Barry
E2148 Wed., Sept. 8Virtual/WCBill Barry
E2213 Tues., Sept. 21Virtual/WCBill Barry
E2320 Thurs., Oct. 14Virtual/WCBill Barry
E2322 Tues., Nov. 2Virtual/WCBill Barry

Intermediate Applications of SQL

(Prerequisite: Introduction to SQL or equivalent experience.) Learn how to do more complicated queries joining two tables in a database. Understand the different types of joins, such as inner joins, outer joins, and Cartesian products. Learn how to specify multiple criteria, work with the various clauses, and use the aggregate functions with joins. Understand how to create, modify, and delete views. Topics include using the UNION operation to combine the results of two queries into a single result set. Additional topics include comparing the results of multiple queries using EXCEPT and INTERCEPT, and using ROLLUP and CUBE to summarize data. [Course Outline]
Fee: $279

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E2031 Thurs., July 15Virtual/WCBill Barry
E2061 Wed., July 21Virtual/WCBill Barry
E2099 Thurs., Aug. 19Virtual/WCBill Barry
E2149 Thurs., Sept. 9Virtual/WCBill Barry
E2214 Tues., Sept. 28Virtual/WCBill Barry
E2321 Thurs., Oct. 21Virtual/WCBill Barry
E2323 Wed., Nov. 3Virtual/WCBill Barry

Advanced Applications of SQL

(Prerequisite: Intermediate Applications of SQL or equivalent experience.) Learn how to properly design a relational database and structure tables within the database. Learn the purpose of and how to specify primary and foreign keys. Understand the advantages of referential integrity and how it can affect data maintenance and prevent errors. Learn to plan and create tables and view table information. Understand how to create tables with column constraints and the value of column constraints. Topics include using ALTER TABLE to modify table structure, and creating and understanding the different types of indexes. Additional topics include saving updates to the database using COMMIT and ROLLBACK, copying data between tables, and using PIVOT to transform query results. [Course Outline]
Fee: $279

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E2062 Thurs., July 22Virtual/WCBill Barry
E2100 Wed., Aug. 25Virtual/WCBill Barry
E2215 Tues., Oct. 5Virtual/WCBill Barry
E2324 Thurs., Nov. 4Virtual/WCBill Barry

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: $279

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E2063 Thurs., July 29Virtual/WCBill Barry
E2218 Wed., Sept. 22Virtual/WCBill Barry
E2330 Wed., Nov. 10Virtual/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: $279

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E2064 Thurs., Aug. 12Virtual/WCBill Barry
E2219 Thurs., Sept. 23Virtual/WCBill Barry
E2331 Thurs., Nov. 11Virtual/WCBill Barry

Advanced SQL Queries: Level 3 Data Analysis

(Prerequisite: Advanced SQL Queries: Level 2 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.  [Course Outline]
Fee: $279

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E1731 Wed., June 30Virtual/WCBeth Arrowsmith
E2065 Fri., Aug. 27Virtual/WCBeth Arrowsmith
E2390 Thurs., Nov. 18Virtual/WCBeth Arrowsmith

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.
Fee: $279

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E2010 Fri., July 30Virtual/WCBeth Arrowsmith
E2220 Fri., Oct. 8Virtual/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 SQL Server Administration.