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.

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. Topics include SQL syntax, data definition language, and data manipulation language. Learn how to create and update tables, as well as order data, group data, and generate totals. [Course Outline]
Fee: $239

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G7610 Tues., Feb. 28West CountyMark Ratliff
G7752 Wed., Mar. 22West CountyBill Barry
G7763 Mon., Apr. 3West CountyMark Ratliff
G7786 Wed., Apr. 26West CountyBill Barry
G7896 Tues., May 16West CountyMark Ratliff
G7943 Thurs., May 25West CountyBill Barry
G7959 Mon., June 19West CountyBill Barry

Intermediate Applications of SQL

(Prerequisite: Introduction to SQL or equivalent experience.) This course is designed for those who want to use more advanced SQL commands and work with multiple tables. This course uses Microsoft SQL Server to demonstrate generic SQL commands that can be used with a variety of client/server database systems. Learn how to do more complicated queries on a database to select the information you need. Understand how to specify multiple criteria, use the aggregate functions, sort data, and eliminate duplicate values. Learn about different types of joins, such as inner joins, outer joins, and Cartesian products. Additional topics include creating views, changing tables, and copying data between tables.  [Course Outline]
Fee: $239

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G7611 Wed., Mar. 1West CountyBill Barry
G7753 Thurs., Mar. 23West CountyBill Barry
G7764 Tues., Apr. 4West CountyMark Ratliff
G7787 Tues., May 2West CountyBill Barry
G7897 Wed., May 17West CountyMark Ratliff
G7944 Fri., June 2West CountyBill Barry
G7960 Mon., June 26West CountyBill Barry

Advanced Applications of SQL

(Prerequisite: Intermediate Applications of SQL or equivalent experience.) This course uses Microsoft SQL Server to demonstrate generic SQL commands that can be used with a variety of client/server database systems. 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. Additional topics include creating indexes, using the UNION operation to combine the results of two queries into a single result set, and using ROLLUP and CUBE to summarize data. [Course Outline]
Fee: $239

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G7612 Thurs., Mar. 2West CountyBill Barry
G7754 Wed., Mar. 29West CountyMark Ratliff
G7898 Thurs., May 18West CountyBill Barry
G7945 Wed., June 7West CountyBill 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 Structured Query Language to access information from a relational database. Topics covered include more complex joins, sub-queries, a review of table relationships and the three table query. Additional topics include data recursion (recursive queries), Rank(), Dense_Rank(), Row_Number(), NTile(), top percent queries, and more on date queries.
Fee: $239

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G7765 Wed., Apr. 5West CountyBill Barry
G7930 Mon., May 22West CountyMark Ratliff

Advanced SQL Queries, Level 2

(Prerequisite: Advance 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.
Fee: $239

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G7766 Thurs., Apr. 6West CountyBill Barry
G7931 Tues., May 23West CountyMark Ratliff

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.