Oracle8

This series introduces users to the Oracle 8 relational database management system. It examines its main components and installation, and discusses concepts related to database design, creation, and management, including creating, modifying, and managing tablespaces. Management of files and user accounts is also examined, along with table views and indexes. Advanced topics covered in this series include Oracle processes, job queues, and security monitoring. Data backup and recovery and database replication are also discussed in detail.

Syllabus

INSTALLING ORACLE

Introduces users to Oracle administration and shows how to install Oracle8.

• Introduction to Oracle Administration
• How Oracle Operates
• Oracle Performance
• Preparing for Installation
• Installing Oracle
• The Oracle Components

DATABASE MANAGEMENT

Shows users how to manage the Oracle8 databases and servers.

• Planning for Capacity and Sizing
• Calculating the System Requirements
• Calculating the Disk Requirements
• Managing the Database
• The Oracle Enterprise Manager
• Server Manager and Database Assistant
• Starting and Shutting Down Instances
• Connecting to and Modifying an Instance

BUILDING DATABASES

Shows users how to create and set up new Oracle databases.

• Database Planning and Design
• Creating a New Database and Catalogs
• Modifying Databases
• Creating Tablespaces
• Modifying Tablespaces
• Managing Tablespaces

FILES, DATA AND USERS

Shows users how to manage files, import and export data, and manage user accounts.

• Redo Log Files
• Control Files and Rollback Segments
• Managing Rollback Segments
• Creating User Accounts
• Modifying User Accounts
• Managing User Profiles
• Managing User Roles

DATABASE SCHEMA OBJECTS

Shows users how to manage tables and indexes.

• Understanding Tables
• Creating Tables
• Special Tables and Table Views
• Indexes
• Creating Indexes
• Special Indexes
• Synonyms and Table Sequences

PROCESSES AND SECURITY

Explains server processes and discusses how to use Oracle security features.

• Exporting Data
• Importing Data
• The SQL*Loader Utility
• Understanding Processes
• Monitoring Processes
• Managing Job Queues
• Using Oracle Auditing

BACKUP AND RECOVERY

Shows users how to protect Oracle database data by creating and using backups. It also shows them how to recover from hardware or software failure through various recovery and restoration processes.

• Oracle Backups
• Configuring Disks for Protection
• Backup and Recovery strategies
• Backing Up the Database
• Recovering the Database
• Replicating Databases

Qualifications

Qualification: Printable Transcript

On completion of this course you may print a transcript off as evidence of your progression throughout the course.

Requirements for Entry

There is no experience or previous qualifications required for enrolment on this course. It is available to all students, of all academic backgrounds.

Study Options

If you do not have Internet access, or would prefer to study this course via the traditional paper/postal based study method, you can find more information on the course by clicking on the link below.

Study Hours

This is only an approximate figure and is dependant upon how much time you can dedicate to your studies and how well you grasp the learning concepts in the course material. Furthermore, at the end of each lesson there is a question paper that needs to be completed and returned to your tutor. You should allow at least 1 - 2 hours of study to complete each question paper.

The approximate amount of time required to complete the course is: 40 hrs.