SQL (Using Microsoft SQL Server)

Introduction to SQL
(Prerequisite: Introduction to Windows and 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. [Table of Contents]
Fee: $189

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G0532 Mon., Nov. 9West CountySandy Lux
G0645 Wed., Dec. 9UM-St. LouisAndrew Schwartz
G0778 Thurs., Jan. 14West CountySandy Lux

Two-Evening Class Meets 6:30-9:30pm (6 hours)
Code Date Location Instructor
T0356 Tues., Feb. 16 & 23West CountyAndrew Schwartz
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. Topics include creating indexes, changing tables, performing subqueries, and creating views. Learn about different types of joins, such as inner joins, outer joins, and Cartesian products. [Table of Contents]
Fee: $189

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G0533 Tues., Nov. 10West CountySandy Lux
G0646 Thurs., Dec. 10UM-St. LouisAndrew Schwartz
G0779 Fri., Jan. 22West CountySandy Lux
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 purpose and advantages of referential integrity and how it can affect data maintenance and prevent errors. Additional topics include using the UNION operation to combine the results of two queries into a single result set and using ROLLUP and CUBE to summarize data. [Table of Contents]
Fee: $189

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G0534 Wed., Nov. 11West CountySandy Lux
G0617 Fri., Dec. 11UM-St. LouisAndrew Schwartz
G0780 Thurs., Jan. 28West CountySandy Lux

Two-Evening Class Meets 6:30-9:30pm (6 hours)
Code Date Location Instructor
T0203 Tues., Nov. 10 & 17West CountyAndrew Schwartz
SQL Programming, Level 1
(Prerequisites: Intermediate Applications of SQL or equivalent experience.) This course introduces SQL Server programming using Transact-SQL, Microsoft's proprietary extension to the SQL language. Learn how Transact-SQL can help you increase the flexibility and usefulness of your database applications. Write and execute blocks of code that interact with your SQL Server data by combining SQL statements with Transact-SQL programming constructs. Learn how to declare and reference variables and use cursors to process rows returned by a query. Additional topics include writing conditional and looping structures to control the flow of your statements and using the Try...Catch construct to handle exceptions.  [Table of Contents]
Fee: $399

Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
G0881 Mon., Feb. 1 & Tues., Feb. 2West CountyAndrew Schwartz
SQL Programming, Level 2
(Prerequisites: SQL Programming: Level 1 or equivalent experience.) Extend and apply your knowledge of Transact-SQL by incorporating common programming constructs with various SQL commands and functions. Learn to write practical, reusable functions and call these user-defined functions from SQL expressions. Understand how to use triggers and practice writing triggers that respond to data manipulation events, such as inserting, updating, and deleting records. Additional topics include using output parameters and working with dynamic SQL.  [Table of Contents]
Fee: $399

Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
G0882 Mon., Feb. 15 & Tues., Feb. 16West CountyAndrew Schwartz