Oracle Syntax

Installation, Tools, Concepts and Features.

Tables and Columns
  Data Types and Formats
  Datatypes (Summary of changes for Oracle 7, 8 & 9)
  Data Integrity - Constraints and Triggers
  Tables - Partitioned, Temporary, External and IOT's

Views, Clusters, Indexes
  Views and Materialized Views
  Clusters and Hash Clusters
  Indexes and Sequences

SQL and PL/SQL
  SQL Functions
  Analytic SQL Features
  Stored Procedures PL/SQL
  PL/SQL commands
  List of Built-In Packages
  Define Variables
  NLS Formats 
  Naming Convention for Oracle
  Optimal Flexibile Architecture (OFA)

Tools
  SQL*Plus commands 
  IMP, EXP and SQLLDR parameter files
  Oracle Networking - TNSNames, Listener.ora
  Catalog and Utility Scripts (Oracle 9.0.2)
  Versions - Features & release dates.
  Common Oracle errors

Users and Schemas
  Security, Roles and Privileges
  Tablespaces
  Concurrency - Multi User access

Physical Storage of data
  Storage: Blocks, Extents, Segments.
  Redo, Rollback, Undo

Memory Configuration
  init.ora Parameters 
  Oracle Architecture (Powerpoint) 
  Parallel processing 
  Background processes

Recommended Oracle books