---

•  Relational Databases
  •  The Relational Database Model
    •  Introduction
    •  Database Normalisation
    •  Indexing (Primary and Foreign Keys)
    •  Data and Referential Integrity
    •  Optimisation
    •  Structured Query Language (SQL)
    •  Stored Procedures
    •  Triggers - Rules and Events
  •  Relational Database Products
  •  Some Example Relational Database Implementations
    •  Accounting
    •  Shipping Tracking
    •  Fixed Assets
    •  A Hospital
    •  Employees and Payroll
    •  Database Driven Security in Oracle
  •  Oracle8i (not 9i or 10g)
    •  Oracle8i Installation and Database Creation on Solaris
      •  Installation
      •  Unix Things
      •  Creating a Database
    •  Database Design and Modeling the Oracle Way
    •  SQL and PL/SQL
      •  The Data Manipulation Language (DML)
        •  Introduction
        •  Operators
        •  Simple Data Types
        •  SQL Functions
        •  DML Commands
        •  Joins
        •  Subqueries
        •  Parallel DML
      •  Pseudo Columns
      •  PL/SQL
      •  Built-In Packages
      •  The Data Definition Language (DDL)
        •  Introduction
        •  The Database
        •  Tablespaces
        •  Tables
        •  Partitioning
        •  Indexes
        •  Clusters
        •  Storage Clause
        •  Sequences
        •  Rollback Segments
        •  Views
        •  Synonyms
        •  Other Commands
    •  Database Administration
      •  The Architecture of Oracle
        •  Overall Architecture
        •  Internal Structures
          •  The Oracle Instance
            •  What is the Oracle Instance ?
            •  Memory Buffers
            •  Processes
          •  The Logical Database
          •  Optimal Flexible Architecture (OFA)
        •  External Structures
          •  The Physical Database
          •  Control File Management
          •  Managing Redo Log Files
          •  Managing Rollback Segments
        •  Instance Startup and Shutdown
        •  Instance Startup Parameters
      •  The Oracle Data Dictionary
        •  Introduction
        •  Oracle C-Structs and V$ Views
        •  Oracle $ (Dollar) Tables
        •  Data Dictionary User Views : ALL_ / DBA_ / USER_
        •  Other Data Dictionary User Views
        •  Oracle Add-On Tables and Utility Scripts
      •  Security
        •  Users and Grants
        •  Password Management
        •  Resource Management with Profiles
      •  Database Auditing
      •  Advanced Queuing and Job Queues
      •  External Procedures
    •  Objects in Oracle
      •  Objects and Object Datatypes
      •  Large Object Datatypes
    •  Utilities (Backup and Recovery)
      •  Database Utilities
      •  Backup and Recovery
      •  Standby Databases
      •  Copying Databases in the Operating System
    •  Tuning
      •  The Basics
      •  Tuning SQL
      •  Indexes
      •  Overriding the Optimiser
        •  Statistics
        •  Hints
        •  Row Source Join Methods
      •  Problem Queries
        •  How to Find Problem Queries
        •  EXPLAIN PLAN
        •  SQL Trace and TKPROF
      •  Physical Tuning
        •  Tuning CPU Usage
        •  Tuning Memory Usage
        •  Tuning I/O Usage
        •  Tuning Network Usage
        •  Control of Data Block Space Usage
        •  Contention
        •  Resource Management
      •  Performance Prediction
    •  Oracle Networking
      •  What is Net8 ?
      •  OSI-Protocols and Net8 Architecture
      •  The Listener
      •  Naming Methods
        •  Oracle Connection Strings and Naming Methods
        •  Localised Naming
          •  Local Naming
        •  Centralised Naming
          •  Directory Naming (LDAP)
          •  Oracle Names Servers
          •  Host Naming
          •  External Naming
      •  Multithreaded Server
      •  Connection Manager
      •  Profile Parameters
      •  Oracle Advanced Security