This course combines a discussion of relational concepts with a presentation of the features and capabilities of the Oracle relational database management system. A brief introduction to SQL is provided to illustrate major points. The course provides the student with a foundation in the fundamental concepts of the relational database model as implemented in the Oracle RDBMS product. Discussion will also include advanced features of Oracle to support a very large database (VLDB) or to exploit object-oriented capabilities of the DBMS.

Managers, Programmers, Analysts, and Users involved with or considering using an Oracle system. prerequisites: Basic computer literacy.

• Overview of Oracle
• Introduction to SQL
• Database Design Examples
• Views
• Security
• Data Organization
• Oracle’s Data Dictionary
• Oracle Software Tools
• Client-Server and Distributed Systems
• Data Warehouse Support
• Object-Oriented Features

Basic computer literacy.