Oracle 9i Concepts and Facilities

PT2734
Summary
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.
Prerequisites
Students must have basic computer literacy.
Duration
2 Days/Lecture & Lab
Audience
This course is designed for Managers, Programmers, Analysts, and Users involved with or considering using an Oracle system. This course is also appropriate as an introduction to Oracle for individuals familiar with another relational database product.
Topics
  • Overview of Oracle
  • Introduction to SQL
  • Database Design Examples
  • Views
  • Security
  • Data Organization
  • Other Schema Objects
  • Oracle's Data Dictionary
  • Oracle Software Tools
  • Client-Server and Distributed Systems
  • Data Warehouse Support
  • Object-Oriented Features

Related Scheduled Courses