db-Training: Oracle Database Administration Certification Program

Oracle Database Administration Certification Program

Prerequisites

Basic SQL*Plus skills and understanding of Oracle schema objects. Background in systems and/or network engineering is helpful.

Audience

Application designers or software engineers who are familiar with database concepts and have acquired responsibility for managing and controlling Oracle databases.

Objectives

Upon completion, the participant will be able to successfully:

Understand the logical and physical architecture of an Oracle database
Manage storage of database objects and files
Install an Oracle database
Properly design and implement a physical design of the database
Perform backup and recovery of an Oracle database
Manage users and security
Tune an Oracle database

Course Outline

This course consists of the following twenty modules:

Module 1 (Oracle DBA)
- Roles and responsibilities
  - Developer DBA vs. Production DBA
- Resources for learning
  - Internet resources
  - Books, magazines, videos, CBT, etc.
  - Oracle Certified Professional Program
- Basic schema objects
  - Table, datatypes
  - Integrity rules
Module 2 (Oracle DBA)
- Basic schema objects
  - View, sequence, synonym, index, stored program units
- Use of structured walkthroughs with developers
- The Oracle Data Dictionary
  - Basic organization and layout
  - Static Data Dictionary
  - Dynamic Data Dictionary
  - Key queries with the data dictionary
- Understanding the DBMS packages
Module 3 (Oracle DBA)
- Logical Object Storage
  - Block definition and management
  - Extent management
- Exercise: Table sizing
Module 4 (Oracle DBA)
- Logical Object Storage
  - Segments (temporary, sort, rollback)
  - Tablespace management
Module 5 (Oracle DBA)
- Physical Database Architecture
  - Database vs. instance
  - Datafile management
    - Adding datafiles
    - Datafile auto-extension
    - Resizing datafiles
Module 6 (Oracle DBA)
- Controlfile management
- Redo log file management
  - Bypassing writes to the redo logs
  - Recoverable vs. unrecoverable
Module 7 (Oracle DBA)
- Physical Database Architecture
  - Memory management
  - Process architecture
Module 8 (Oracle DBA)
- Startup and shutdown options
- Basic Oracle Database Installation
  - Decision points to create a new database
  - Establishing Service-Level Agreements (SLA)
  - Pre-installation issues
    - Init.ora
  - Optimal Flexible Architecture (OFA) methodology
- Exercise: Planning a database layout
  - Post-installation issues
- Exercise: Install a small database
Module 9 (Oracle Backup and Recovery)
- Basic Backup Concepts
  - Noarchivelog backups
  - Archivelog backups
    - Cold backups
    - Hot backups
  - Archivelog management
- Physical vs. Logical Backups
  - Import/Export
    - Issues with large database exports/imports
  - DB verify utility
- Exercise: Backup a database
- Basic Recovery Concepts
  - Restoration in cases of noarchivelog mode backups
- Exercise: Restore a noarchivelog mode database
Module 10 (Oracle Backup and Recovery)
- Basic Recovery Concepts
  - Recovery for archivelog mode databases
    - Complete recovery
    - Incomplete recovery
Module 11 (Oracle DBA)
- Security
  - User management
    - Privileges
  - Profiles
  - Password management
  - Roles
  - Auditing
Module 12 (Oracle Performance Tuning)
- Concurrence Management in Oracle
  - Locks
- Tuning an Oracle Database
  - Role in database and application design
  - Oracle SQLOptimization
    - Rule-based Optimizer
    - Cost-based Optimizer
    - Use of Hints
  - Tuning Tools
  - Steps in tuning
Module 13 (Oracle Performance Tuning)
- Tuning an Oracle Database
  - Tuning Memory
  - Tuning I/O
  - Tuning CPU
  - Other Tuning issues
Module 14 (Oracle DBA)
- Advanced Schema Objects
  - Indexes
    - Bitmapped, IOT, reverse key, cluster, hash cluster
  - LOB management
Module 15 (Oracle DBA)
- Advanced Schema Objects
  - Partition option
  - Object option
- Other Database Options
  - Context
  - Spatial
  - Oracle Application Server
  - Trusted Oracle
  - Oracle and the ifs option
- Exercise: Install a medium-sized database
Module 16 (Oracle DBA)
- Using Oracle Enterprise Manager (OEM) to manage your database
  - Installing and configuring OEM
  - OEM tools
  - Additional optional OEM tools
Module 17 (Oracle Backup and Recovery)
- Backup and Recovery using recovery manager
  - RMAN Concepts and capabilities
  - Installation and Connection of RMAN
  - RMAN commands and the RMAN catalog
  - Backup using RMAN
  - Recovery using RMAN
Module 18 (Oracle Network Administration)
- Oracle and the Network
  - Net
- Oracle and Replication
  - Snapshots
Module 19 (Oracle DBA)
- Loading data into Oracle
- Distributed Oracle
Module 20 (Oracle DBA)
- 3rd Party tools to help you do your job
- Final Review

Materials and Benefits

All students will receive the following materials:

Textbook
- Published by db-Training specifically for db-Training students - not available anywhere else!
- Authored by veteran Oracle professionals
- Written specifically for db-Training's seasoned and proven educational approach
- Coil-bound to lay flat while working
- Include hands-on exercises
Proprietary Database Objects to accompany the textbook exercises, on floppy disk
In-class access to your own dedicated computer workstation, for use on in-class exercises and application development projects.
Supplemental instructional tools and surprises
A lifetime invitation to the annual graduate student picnic, sponsored by Information Systems Consortium (ISC), the parent company of db-Training, and the Washington/Baltimore metropolitan area's leading Oracle consulting firm, with affiliations with 20 other Oracle consulting firms in the area.

Course Duration

The schedule is 12 weeks long. Scheduling options include:

Schedule 1: Monday / Wednesday, 6-10 PM
Schedule 2: Tuesday / Thursday, 6-10 PM
Schedule 3: Saturdays only, 9-5 PM

Prices and Payment

Please see our prices and payment page.

Class Schedule

For information about when our next class is scheduled, please see our Schedule of Classes.