Oracle Database 10g DBA Part I — A 5 day course

contact usEnquire about this course
Retired Course; no longer available


This course is designed to give database administrators the knowledge and skills needed to maintain successful and efficient day-to-day operations of an Oracle database.

This course is designed to give the Oracle database administrator practical experience in setting up, administering and troubleshooting an Oracle10g database. Database administrators will gain an understanding of the architecture and processes of the Oracle database server. They will be able to ensure the integrity and availability of a company's data within the Oracle environment. They will be able to monitor the performance of the database and perform basic backup and recovery of the database.

This course covers the main examination topics of the Oracle exam #1Z1-042 Oracle Database 10g: Administration I. Exams are not included as part of the course.


On completion of this course, delegates will be able to:

Suitable For

Anyone who needs to administer, monitor and support an Oracle 10g database.


Delegates should have an understanding of relational database concepts and basic operating system knowledge

A working knowledge of SQL*Plus is required. This can be gained by attendance on the Oracle SQL course

In addition knowledge of PL/SQL would be beneficial.


This course has been retired and is no longer available.


Introduction to Oracle Database 10g

Oracle Database 10g Architecture

Installation & Configuration of an Oracle Database

Administer a Database

Configure the Oracle Network Environment

Manage an Oracle Instance

Tablespace and Datafile Management

Manage Redo Logs

Manage Control Files

Manage Schema Objects

Manage Users

Mange Profiles and Resources

Managing Privileges

Database Auditing

Undo Management

Manage Data

Oracle Shared Server

Monitoring and Resolving Lock Conflicts

Proactive Database Maintenance

Performance Monitoring

Backup and Recovery Considerations

Database Backups

Database Recovery