1-877-WEBUCATE
(1-877-932-8228)
info@webucator.com
 
Microsoft Training
Java Training
XML Training
Database & SQL Training
PHP, Perl, ASP, Groovy, Grails, Ruby on Rails Training
HTML, JavaScript, Ajax & CSS Training
Adobe Training
◊ PUBLIC ORACLE TRAINING
Watch a 3-minute presentation
on our live instructor-led
online classes

How about taking a class directly from your home or office with a live instructor?
When you register for one of our instructor-led online Oracle classes, we send you a computer headset, the courseware for class, and some other goodies. At the time of class, you simply put your headset on and log in to our web conferencing software. You can hear everything the instructor says, see the complete presentation, and ask questions at any time. Classes are small, generally 2-6 students, full of hands-on exercises, and are never cancelled due to low enrollment.

To have someone contact you about our instructor-led online classes, please fill out the form below. We will also email you a class schedule and pricing.

* (Required)
* (Required)
* (Required)
* (Required)
* (Required)
(The number of people requiring training)
* (Required)
(For Federal Government Pricing)

Oracle Database 10g: Administration Level I (5 days)

Classes for individuals are delivered via the Web by a Webucator instructor over a live web conference. For more information on how these classes are delivered click here or call us toll free at 877-932-8228.

Click here for our private onsite Oracle classes

Date Range Price Register
January 26-30, 2009
(Start time: 10:00 AM ET)		 $2,095.00
February 9-13, 2009
(Start time: 10:00 AM ET)		 $2,095.00
March 23-27, 2009
(Start time: 10:00 AM ET)		 $2,095.00
April 13-17, 2009
(Start time: 10:00 AM ET)		 $2,095.00
May 18-22, 2009
(Start time: 10:00 AM ET)		 $2,095.00
You may also register by calling 1-877-932-8228.

Oracle Database 10g: Administration Level I Course Overview

In this Oracle database administration training class students gain the skills necessary for basic day-to-day administration of an Oracle10g database. This course is the starting points for Oracle database administrators and also sets the foundation for advanced administrator training and certification.

The target audience for this Oracle course is Oracle database administrators. Additionally, senior database developers will benefit from an understanding of the architecture of the Oracle database with which they interface.

Oracle Database 10g: Administration Level I Course Goals

  • Learn to install Oracle software and create new databases.
  • Explore the database architecture, including memory, process and data structures, and the management of those structures.
  • Learn to manage database files.
  • Learn to manage security policies and procedures, including administration of user accounts, roles, privileges and profiles.
  • Learn to use advanced self-tuning and self-management capabilities, including Oracle-Managed Files, database Advisors and other components of the Management Framework.
  • Learn to monitor performance, troubleshoot problems, and resolve lock and conflict issues.
  • Learn to use the Oracle Enterprise Manager and SQL interfaces for administration tasks.
  • Learn to control database support services, including iSQL*Plus, the Database Control, Oracle Net and others.
  • Learn about basic backup and recovery structures and strategies.
  • Explore operating system-specific considerations for Unix, Linux and MS Windows.

Oracle Database 10g: Administration Level I Course Prerequisites

Experience in the following areas is required:

  • Oracle SQL and PL/SQL

