PTR - People, Training ResultsPeople, Training, Results
Independent Technical IT Computer Training Courses

Scheduled Classroom based Training Courses

Oracle Database Administration Course

Course Description

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.

Course pre-requisites:

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

    • Course Classification: 

    Course Fee = £1300   (excl.VAT)

    Scheduled course dates

    March 2010April 2010May 2010June 2010July 2010

    Print / Download PDF Version of full course schedule

    If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite Oracle Training and bespoke Oracle courses