UMSL logo

Computer Education & Training Center

Oracle

Oracle and PL/SQL Classes

Our Oracle classes are now available online with an instructor present for the entire course. You will see the instructor's screen throughout the class and you can share your screen if you need individual help from the instructor. You will have time to practice, ask questions, and receive hands-on training. During class, you will be able to access Oracle on our machines. For more information, email info@cetc.umsl.edu.

Fundamentals of SQL Using Oracle: Level 1

(Prerequisite: Introduction to Windows and Introduction to Access or equivalent experience with another database.) This course introduces a variety of SQL commands useful in working with Oracle databases. Learn to create effective queries by using SQL SELECT statements to retrieve and sort records from your tables. Work with comparison and logical operators to display only records that meet certain criteria. Practice creating tables and inserting, updating, and deleting records. Additional topics include deleting, renaming, and truncating tables and controlling transactions by committing and reversing database changes. [Course Outline]
Fee: $239

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E0657 Fri., Sept. 11West CountyBeth Arrowsmith

Fundamentals of SQL Using Oracle: Level 2

(Prerequisite: Fundamentals of SQL Using Oracle: Level 1 or equivalent experience.) Further your SQL skills using Oracle by refining your queries to retrieve the information you need from single and multiple tables. Understand the different types of joins and how to use them to display data from multiple tables. Learn to use a variety of SQL functions to replace null values, perform calculations, and customize the format of date data. Practice using SQL group functions to count records, determine minimum and maximum values, calculate sums and averages, and display subtotals. Additional topics include creating and understanding the appropriate uses of views and subqueries. [Course Outline]
Fee: $239

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E0658 Fri., Sept. 18West CountyBeth Arrowsmith

Fundamentals of SQL Using Oracle: Level 3

(Prerequisite: Fundamentals of SQL Using Oracle: Level 2 or equivalent experience.) This course focuses on advanced applications of SQL in an Oracle environment, including managing tables and users. Practice creating sophisticated tables that include constraints to validate your data. Understand the rules of referential integrity and how to create primary and foreign keys that enforce these rules. Learn to modify the structure of existing tables by adding, deleting, and renaming columns. Control database access by creating users and roles and granting object and system privileges. Additional topics include writing and executing SQL scripts and creating and maintaining indexes, sequences, and synonyms. [Course Outline]
Fee: $239

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E0659 Fri., Sept. 25West CountyBeth Arrowsmith