Oracle Syntax

Concepts and features of the Oracle database.

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 FunctionsAnalytic 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)

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

Tools
  SQL*Plus commands 
  IMP, EXP and SQLLDR parameter files
  Catalog and Utility Scripts supplied with Oracle 9.0.2
  Versions - Features & release dates.

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

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

Recommended Oracle books