Database Courses:
Oracle Database Administration Training Course

This course is no longer offered as a public scheduled course.

As an alternative, we offer Oracle9i DBA Fundamentals I and Oracle9i DBA Fundamentals II courses. In exceptional circumstances, e.g. the placement of several delegates a tailored version of this course may be possible. If you feel this course covered the subject matter you require and cannot find an alternative please contact us for advice.

Original Course Outline Follows:

This database administration course is intended for those who are responsible for managing, maintaining and supporting Oracle version 8.

At the end of the course delegates will be able to create and manage database users, implement a security system to control their activities, define a backup strategy and perform recovery in the event of a system failure and tune the database to optimize performance.

Knowledge of the target operating system is helpful. Delegates should also be competent in the skills covered by the PTR Oracle SQL*Plus Fundamentals course.

Topics covered on the 4 day Oracle Database Administration course

Introduction

Oracle System Architecture

Overview of components, processes and functions of Oracle 8

Datafiles, redo logs, control files, parameter file

System Global Area and shared memory structures

Description of Administrator facilities and duties

Creating a database

Setting initialisation parameters

Important SQL scripts

Starting up, mounting and opening the database

Shutdown modes

Using the data dictionary

Managing and optimising disk space

The System tablespace

Creating additional tablespaces

Important storage parameters

Monitoring extents and free space

Extending tablespaces

Configuring rollback segments

Configuring redo logs

Tables and indexes

Performance issues

Storage parameters and PCTFREE and PCTUSED

Oracle 8’s new partitioning facilities

Partitioning tables

Partitioning indexes

Managing partitions

Oracle 8 and objects

Tuning memory structures

Monitoring shared memory

Sizing the buffer cache

shared pool and redo log buffer

Tuning sort operations

User administration

Creating users

Using Oracle 8’s new password controls

Default and temporary tablespaces

Space quotas

Profiles

System and object privileges

Creating and managing roles

System and object auditing

Backup & recovery

Archiving redo logs

Hot and cold database backups

Instance recovery

Database, tablespace and datafile recovery (practical exercise)

The Oracle 8 Recovery Manager

Oracle Utilities

Export and import

SQL Loader

   (excl.VAT)

PTR Associates Limited

21A Peach Street, Wokingham, Berkshire, RG40 1XJ, United Kingdom
Tel: 0118 979 4000 Fax: 0118 979 4035
Email: training@ptr.co.uk