By using our website you agree to our use of cookies.

Oracle Database 10g DBA Fundamentals

10 Day Course
Hands On
Code O10GDBAF

This course has been retired. Please view currently available Oracle DBA 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.

  • PL/SQL

    A 2-day Training Course on PL/SQL; Designed for those who need to write program scripts using Oracle's Procedure Language; corresponds to exam 1Z0-001

    2 Day Course Hands On Training Course Code OPI
    Classroom Virtual Classroom Private Group - Virtual Self-Paced Online
Oracle DBA Training Courses

Course PDF

Print

Sections