Database Courses > Oracle Database Administration Training Course
Course Fee = £1300 (excl.VAT)
Oracle Database Administration Course Outline
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
This is an instructor led training course taught in a classroom based environment.
Course Classification:
Course Fee = £1300 (excl.VAT)
Scheduled course dates
| July 2009 |
August 2009 |
September 2009 |
October 2009 |
November 2009 |
If you want to attend the course but can't make the dates published, then please get in touch as we may well be able to add additional dates to those published or to re-arrange the course. Additionally, you could take advantage of one-to-one training with our SoloIT Training packages that also enables you to attend this course on dates that suit.
|