"Well paced, 'hands on,' and very informative." More Testimonials »

Oracle 10g Administration eLearning Course


Save money by buying eLearning courses in packages.

Packages include multiple eLearning courses that are bundled together for a great value.

Of course, you can buy this Oracle 10g Administration eLearning course individually as well. Just click on the "Register Now" button below.


Oracle 10g Administration eLearning Course Series (14 hours, 51 minutes)

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.

Self-Paced Oracle 10g Administration eLearning Course Benefits

Only $99.95

12-month subscription!

Register Now

  • Learn Oracle 10g Administration online with these interactive online Oracle 10g Administration courses.
  • Affordable Pricing (Only $99.95 for the complete series)
  • A full year to complete the Oracle 10g Administration courses
  • Retake the Oracle 10g Administration 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. Oracle 10g Administration:1 Oracle Architectural Components (Time: 0 hours, 32 minutes)

This eLearning course provides an overview of the physical, memory, process, and logical structures that make up the Oracle 10g Database Server.

Course Objectives

  • 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

Course Topics

  • Oracle architectural components

2. Oracle 10g Administration:2 Oracle Server Introduction (Time: 0 hours, 10 minutes)

This eLearning course provides information on Oracle's installation and configuration tools.

Course Objectives

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

Course Topics

  • Oracle server introduction

3. Oracle 10g Administration:3 Database Architecture, Creation, and Interfaces (Time: 0 hours, 39 minutes)

This eLearning course provides an overview of programmatic interfaces within Oracle and different database architectures (shared server vs. dedicated server).

Course Objectives

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

Course Topics

  • Database architecture, creation, and interfaces

4. Oracle 10g Administration:4 Database Control and Storage Structures (Time: 1 hours, 31 minutes)

This eLearning course provides information on Oracle 10g's multithreaded agent technology, as well as Oracle's new Recycle Bin and Flashback technologies.

Course Objectives

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

Course Topics

  • Database control: multithreaded agents
  • Database control: startup and shutdown
  • Database control: listener
  • Database control: database storage structures

5. Oracle 10g Administration:5 Managing Users and Schemas (Time: 1 hours, 55 minutes)

This eLearning course provides the information you need to create, delete, and manage users, roles, and privileges within Oracle 10g.

Course Objectives

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

Course Topics

  • Managing users
  • Modifying tables
  • Constraints
  • Indexes
  • Views

6. Oracle 10g Administration:6 Data Management (Time: 0 hours, 57 minutes)

This eLearning course provides information pertaining to Oracle SQL*Loader and Data Pump technologies.

Course Objectives

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

Course Topics

  • Data management

7. Oracle 10g Administration:7 PL/SQL (Time: 1 hours, 21 minutes)

This eLearning course provides an overview of PL/SQL, information on how to declare PL/SQL variables, understand PL/SQL syntax, and write PL/SQL exception handlers.

Course Objectives

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

Course Topics

  • Overview of PL/SQL

8. Oracle 10g Administration:8 Database Security Management (Time: 0 hours, 59 minutes)

This eLearning course provides information on Oracle 10g's password file, profile, and auditing technologies.

Course Objectives

  • 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

Course Topics

  • Database security management

9. Oracle 10g Administration:9 Oracle Net Services (Time: 0 hours, 27 minutes)

This eLearning course provides information on Oracle's listener and Net Manager technologies.

Course Objectives

  • Define Oracle Net Manager and Oracle listener technologies

Course Topics

  • Oracle Net services

10. Oracle 10g Administration:10 Oracle Shared Server (Time: 0 hours, 28 minutes)

This eLearning course provides information on Oracle's Shared Server technology.

Course Objectives

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

Course Topics

  • Oracle Shared Server

11. Oracle 10g Administration:11 Database Performance Monitoring (Time: 0 hours, 44 minutes)

This eLearning course provides information on how Oracle gathers and uses statistics to tune and improve its performance.

Course Objectives

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

Course Topics

  • Explain database performance monitoring

12. Oracle 10g Administration:12 Database Maintenance (Time: 0 hours, 52 minutes)

This eLearning course provides information on how Oracle 10g establishes alert thresholds and gathers baseline metrics. It also explains how to use tuning and diagnostic advisors, as well as the Automatic Database Diagnostic Monitor (ADDM).

Course Objectives

  • 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

Course Topics

  • Database maintenance: alerts and thresholds
  • Database maintenance: advisors

13. Oracle 10g Administration:13 Database Undo Management (Time: 0 hours, 54 minutes)

This eLearning course explains how to enable and configure Oracle's undo management and flashback technology.

Course Objectives

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

Course Topics

  • Database undo management

14. Oracle 10g Administration:14 Database Locking Conflicts (Time: 0 hours, 19 minutes)

This eLearning course provides information on Oracle's row and table locking technology, as well as Oracle's deadlock management technology.

Course Objectives

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

Course Topics

  • Database locking

15. Oracle 10g Administration:15 Database Backup and Recovery Concepts (Time: 1 hours, 25 minutes)

This eLearning course provides information on how Oracle performs crash and instance recovery, as well as how Oracle works with redo log files and archived log files.

Course Objectives

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

Course Topics

  • Database backup and recovery: overview and fundamentals
  • Database backup and recovery: redo log files

16. Oracle 10g Administration:16 Database Backups (Time: 0 hours, 58 minutes)

This eLearning course provides information on configuring and using Oracle's Flash Recovery area to assist in performing server-managed (RMAN) database backups.

Course Objectives

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

Course Topics

  • Database backups using RMAN

17. Oracle 10g Administration:17 Database Recovery (Time: 0 hours, 40 minutes)

This eLearning course provides information on how to recover information from your databases and how to use Flashback Drop and Flashback Database as alternatives to point-in-time (incomplete) recovery.

Course Objectives

  • Describe how to use Flashback to perform database recovery

Course Topics

  • Database recovery
Client Success
  1. Independent Survey
  2. Client List
  3. Testimonials
Join The Team
  1. Learn how you can become a Webucator Trainer
  2. Career Opportunities
Locations
Watch 3-minute Demo Video
of Live Online Training:
Learn the benefits of online training with Webucator

Free Webinars

A Crash Course in CSS

Wed, 3/21 1:00 PM EST

Project Management Institute Partner

Webucator is a Registered Education Provider (R.E.P.) approved by PMI to issue professional development units (PDUs) for our training courses.

© Webucator, Inc. All rights reserved. | Toll Free: 1-877-932-8228 | From outside the USA: 315-849-2724| Fax: 315-849-2723