Oracle Database 10g: Administration Level I Course Outline

  1. Installing Oracle 10G Database Software
    1. Identify Database System Requirements
    2. The Optimal Flexible Architecture (OFA)
    3. Configure the Installation Environment
    4. Installation Using the Universal Installer
    5. More About Enterprise Manager
  2. Exploring the Oracle Database Architecture
    1. General Database Architecture
    2. Database Instance Memory Architecture
  3. Database Instance Process Architecture
    1. About the Instance Process Architecture
    2. Instance Background Processes
    3. Sql Execution Processes
  4. Creating an Oracle Database
    1. Create a Database
    2. Configure & Drop a Database
    3. Manage DBCA Templates
    4. Manually Creating a Database
  5. Controlling the Database Environment
    1. Starting & Stopping Database Control
    2. Starting & Stopping Isql*Plus
    3. Starting & Stopping the Database Listener
    4. Starting & Stopping the Database
    5. More About the Database Files
    6. Handling Parameter Files & Parameter Settings
  6. Storage Structures: Tablespaces
    1. About Tablespaces
    2. Tablespace Management
  7. Storage Structures: Data Files & Temp Files
    1. Managing Data Files
    2. Managing Temp Files
    3. About Oracle-Managed Files (OMF)
  8. Undo Management
    1. About Undo Space Management
    2. Configure Undo Management
    3. Guarantee Undo Retention
    4. Monitor Undo Space
    5. Use the Undo Advisor
  9. Database Security
    1. Database System Privileges
    2. Database Object Privileges
    3. Audit Database Activity
    4. Register For Security Updates
  10. Administering Users
    1. Create & Manage Database Accounts
    2. Grant & Revoke Database Privileges
    3. Resource Limits Via Profiles
    4. Password Management Via Profiles
    5. About Role-Based Security
  11. Managing Data: Loading Data With Sql Loader
    1. About the Database Utilities
    2. Using the Loader
    3. Understanding the Loader Process
    4. Control File Options
    5. Direct Path Loads
  12. Managing Data: Exporting & Importing Data
    1. Create Directory Objects
    2. EXPDP
    3. IMPDP
  13. Oracle Net Services
    1. What Is Oracle Net Services?
    2. Oracle Net Manager
    3. Listener Configuration
    4. Listener Administration
    5. Lsnrctl Commands
    6. Configuring Client Parameters
    7. Isolating the Problem
    8. Oracle Trace Assistant
    9. Network Troubleshooting Utilities
  14. Monitoring & Resolving Lock Conflicts
    1. About Latches & Locks
    2. More About Latches
    3. More About Locks
  15. Backup & Recovery Concepts
    1. About Database Backup & Recovery
    2. About Redo Data
    3. Redo Log File Maintenance
    4. Managing the Archive Options
    5. More About the Control File
  16. Storage Structures: Advanced Tablespaces (if time allows)
    1. More About Temporary Tablespaces
    2. About Temporary Tablespace Groups
    3. More About Permanent Tablespaces
    4. More About Bigfile Tablespaces
    5. More About the SYSAUX Tablespace
  17. Oracle Shared Servers (if time allows)
    1. Shared Servers Architecture
    2. Configuration Of Shared Server Mode

Oracle Database 10g: Administration Level I Course Materials

Each student will receive a comprehensive set of materials, including course notes and all the programming examples.

Oracle Database 10g: Administration Level I Course Technical Requirements and Setup Instructions

Click here for technical requirements and setup instructions

home - onsite classes - instructor-led online courses - self-paced online courses - why webucator - partners - contact - sitemap
© 2009 Webucator. All rights reserved. info@webucator.com | Toll Free: 877-WEBUCATE (877-932-8228) | From Outside the USA: 315-849-2724 | Fax: 315-410-5320
Phoenix, AZ | Santa Clara, CA | Santa Clara, CA | Los Angeles, CA | Sacramento, CA | Washington, DC | Atlanta, GA | Chicago, IL | Indianapolis, IN | Muncie, IN
New Orleans, LA Boston, MA | Cambridge, MA | Charlestown, MA | Framingham, MA | Ipswich, MA | Lincoln, MA | Wellesley, MA | Worcester, MA | Bangor, ME | Detroit, MI
Raleigh, NC Winston-Salem, NC | Lincoln, NE | East Hanover, NJ | Eatontown, NJ | Madison, NJ | Parsippany, NJ | Trenton, NJ | Albany, NY | Buffalo, NY | Rochester, NY
New York City, NY | Syracuse, NY | West Babylon, NY | Dayton, OH | Bethlehem, PA | Philadelphia, PA | Pittsburgh, PA | Pittsburgh, PA | State College, PA
Middletown, RI | Rapid City, SD | Austin, TX | Dallas, TX | Houston, TX | Arlington, VA | McLean, VA | Seattle, WA | Toronto, Canada | Ottawa, Canada | Calgary, CA