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
E0631 Tues., Mar. 17West CountyBill Barry
E0701 Wed., Apr. 1West CountyBill Barry
E0733 Tues., Apr. 21West CountyBill Barry
E0764 Thurs., May 7West CountyMark Ratliff
E0801 Tues., May 19West CountyBill Barry
E0833 Wed., June 3West CountyBill Barry
E0855 Wed., June 24West 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 data in 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, work with the various clauses, 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, copying data between tables, and working with date data.  [Course Outline]
Fee: $239

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E0632 Wed., Mar. 18West CountyBill Barry
E0792 Thurs., Apr. 2West CountyBill Barry
E0734 Tues., Apr. 28West CountyBill Barry
E0765 Fri., May 15West CountyMark Ratliff
E0802 Wed., May 20West CountyBill Barry
E0834 Wed., June 10West CountyBill Barry
E0856 Thurs., June 25West 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
E0633 Thurs., Mar. 19West CountyBill Barry
E0735 Thurs., May 7West CountyBill Barry
E0835 Tues., June 16West 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 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
E0608 Wed., Mar. 4West CountyBill Barry
E0634 Tues., Mar. 24West CountyBill Barry
E0706 Thurs., May 14West CountyBill Barry
E0836 Wed., June 17West CountyBill 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
E0609 Thurs., Mar. 5West CountyBill Barry
E0635 Tues., Mar. 31West CountyBill Barry
E0737 Thurs., May 21West CountyBill Barry
E0837 Thurs., June 18West CountyBill Barry

Data Analysis Using SQL

(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
E0750 Tues., Apr. 14West CountyBeth 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.