DBA Part I - Architecture & Administration

5 Day Course
Code ODA

Newer versions of this course are available on either Oracle versions 10g or 11g.

Modules

Topics Covered (11 topics)

  • Oracle Architectural Components
  • Managing an Oracle Instance
  • Creating an Oracle Database
  • Managing an Oracle Database
  • Managing Disk Space, Tablespaces and Data Files
  • Managing Undo data and Temporary Segments
  • Managing redo logs and control files
  • Managing Tables and Indexes
  • Managing Users, Profiles, Privileges and Roles
  • Maintaining Database Security
  • Using National Language Support

Prerequisites

A working knowledge of SQL*Plus is required. This can be obtained by attendance on the "Oracle SQL*Plus" course. A good working knowledge of operating system commands is also required. Pre-Requisites Courses: SQL*Plus (OSP). Note: Before taking any exam, ensure you have the recommended experience.

Sections