Oracle 10g Database Administration
Course Description
This course gives you the skills you need to become a proficient Oracle 10g Database administrator. You'll gain a solid Oracle 10g expertise combined with an understanding of how to apply that technical knowledge in a corporate database administration environment. In this training we will discuss the top Ten Problems of 10g Administration and then see how experienced 10g Administrators have resolved these issues.

You'll learn about Oracle 10g architecture, key Oracle 10g software components, and basic administration tasks. Specifically, the course covers: 10g's logical, physical components, database creation options, and managing of Oracle 10g database schema. When you complete this training, you will return to your company with an understanding of backup and recovery techniques, database security and auditing.

The course also covers the different types of database objects and discusses how they interact. In addition, you will have the opportunity to use and become familiar with Oracle Enterprise Manager and see how it supports DBA functions and activities.
Course Overview
By the End of the Course You Will:
  • Develop the skills necessary to perform basic Oracle Database administration tasks 
  • Be able to install Oracle software, configure an Oracle 10g instance, and manage database structures 
  • Know how to perform backup and recovery tasks, and troubleshoot performance issues on an Oracle 10g Database
Prerequisite Knowledge and Skills:
  • Basic knowledge of Oracle Database
Recommended Audience
  • Database Administrators 
  • Support Engineers 
  • Database Sales Consultants 
  • Technical Consultants 
  • Database Designers 
  • Project Managers
Course Agenda
  DAY 1  

Oracle Database Architecture Overview
  • What is an Oracle Database?
  • Architecture and Concepts
  • Oracle Grid and Oracle Application Architecture
  • Physical Database and Logical Database Structures
  • Schemas and Common Schema Objects
  • Oracle Data Dictionary
  • Oracle Enterprise Manage
  • Oracle Utilities
  • Scalability and Performance
  • Database Backup and Recovery
  • High Availability for Oracle Databases
  • Business Intelligence and the 10g Database
  • Content Management
  • Basic Oracle 10g security considerations
  • Information Integration
Installing and Creating an Oracle Database
  • Overview of Installing an Oracle Database
  • Installing Oracle Software and Database
  • Using DBCA to Create and Configure a Database
  • Database and Instance Startup and Shutdown
  • Bringing it all together - Oracle Installation and Database Creation
Lab, Day 1: Installing and Creating Oracle Database


  DAY 2  

Logical and Physical Storage Management
  • Oracle Database Storage Structure
  • Control Files, Log Files, Archived Log Files, and Online Redo Log File
  • Viewing, Creating, Modifying, and Dropping Tablespaces
  • Other Storage Structures
  • Reclaiming Wasted Space
  • Undo Data, Undo Tablespace Size and Retention Time
  • Set Up Automatic Undo Management
  • Managing Undo with Enterprise Manager
  • Using the Undo Advisor
  • Making Changes to the Database Storage Structure
  • Rollback Segments
  • Datafiles
  • Tablespaces
  • Other Storage Structures
  • Viewing, Creating, Modifying, and Dropping Tablespaces
  • Reclaiming Wasted Space within a 10g Database
  • Undo Data
  • Undo Tablespace Size and Retention Time
  • Setting Up Automatic Undo Management
  • Managing Undo with Enterprise Manager
  • Using the Undo Advisor
  • Making Changes to 10g's Database Storage Structure
Lab, Day 2: Managing Logical and Physical Storage in Oracle 10g


  DAY 3  

Managing Database Security and Auditing in Oracle 10g
  • Overview of Database Security within 10g
  • Administrating Roles within 10g
  • Managing Automatic Tax Calculation with Oracle 10g
  • Administrative Accounts
  • Viewing, Creating, Modifying, and Dropping Roles in 10g
  • Administrating Profiles and Privileges in 10g:
    • System Privileges
    • Object Privileges
  • Creating, Editing and Dropping Users in 10g
  • Types and Records of Auditing
  • Actions Audited by Default
  • Specific Auditing
  • Enabling and Disenabling Standard Auditing
  • Viewing 10g Database Audit Trail Information
Lab, Day 3: Auditing an Oracle 10g Database


  DAY 4  

Managing Schema Objects in Oracle 10g
  • Managing , Viewing, and Creating Tables in Oracle 10g Database
  • About Tables
  • Managing, Viewing, and Creating Tables
  • Modifying Table Attributes
  • Loading Data into Tables
  • Dropping a Table
  • About Indexes
  • Viewing, Creating, Dropping Indexes 
  • About Views
  • Displaying, Creating, and Dropping Views
  • Other Schema Objects
  • Management of Schema Objects
Lab, Day 4: Managing of Schema Objects
Course Location/s
New York
55 Broadway, 21st Floor
New York, NY 10006

San Francisco
450 Sansome, 13th Floor
San Francisco, CA 94111
Course Cost
$ 1,500 for OAUG members
$ 2,000 for non-members
Course Date/s
New York - Registration Closed
From March 22nd to 25th, 2010
9:00 am to 5:00 pm
San Francisco - Registration Closed
From April 26th to 29th, 2010
9:00 am to 5:00 pm

Continue checking other workshops