Oracle 10g Concepts and Facilities

Length: 2 Days
Audience: Managers, Programmers, Analysts, and Users involved with or considering using an Oracle system.
Prerequisites: Basic computer literacy
Overview: 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.
This course is also appropriate as an introduction to Oracle for individuals familiar with another relational database product.
Topics discussed include:
  • Overview of Oracle
    • Relational Data Structure
    • Relational Language
    • Database Integrity
  • Introduction to SQL
  • Database Design Examples
    • CREATE TABLE Statement
    • ALTER TABLE Statement
    • Datatypes
    • Temporary Tables
    • Partitioned Tables
  • Views
    • Using Views
    • Processing a View
    • Restrictions on Views
    • CREATE VIEW Statement
  • Security
    • Privileges and Roles
    • Profiles
  • Data Organization
    • Storage Hierarchy
    • Redo Log Files
    • Dynamic Performance Tables
    • Oracle Instance
    • Transactions
    • Deferred Constraint Checking
  • Other Schema Objects
    • Synonyms
    • Sequences
    • Clusters
  • Oracle's Data Dictionary
  • Oracle Software Tools
    • SQL*Loader
    • Export & Import
    • Embedded SQL
    • PL/SQL
  • Client-Server and Distributed Systems
    • Oracle Net
    • Stored Procedures
    • Database Triggers
  • Data Warehouse Support
    • Data Warehouse Concepts
    • Materialized Views
    • Function-Based Indexes
    • Bitmapped Indexes
  • Object-Oriented Features
    • Object-Oriented Concepts
    • Object-Relational Approach
    • Object Views
Back to Oracle 10g Courses