Oracle Database 10g DBA Fundamentals

10 Day Course
Hands On
Code O10GDBAF

This course has been retired. Please view currently available Oracle 12c Training Courses.

Modules

Course Content (31 topics)

  • Installing and Configuring Oracle
  • Creating and Managing an Oracle database
  • Administering an Oracle Database
  • Configuring the Oracle Network Environment and Shared Servers
  • Creating and Managing Database Storage Structures
  • Managing Redo Log Files and Control Files
  • Managing Schema Objects
  • Managing Users, Profiles, Privileges and Roles
  • Managing Undo Data and Temporary Segments
  • Monitoring and Resolving Lock Conflicts
  • Maintaining Database Security
  • Monitoring the Performance of the Database
  • Loading and Unloading Data
  • Plan a Backup Strategy and a Disaster Recovery Strategy
  • Alter a Database to Archivelog and NoArchivelog Modes
  • Online and Offline Backups
  • Complete and Incomplete Database Recovery
  • Recover a Database from Non-Critical Losses
  • Perform Logical Backups with Export and Import Utilities
  • Use RMAN to Perform Backups And Restore
  • Use Flashback Technology to Recover a Database
  • Use Flashback to Recover From User Errors
  • Database Corruption
  • Diagnostic Sources
  • Use Automatic Database Management
  • Monitor and Manage Storage
  • Use Automatic Storage Management
  • Monitor and Manage Memory
  • Control Database Resources Using Resource Manager
  • Automate Management Tasks with the Scheduler
  • Secure the Oracle Listener

Prerequisites

A working knowledge of SQL*Plus is required. This can be gained by attendance on the pre-requisite course. Knowledge of PL/SQL would be beneficial.

Additional Learning

The courses below may help you meet the knowledge level required to take this course. If you are unsure please ask a training advisor .

Sections