Oracle 9i for Experienced Oracle 8i Database Administrators

4 Day Course
Code OR89

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

Modules

Topics Covered (20 topics)

  • Overview of the New Features in Oracle9i
  • Administration Tools
  • Upgrade and Migration to Oracle9i
  • Installation and Configuration of an Oracle database
  • Oracle Managed Files
  • Managing Initialization Parameters
  • Managing Redo Logs and Control Files
  • Managing Disk I/O
  • Managing Undo Data
  • Memory Management New Features
  • SQL and PL/SQL New Features
  • Optimizer and Index New Features
  • Database Resource Manager Enhancements
  • Advanced Replication Enhancements
  • LogMiner New Features
  • Overview of Real Application Clusters
  • Backup, Restore and Recovery New Features
  • Data Guard - Standby Database Enhancements
  • National Language Enhancements
  • Desupported and Deprecated Features

Prerequisites

A good working knowledge of SQL, PL/SQL and of Oracle8i administration and backup and recovery functions. Pre-Requisites Courses: Introduction to SQL (ISQL); PL/SQL (OPI).

Additional Learning

The courses below may help you meet the knowledge level required to take this course.

  • ISQL: Introduction to SQL

    A 1-day Training Course on ISQL: Introduction to SQL; provides delegates with an understanding of structure of a relational database and functions of a DBMS

    1 Day Course Hands On Training Course Code ISQL
    Classroom Virtual Classroom Private Group - Virtual Self-Paced Online
  • 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

Course PDF

Print

Sections