Oracle Database 11g Administration Training (DBA)

This Hands-on class on Oracle 11g Administration Fundamentals covers all the topics to be able to effectively administer the database. The class ranges from basic, thorough explanation of the Oracle internal architecture, to how to manage users, files of the database, and perform backup and recovery bboth using user defined methods and RMAN. It offers an introduction to networking the Oracle environment and tuning the Oracle database.

The class is engaging, interactive, hands-on and complete with course materials and lab assignments. Come and be a part of the Oracle 11g Administration Training Now !

Learn Oracle 11g Administration Now – Course Content

Exploring the Oracle Database Architecture Oracle 11g Administration Training

  • Oracle Database Architecture Overview
  • Interacting with an Oracle Database
  • Process Architecture
  • Database Storage Architecture
  • Oracle Enterprise Manager

Preparing the Database Environment

  • Tasks of an Oracle Database Administrator
  • Tools Used to Administer an Oracle Database
  • Installation: System Requirements
  • Optimal Flexible Architecture (OFA)
  • Setting Environment Variables
  • Oracle Universal Installer (OUI)

Creating an Oracle Database

  • Planning the Database
  • Password Management
  • Database Configuration Options
  • Oracle Managed Files (OMF)
  • Using the DBCA to Create a Database
  • Using the DBCA to Delete a Database

Managing the Files of the Database

  • Working with Control Files
  • Working with Redo Log Files
  • Working with Archive Log Files
  • Understand the use of Log Files
  • Database Configuration Options

Managing the Oracle Instance

  • Initialization Parameters and Parameter Files
  • Database Startup and Shutdown
  • Understanding the Data Dictionary¬† Views and Dynamic Views

Managing Database Storage Structures

  • Logical Structure of the Database
  • Physical Structure of the Database
  • Anatomy of a Database Block
  • Space Management in Tablespaces
  • Tablespaces in the Preconfigured Database
  • Creating and Managing Tablespaces

Administering User Security

  • Database User Accounts, creation and management
  • Predefined Accounts
  • Benefits of Roles
  • Predefined Roles
  • Implementing Password Security Features
  • Assigning Quota to Users

Managing Schema Objects

  • What Is a Schema?
  • Accessing Schema Objects
  • Specifying Data Types in Tables
  • Creating and Modifying Tables
  • Understanding Data Integrity
  • Overview of the types of Indexes
  • Temporary Tables

Managing Undo Data

  • DML, Transactions and Undo Data
  • Configuring Undo Retention
  • Guaranteeing Undo Retention

Configuring the Oracle Network Environment

  • Oracle Net Services & Listener
  • Establishing Net Connections
  • Tools for Configuring and Managing the Oracle Network
  • Net Services Administration Pages
  • Naming Methods

Backup and Recovery Concepts

  • Different types of Failures
  • Media Failure
  • Archiving in the Oracle database and Archive Log Files

Performing Database Backups

  • Backup Solutions: Overview
  • User-Managed Backup – Hot and Cold Backup
  • Backing Up the Control File to a Trace File
  • Understanding the Flash Recovery Area

Performing Database Recovery

  • User Managed Complete Recovery
  • User Managed Incomplete Recovery
  • Examples Recovery different types of files in the Oracle Database
  • Loss of a Control File
  • Loss of a Redo Log File
  • Loss of Datafiles
  • Data Recovery Advisor
  • Data Failures
  • Listing Data Failures

Configuring RMAN

  • RMAN Architecture
  • Launch & Use RMAN
  • Configure RMAN Settings

Backup  and Recovery With RMAN

  • About Backup File Types
  • Performing Full Backups
  • Performing Incremental Backups
  • Establishing A Backup Retention Policy
  • Generate Reports
  • Report Need Backup
  • List Command in RMAN
  • Complete Recovery with RMAN
  • Incomplete Recovery with RMAN

Moving Data

  • Data Pump: Overview
  • Logical Backup – Export Data
  • Import Data
  • Directory Object: Overview
  • Basics of SQL*Loader: Overview

Oracle Flashback Technology

  • About Flashback Technology
  • Flashback Query
  • Configuring Undo Management For Flashback
  • Flashback Table
  • Flashback Drop
  • Flashback Versions Query
  • Flashback Transaction Backout

Database Maintenance

  • Introducing Terminology
  • Optimizer Statistics
  • Automatic Workload Repository (AWR)
  • Automatic Database Diagnostic Monitor (ADDM)
  • Advisory Framework
  • Automated Maintenance Tasks
  • Server-Generated Alerts
  • Reacting to Alerts

Comprehensive Oracle 11g Administration Training brought to you by OracleCOACH – Call (202) 656 0260