Database Courses:
Oracle Database Administration Training Course


Classroom Courses ~ Closed Courses ~ Onsite Courses ~ Training Passport ~ MCSE Courses ~ CBT Courses
Home Page ~ Contact ~ Training Centre ~ Course Schedule ~ Late Availability ~ Consultancy
   
    PTR Associates Ltd - Classroom Based Courses, Wokingham, Berkshire, uk
21a Peach Street, Wokingham, Berkshire, UK
Tel: 0118 979 4000       Fax: 0118 979 4035
Email:
training@ptr.co.uk      Web: www.ptr.co.uk

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.
scheduled dates / price

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
  • This is an instructor led training course taught in a classroom based environment.

    Course Classification: 

    Course Fee = £1300
       (excl.VAT)


    Scheduled course dates
    May 2008 June 2008 July 2008 August 2008 September 2008



    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


    If you want to attend the course but can't make the dates published then click here for details of our one-to-one training packages.







    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
    Oracle Course Index & Training Schedule
    More Oracle Courses

    Oracle9i DBA Fundamentals I Course

    Oracle9i DBA Fundamentals II Course

    Oracle9i: Performance Tuning Course

    Introduction To Oracle 9i/10g PL/SQL Programming Course

    Introduction to Oracle 9i/10g Programming (SQL*Plus & SQL) Course

    Oracle iDS Forms: Build Internet Applications I Course

    Oracle iDS Forms: Build Internet Applications II Course

    Oracle 10g Database Administration Course

    C Programming Courses
    Cisco Courses
    Citrix Courses
    CIW Courses
    CompTia Courses
    Database Courses
    Exchange Server Courses
    Fortran Courses
    Internet Courses
    Java Courses
    JSP Courses
    Linux Courses
    MCSD Courses
    MCSE Courses
    Microsoft Courses
    Microsoft .NET Courses
    Microsoft Access Courses
    Microsoft Excel Courses
    Microsoft Outlook Courses
    Microsoft Powerpoint & Visio Courses
    Microsoft Project Courses
    Microsoft Server Products Courses
    Microsoft Word Courses
    Networking Courses
    Oracle Courses
    Perl Courses
    Programming Courses
    Security Courses
    SQL Courses
    SQL Server 2000 Courses
    SQL Server 2005 Courses
    Unix Courses
    VBA Courses
    Visual Basic Courses
    Windows 2000 Courses
    Windows Server 2003 Courses
    Windows Vista Courses
    Windows XP Courses
    XML Courses