Training Center
Computer Training courses online, at your pace !

Computer Training Online


Or call 800 639 0160








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




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 this entire online training course with one easy payment of $67

OR

Buy the Technical Pack, and receive this course plus many more, for only $197



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 





 

 

 

Copyright © 2007 TrainingCenter.com