Training Center
Computer Training courses online, at your pace !

Computer Training Online


Or call 800 639 0160

Course catalog - Improve Job Skills or Study For Certification Exams.                              








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




See How It Works

This online course includes tutorials for: Time Needed
Oracle Architectural Components 1 hour
Oracle Server Introduction 1 hour
Database Architecture, Creation and Interfaces 1 hour
Database Control and Storage Structures 1 hour
Managing Users and Schemas  2 hours
Data Management 1 hour
PL/SQL 1 hour
Database Security Management 1 hour
Oracle Net Services 1 hour
Oracle Shared Server 1 hour
Database Performance Monitoring 1 hour
Database Maintenance 1 hour
Database Undo Management 1 hour
Database Locking Conflicts 1 hour
Database Backup and Recovery Concepts 1 hour
Database Backups 1 hour
Database Recovery 1 hour
Estimated time needed to complete entire course 18 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

Oracle's new 10g database leverages the power of grid computing to spread tasks across multiple low cost machines. Learners will be able to install and maintain an Oracle 10g database in an effective, efficient manner. Topics such as the interaction among Oracle components, an understanding of Oracle's architecture, performance monitoring, database security, user management, and backup and recovery techniques are covered.




Oracle Architectural Components

  • Describe the stages that the Oracle 10g Database Server goes through in processing an SQL statement
  • Differentiate among a database, an instance and a server
  • Define the underlying physical, memory, process and logical structures of the Oracle 10g Database Server



Oracle Server Introduction

  • Define the functions of the Oracle Universal Installer
  • Explain Oracle's administration tools
  • Describe Oracle's configuration assistants



Database Architecture, Creation and Interfaces

  • Differentiate between shared server and dedicated server
  • Define and explain Automatic Storage Management (ASM)
  • Describe the different interfaces to the Oracle kernel



Database Control and Storage Structures

  • Describe Oracle's multithreaded agent technology
  • Explain Oracle's listener technology
  • Define Oracle's Recycle Bin and Flashback technology



Managing Users and Schemas

  • Define the roles of creating, deleting, and managing users
  • Define the creating, deleting, and managing roles
  • Define the create, delete, and manage privileges



Data Management

  • Describe Oracle's SQL*Loader technology
  • Describe the process used with large scale data imports and exports using the Data Pump technology



PL/SQL

  • Explain the method used to declare PL/SQL variables
  • Define the PL/SQL syntax
  • Describe PL/SQL exception handlers



Database Security Management

  • Explain how Oracle uses profiles to manage and secure passwords
  • Describe how Oracle uses a password file to secure DBA access
  • Define how Oracle uses auditing and audit trails to track access to the database



Oracle Net Services

  • Define Oracle Net Manager and Oracle listener technologies
  •  



Oracle Shared Server

  • Describe Oracle's Shared Server benefits, configuration, and technology
  •  



Database Performance Monitoring

  • Describe Oracle's statistics gathering, tuning, and monitoring
  •  



Database Maintenance

  • Explain how Oracle establishes alert thresholds
  • Describe how Oracle gathers baseline metrics
  • Define how to use Oracle tuning and diagnostic advisors
  • Describe Oracle's automatic workload repository 



Database Undo Management

  • Explain Oracle's undo management technology
  • Describe Oracle's flashback technology



Database Locking Conflicts

  • Explain Oracle's row and table locking technology
  • Describe Oracle's deadlock management technology




Database Backup and Recovery Concepts

  • Describe Oracle's crash and instance recovery technology
  • Define how Oracle works with online and archived redo log files




Database Backups

  • Explain how to perform server managed (RMAN) backups
  • Define how to configure and use Oracle's Flash Recovery area




Database Recovery

  • Describe how to use Flashback to perform database recovery 
  •  






 

          Tutorials for success

Copyright © 2010 TrainingCenter.com