The eLearning Center for Gatlin Education Services

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.

Installing Oracle
Time: 4.0 hour(s)
Summary:
This course introduces users to Oracle administration and shows how to install Oracle8.
Objectives:
* Define the job of Oracle Administration.
* Explain basic Oracle operation.
* List the factors that affect Oracle performance.
* Prepare for Oracle installation.
* Install Oracle.
* Identify the major components of Oracle.
Topics:
* Introduction to Oracle Administration
* How Oracle Operates
* Oracle Performance
* Preparing for Installation
* Installing Oracle
* The Oracle Components

Database Management
Time: 5.0 hour(s)
Summary:
This course shows users how to manage the Oracle8 databases and servers.
Objectives:
* Plan for database capacity and size.
* Calculate the system requirements of a database and server.
* Calculate the disk requirements of a database and server.
* Manage a database.
* Use Server Manager and Database Assistant.
* Start and shut down instances of databases.
* Connect to and modify instances of databases.
Topics:
* 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
Time: 4.0 hour(s)
Summary:
This course shows users how to create and set up new Oracle databases.
Objectives:
* Plan and design a database.
* Prepare for a new database.
* Create a new database and catalog.
* Modify a database.
* Create and modify tablespaces.
* Manage tablespaces.
Topics:
* Database Planning and Design
* Creating a New Database and Catalogs
* Modifying Databases
* Creating Tablespaces
* Modifying Tablespaces
* Managing Tablespaces

Files, Data, and Users
Time: 4.0 hour(s)
Summary:
This course shows users how to manage files, import and export data, and manage user accounts.
Objectives:
* Use redo log files.
* Describe control files and rollback segments.
* Create user accounts.
* Manage user accounts.
* Manage user roles.
Topics:
* 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
Time: 4.0 hour(s)
Summary:
This course shows users how to manage tables and indexes.
Objectives:
* Create tables.
* Manage different table views and types.
* Create indexes.
* Identify and use index types.
Topics:
* Understanding Tables
* Creating Tables
* Special Tables and Table Views
* Indexes
* Creating Indexes
* Special Indexes
* Synonyms and Table Sequences

Processes and Security
Time: 4.0 hour(s)
Summary:
This course explains server processes and discusses how to use Oracle security features.
Objectives:
* Export and import data using Export/Import.
* Load data using the SQL*Loader Utility.
* Describe the types of Oracle processes.
* Monitor Oracle processes.
* Manage Oracle job queues.
* Use Oracle Auditing for security monitoring.
Topics:
* Exporting Data
* Importing Data
* The SQL*Loader Utility
* Understanding Processes
* Monitoring Processes
* Managing Job Queues
* Using Oracle Auditing

Backup and Recovery
Time: 5.0 hour(s)
Summary:
This course 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.
Objectives:
* Describe Oracle backups.
* Configure systems for maximum protection of data.
* Create backup and recovery strategies.
* Back up databases.
* Recover data from backups.
* Replicate databases.
Topics:
* Oracle Backups
* Configuring Disks for Protection
* Backup and Recovery strategies
* Backing Up the Database
* Recovering the Database
* Replicating Databases