Part 1 Oracle Architecture

• The instance vs. the database
• The System Global Area (SGA)
• The critical background processes

Part 2 Data Dictionary

• Dictionary table scope
• Dynamic performance views (V$ views)

Part 3 Installing Oracle 11g Enterprise Edition

• What the installer does
• Preparing for an installation
• Running Oracle Universal Installer (OUI)

Part 4 Database Creation

• Database creation options
• Database Configuration Assistant (DBCA) capabilities
• Database creation steps

Part 5 Database Startup and Shutdown

• What happens at startup
• The different startup modes
• What happens at shutdown
• The different shutdown options

Part 6 Managing the Initialization Parameter file

• How the initialization parameter file (‘init.ora’) is used
• The differences between PFILE and SPFILE
• Managing PFILEs and SPFILES

Part 7 Managing the System Global Area (SGA)

• Major components of the SGA
• Automatic memory management
• Some critical SGA related parameters

Part 8 Concurrency and Consistency

• What these two words mean
• How Oracle manages concurrency and consistency
• What part UNDO plays
• Alternative isolation levels

Part 9 Managing Database Storage

• The parts of the “database”
• Managing datafiles
• Managing online redo logs
• Managing control files

Part 10 Managing UNDO

• The uses of UNDO data
• The UNDO tablespace

Part 11 PL/SQL Overview

• Creating PL/SQL anonymous blocks
• Creating PL/SQL stored procedures
• Creating PL/SQL triggers

Part 12 Managing Database Users

• Creating database users
• Options at user creation
• Managing user space allocations

Part 13 Controlling User Access

• Working with object and system permissions
• Using ROLEs
• Controlling resource consumption with PROFILEs

Part 14 Managing Database Security

• User password management
• Ensuring password complexity

Part 15 Creating Tables

• Oracle datatypes
• Creating tables with CREATE TABLE

Part 16 Maintaining Tables

• What table characteristics can be changed
• Modifying table structure with ALTER TABLE
• Eliminating tables with DROP TABLE

Part 17 Creating Constraints

• The kinds of constraints
• How referential integrity is provided
• Inline vs. out-of-line syntax

Part 18 Maintaining Constraints

• How can constraints be changed
• Deferring constraint enforcement
• Enabling and disabling constraints

Part 19 Effective Indexing

• Creating B*-Tree indexes
• Utilizing “super” indexes
• Monitoring index usage

Part 20 Creating Other Schema Objects

• Creating sequences
• Creating views
• Creating synonyms

Part 21 Working with Statistics

• What kind of statistics are collected
• How Oracle uses statistics
• Operating on statistics with DBMS_STATS

Part 22 Self-managing Database

• Understanding Oracle’s “Intelligent Infrastructure”
• The metrics being saved in Automated Workload Repository (AWR)
• What the Automated Database Diagnostic Monitor (ADDM) does
• Other self-managing and self-tuning activities

Part 23 Loading and Moving Data

• Loading data with SQL Loader
• Creating data exports with Export Data Pump (expdp)
• Manipulating data exports with Import Data Pump (impdp)

Part 24 Backup and Recovery Concepts

• Backup and recovery fundamentals
• Types of backups
• Recovery and restore