SQL, Tools, Concepts and Features.
SQL and PL/SQL SQL*Plus commands (10 pages) SQL Functions, (Sum, to_date, to_char etc) Analytic SQL Features (8 pages) PL/SQL commands (16 pages) Built-In Packages (84 pages) Define Variables NLS Formats Naming Convention for Oracle Optimal Flexibile Architecture (OFA) Tools 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 Tables and Columns Datatypes (Summary of changes for Oracle 7, 8 & 9) Data Types and Unicode 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 Users and Schemas
Security, Roles and Privileges Tablespaces Concurrency - Multi User access Physical Storage of data
Storage: Blocks, Extents, Segments. Redo, Rollback, Undo Archive Log mode Memory Configuration Instance startup and shutdown init.ora Parameters 9i and 10g Oracle Architecture (Powerpoint) Parallel processing Background processes SQL Scripts Tablespace Free Space List all Sessions List Active Sessions Recommended Oracle books
