◊ ORACLE8 ONLINE TRAINING SERIES
Online Oracle8 Training
Database » Oracle
Only $99.95
Oracle8 Series (30 hours)
ONLINE Oracle8 TRAINING FEATURES
- Learn Oracle8 online with these interactive online Oracle8 courses.
- Affordable Pricing (Only $99.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
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. 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. 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. 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. 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. 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. 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
