Skip to Content

Training Resources

Current Training Schedule

Class Registration Form

Get Adobe Reader

expand or collapse the menu Accessibility

expand or collapse the menu Web Development

expand or collapse the menu Adobe / Macromedia Web

expand or collapse the menu Programming

expand or collapse the menu Databases

expand or collapse the menu Professional Courses

expand or collapse the menu Adobe

expand or collapse the menu Microsoft SharePoint

expand or collapse the menu Technical

expand or collapse the menu Geographic (GIS)

expand or collapse the menu Microsoft Office

Training Resources

Current Training Schedule

Class Registration Form

Get Adobe Reader

Oracle Database Administration – Introduction

3 day course

View Detailed Outline in PDF format

Get Adobe Reader

The overall objective of this course is to allow the reader to gain the skills necessary for basic day-to-day administration of an Oracle database. This course is the starting point for Oracle database administrators and also sets the foundation for advanced administrator training and certification. In this course, you will perform key administrative tasks in Oracle Database 10g, such as creating and controlling databases, administering users, implementing security features, monitoring performance, and performing backup and recovery.

Course Topics:

(for a full detailed outline, visit our PDF link above)

Installing Oracle Database 10g

Exploring the Oracle Database Architecture

  • Understand Database Architecture
  • Identify Database Object Types
  • Recognize the Oracle Instance
  • Understand the User Connection Process
  • Identify Resources for the DBA

Creating a Database

  • Create, Configure & Delete a Database w/the DBCA
  • Use Client and Administration Tools

Configuring Oracle Net Services

  • Examine Oracle Net Services
  • Perform Basic Oracle Net Server-Side Configuration
  • Perform Basic Oracle Net Client-Side Configuration
  • Configure Oracle Shared Server
  • Configure Connect-Time Failover

Using SQL and PL/SQL

  • Write Simple SQL SELECT Statements
  • Filter and Sort Data
  • Work with SQL Functions
  • Work with Multiple Tables
  • Modify Data
  • Control Database Transactions
  • Explore PL/SQL

Managing the Database Instance

  • Obtain Instance Information
  • Manage the Database Instance
  • Organize Database Objects
  • Describe Database Objects and Their Storage

Managing Tablespaces and Datafiles

  • Manage Tablespaces
  • Find Tablespace and Datafile Information
  • Resize and Drop Tablespaces
  • Configure Oracle Managed Files

Managing Tables and Indexes

  • Create Tables
  • Gather and Analyze Table Information
  • Create Indexes
  • Implement Integrity Constraints
  • Maintain Integrity Constraints

Creating Views and Sequences

Managing Users and Security

  • Manage Users
  • Manage Privileges and Roles
  • Manage Passwords and Resource Limits
  • Audit Database Usage

Monitoring Performance

  • Manage Locks
  • Tuning and Troubleshooting Information

Loading and Unloading Data

  • Manage Data Using the Data Pump
  • Move Tablespaces
  • Load Data Using SQL*Loader
  • Create and Access External Tables

Managing Undo Data

  • Configure Undo Segments and Tablespaces
  • Understand Automatic Undo Retention

Administering and Performing Backups

  • Create Redo Log Groups and Members
  • Plan and Configure the Online Redo Log Group
  • Manage and Maintain Control Files
  • Back Up the Database
  • Examine Recovery Manager Concepts

Recovery Operations

  • Manage Recovery
  • Employ User-Managed and RMAN Recovery
  • Tune Database Recovery