Administration

Duration: 5 days

Contents:

•  Oracle system architecture
•  Oracle Instance: startup, shutdown
•  Control files, Redolog files, Data files
•  Tablespaces
•  Rollback segments: size and problems, V9: Undo Tablespace
•  Tables and Indexes: Storage parameters
•  Reorganisation: Export, Import
•  Network settings
•  National language support
•  Users, roles and privileges

Backup / Recovery

Duration: 4 days

Contents:

•  Backup: offline, online
•  Archiving
•  Instance recovery
•  Media recovery
•  Oracle RMAN
•  Standby database
•  Workshop

Enterprise Manager

Duration: 2 days

Contents:

•  System architecture
•  Setup the agent
•  Install and configure OMS, OEM
•  Event management
•  Job scheduling
•  Change Management Pack, Diagnostic Pack, Tuning Pack

PL/SQL

Duration: 4 days

Contents:

•  Data types
•  Variables and constants
•  Assignments, operators
•  Loops: while - for
•  Control flow
•  Cursors
•  Exceptions
•  Prozedures and functions
•  Overloading
•  User defined functions within SQL
•  Packages
•  Triggers
•  Large Objects (LOB)

SQL

Duration: 4 days

Contents:

•  Overview of system architecture
•  Query
•  SQL functions
•  Data definition and manipulation
•  Transactions
•  Create database objects (table, view, index, sequence, synonym)
•  Privileges