Course
Schedule
AJAX
ASP_NET
Access DB
Acrobat
ActiveDir
C# .NET Prog.
CSS (HTML)
Cisco Week
Crystal Reports
DP Design
DigCameras
Dreamweaver
E-commerce
Excel
Exchange
ExpressionWeb
FileMaker
Fireworks
Flash
HTML
Illustrator
InDesign
Introductory
JSP
Java
JavaScript
Linux
Networks
ObjectOProg.
Office2007
Oracle
Outlook
PHP
Perl
PhotoElems
Photoshop
PowerPoint
Premiere
Prog. Concpts
Project
Publisher
QuarkXPress
QuickBooks
SQL
SQL Reporting
SQLServerAdm
Security
SharePoint
SharePtAdmin
SharePtDesign
Support
TCP/IP
UNIX
VB.NET
Visio
Vista Admin
Vista Intro.
Vista Trans.
Visual Basic 6
W2003 Policy
W2003 Server
W2008 Server
Win XP Intro.
Wireless Net.
Word
XML
|
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. Fee: $189 | |||
|
One-Day Class Meets 8:30am-4:00pm (6.5 hours) | |||
| Code | Date | Location | Instructor |
| G9414 | Thurs., Oct. 16 | West County | Sandy Lux |
| G9542 | Fri., Nov. 14 | West County | Sandy Lux |
| G9676 | Tues., Dec. 16 | UM-St. Louis | Andrew Schwartz |
| G9777 | Thurs., Jan. 15 | West County | Sandy Lux |
| |||
| Two-Evening Class Meets 6:30-9:30pm (6 hours) | |||
| Code | Date | Location | Instructor |
| T9152 | Tues., Oct. 7 & 14 | West County | Andrew 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. Fee: $189 | |||
|
One-Day Class Meets 8:30am-4:00pm (6.5 hours) | |||
| Code | Date | Location | Instructor |
| G9415 | Fri., Oct. 17 | West County | Sandy Lux |
| G9543 | Thurs., Nov. 20 | West County | Sandy Lux |
| G9677 | Wed., Dec. 17 | UM-St. Louis | Andrew Schwartz |
| G9778 | Fri., Jan. 23 | West County | Sandy Lux |
| |||
| Two-Evening Class Meets 6:30-9:30pm (6 hours) | |||
| Code | Date | Location | Instructor |
| T9153 | Tues., Oct. 21 & 28 | West County | Andrew Schwartz |
| |||
|
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. Fee: $189 | |||
|
One-Day Class Meets 8:30am-4:00pm (6.5 hours) | |||
| Code | Date | Location | Instructor |
| G9344 | Wed., Oct. 1 | West County | Sandy Lux |
| G9416 | Fri., Oct. 24 | West County | Andrew Schwartz |
| G9544 | Fri., Nov. 21 | West County | Sandy Lux |
| G9678 | Thurs., Dec. 18 | UM-St. Louis | Andrew Schwartz |
| G9779 | Wed., Jan. 28 | West County | Sandy Lux |
| |||
| Two-Evening Class Meets 6:30-9:30pm (6 hours) | |||
| Code | Date | Location | Instructor |
| T9210 | Tues., Nov. 4 & 11 | West County | Andrew 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. Fee: $389 | |||
|
Two-Day Class Meets 8:30am-4:00pm (13 hours) | |||
| Code | Dates | Location | Instructor |
| G9590 | Mon., Oct. 27 & Tues., Oct. 28 | West County | Andrew Schwartz |
| |||
| Four-Evening Class Meets 6:30-9:30pm (12 hours) | |||
| Code | Dates | Location | Instructor |
| T9211 | Tues., Nov. 18, 25, Dec. 2 & 9 | West County | Andrew 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. Fee: $389 | |||
|
Two-Day Class Meets 8:30am-4:00pm (13 hours) | |||
| Code | Dates | Location | Instructor |
| G9591 | Mon., Nov. 10 & Tues., Nov. 11 | West County | Andrew Schwartz |
|
| |||
