oracle 8 online training course

See How It Works

This online course includes:	Time Needed
Installing Oracle	4 hours
Database Management	5 hours
Building Databases	4 hours
Files, Data, and Users	4 hours
Database Schema Objects	4 hours
Processes and Security	4 hours
Backup and Recovery	5 hours
Estimated time needed to complete entire course	30 hours

Receive your login ID to take the training courses online, as many times as you wish, for 1 year. Click here for group orders.

Buy the Technical Pack, and receive this course plus many more, for only $197
Bonus: Order a value pack NOW, and receive Free unlimited "Instant Mentoring", real time help, so you can chat online, with a support person, as needed (24 hours a day, 7 days a week). You can ask your mentor to clarify concepts, fine tune solutions, confirm a process or simply seek assurance that you understand a topic.

Benefits

Unlimited access for 1 year
Learn anytime, anywhere
You control the pace
Start & stop wherever you want
No books to read
No software needed
Value Packs include Free online tech support
Double guarantee

100% Money back guarantee
One time payment No monthly fee
Use the course index for review anytime
Answer course questions with at least 70% accuracy and print your own certificates of completion to prove that you have mastered each training course.
Free status reports for company managers

Requirements

All you need is a PC with Windows, the Microsoft Internet Explorer (browser) and an Internet connection.
Note: The online computer training is designed to work only with Internet Explorer. Prices shown are per user.

What You will Learn

This online training course 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 online training course include Oracle processes, job queues, and security monitoring. Data backup and recovery and database replication are also discussed in detail.

Installing Oracle

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

Database Management

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

Building Databases

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

Files, Data, and Users

Use redo log files
Describe control files and rollback segments
Create user accounts

Manage user accounts
Manage user roles

Database Schema Objects

Create tables
Manage different table views and types

Create indexes
Identify and use index types

Processes and Security

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

Backup and Recovery

Describe Oracle backups
Configure systems for maximum protection of data
Create backup and recovery strategies

Back up databases
Recover data from backups
Replicate databases

Oracle 8 Join over 1 million people who learn online, with these complete interactive computer training courses.

Oracle 8
Join over 1 million people who learn online, with these complete interactive computer training courses.