Back to Search Results

Training Course Summary:

Delegates:

This course is designed for experienced Oracle8i Database Administrators who need an understanding of the Oracle9i basic new features and how to implement them.

Objectives:

This course will enable delegates to understand the new features of Oracle9i and how these may affect their current Oracle installations. They will be able to install Oracle9i; migrate an Oracle8i database to Oracle9i; create an Oracle9i database and implement the new features available on a database. This course covers the main features of the Oracle exam #1Z0-030 Oracle9i Database: New Features for Administrators.


Topics Covered:

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
New Tablespace Features
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

Requirements:

A good working knowledge of SQL, PL/SQL and Oracle8i Administration, Backup & Recovery functions.


Note:

Before taking any exam, ensure you have the recommended experience.

Pre-Requisites Courses:

Introduction to SQL

PL/SQL


Follow-On Courses:

DBA Performance & Tuning

DBA Part II - Backup & Recovery and Networking