UMSL logo

Computer Education & Training Center

SQL and Oracle

SQL and Oracle Classes

We currently offer SQL language courses on two platforms: SQL Server and Oracle.

SQL Language Courses

Our Introduction to SQL, Intermediate Applications of SQL, and Advanced Applications of SQL courses cover standard SQL commands, which can be used with a variety of client/server database systems. While these courses are taught using SQL Server, you can apply the commands and concepts to other database systems.

Our Oracle9i course series, including Fundamentals of SQL Using Oracle: Level 1, Fundamentals of SQL Using Oracle: Level 2, and Fundamentals of SQL Using Oracle: Level 3, teaches standard SQL commands in an Oracle environment. The syntax for these commands is specific to Oracle, but most of the commands covered are standard and can be used with other client/server database systems. In addition to standard SQL commands, these courses cover some topics specific to Oracle's SQL*Plus environment.

Overall, the SQL and Oracle series cover similar objectives, including learning standard commands for selecting, inserting, updating, and deleting records. Both series also cover more advanced concepts, such as grouping data, creating joins, writing subqueries, and enforcing referential integrity. You will see the most significant differences in the third course in the series (Advanced Applications of SQL and Fundamentals of SQL Using Oracle: Level 3).

SQL Programming Courses

While the commands taught in our SQL language courses are fairly standard, you will see more variance in database programming statements, depending on which database management system you are using. We currently offer programming courses using SQL Server (with SQL Server's Transact-SQL programming language) and Oracle (using PL/SQL). These courses cover similar concepts used in database application development, including basic programming concepts (such as variables, conditional statements, and loops), stored procedures, triggers, and cursors, but you will see differences in the programming statements used in SQL Server and Oracle.

SQL Server Reporting Services

In our SQL Server Reporting Services course series, you will learn to create professional reports using Microsoft SQL Server and other ODBC-compliant databases.

SQL Server Integration Services

In our SQL Server Integration Services course series, you will learn to use the database software tool that can be used for data migration tasks and can also be used to automate maintenance of SQL Server databases.

SQL Server Administration

In addition to the courses mentioned above, we offer a three-course series in database administration using Microsoft SQL Server. Introduction to SQL Server System Administration will teach you the basics of installing, configuring, and administering SQL Server. Intermediate SQL Server System Administration builds on the concepts learned in the introductory course, focusing on maintenance, optimization, and performance tuning. Finally, Advanced SQL Server System Administration covers techniques for storing and retrieving data from other database systems and configuring replication, among other topics.

For complete course listings, class descriptions, and prerequisites, browse our current Class Schedule.