Learn Oracle8 online with these interactive online Oracle8 courses.
Affordable Pricing (Only $42.95 for the complete series)
A full year to complete the Oracle8 courses
Retake the Oracle8 courses as many times as you like
Measure your progress with assessment tests after each course
Earn completion certificates after passing each assessment test
Oracle8 Series (30 hours)
1. Oracle8:1 Installing Oracle
Time: 4 hours
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
2. Oracle8:2 Database Management
Time: 5 hours
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
3. Oracle8:3 Building Databases
Time: 4 hours
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
4. Oracle8:4 Files, Data, and Users
Time: 4 hours
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
5. Oracle8:5 Database Schema Objects
Time: 4 hours
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
6. Oracle8:6 Processes and Security
Time: 4 hours
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
7. Oracle8:7 Backup and Recovery
Time: 5 hours
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
Resources for Oracle8
Know of a good resource for Oracle8 Online Training? Please Let Us Know.