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 Versions - Features & release dates. Common Oracle errors Tables and Columns Datatypes (Summary for Oracle versions up to 11g) 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 Configuration Instance startup and shutdown Oracle Parameters (+ Full List) Oracle Architecture (Powerpoint) Parallel processing Background processes SQL Scripts Tablespace Free Space List all Sessions List Active Sessions more scripts can be found on the relevant dictionary pages Recommended Oracle books
