Oracle Database 11g: Administration Workshop I Release 2 (Self-Study Course)

 

Who should attend

  • Database administrators
  • Technical consultants
  • Java developers

Prerequisites

  • Taken Oracle Introduction to SQL course or equivalent experience
  • Oracle Database: Introduction to SQL

Course Objectives

  • Monitor and administer undo data
  • Manage the database storage structures
  • Create and administer user accounts
  • Manage data concurrency
  • Perform basic backup and recovery of a database
  • Describe Oracle Database Architecture
  • Install Oracle Grid Infrastructure
  • Install and configure Oracle Database 11g
  • Configure Oracle Net services
  • Monitor performance

Product Description

  • Exploring the Oracle Database Architecture
    • Oracle Database Architecture Overview
    • Oracle ASM Architecture Overview
    • Process Architecture
    • Memory structures
    • Logical and physical storage structures
    • ASM storage components
  • Installing your Oracle Software
    • Tasks of an Oracle Database Administrator
    • Installation: System Requirements
    • Oracle Universal Installer (OUI)
    • Installing Oracle Grid Infrastructure
    • Installing Oracle Database Software
    • Silent Install
  • Creating an Oracle Database
    • Planning the Database
    • Using the DBCA to Create a Database
    • Password Management
    • Creating a Database Design Template
    • Using the DBCA to Delete a Database
  • Managing the Oracle Database Instance
    • Start and stop the Oracle database and components
    • Use Oracle Enterprise Manager
    • Access a database with SQLPlus
    • Modify database installation parameters
    • Describe the stages of database startup
    • Describe database shutdown options
    • View the alert log
    • Access dynamic performance views
  • Manage the ASM Instance
    • Set up initialization parameter files for ASM instance
    • Start up and shut down ASM instances
    • Administer ASM disk groups
  • Configuring the Oracle Network Environment
    • Use Enterprise Manager to create and configure the Listener
    • Enable Oracle Restart to monitor the listener
    • Use tnsping to test Oracle Net connectivity
    • Identify when to use shared servers and when to use dedicated servers
  • Managing Database Storage Structures
    • Storage Structures
    • How Table Data Is Stored
    • Anatomy of a Database Block
    • Space Management in Tablespaces
    • Tablespaces in the Preconfigured Database
    • Actions with Tablespaces
    • Oracle Managed Files (OMF
  • Administering User Security
    • Database User Accounts
    • Predefined Administrative Accounts
    • Benefits of Roles
    • Predefined Roles
    • Implementing Profiles
  • Managing Data Concurrency
    • Data Concurrency
    • Enqueue Mechanism
    • Resolving Lock Conflicts
    • Deadlocks
  • Managing Undo Data
    • Data Manipulation
    • Transactions and Undo Data
    • Undo Data Versus Redo Data
    • Configuring Undo Retention
  • Implementing Oracle Database Auditing
    • Describe DBA responsibilities for security
    • Enable standard database auditing
    • Specify audit options
    • Review audit information
    • Maintain the audit trail
  • Database Maintenance
    • Manage optimizer statistics
    • Manage the Automatic Workload Repository (AWR)
    • Use the Automatic Database Diagnostic Monitor (ADDM)
    • Describe and use the advisory framework
    • Set alert thresholds
    • Use server-generated alerts
    • Use automated tasks
  • Performance Management
    • Performance Monitoring
    • Managing Memory Components
    • Enabling Automatic Memory Management (AMM)
    • Automatic Shared Memory Advisor
    • Using Memory Advisors
    • Dynamic Performance Statistics
    • Troubleshooting and Tuning Views
    • Invalid and Unusable Objects
  • Backup and Recovery Concepts
    • Part of Your Job
    • Statement Failure
    • User Error
    • Understanding Instance Recovery
    • Phases of Instance Recovery
    • Using the MTTR Advisor
    • Media Failure
    • Archive Log Files
  • Performing Database Backups
    • Backup Solutions: Overview
    • Oracle Secure Backup
    • User-Managed Backup
    • Terminology
    • Recovery Manager (RMAN)
    • Configuring Backup Settings
    • Backing Up the Control File to a Trace File
    • Monitoring the Flash Recovery Area
  • Performing Database Recovery
    • Opening a Database
    • Data Recovery Advisor
    • Loss of a Control File
    • Loss of a Redo Log File
    • Data Recovery Advisor
    • Data Failures
    • Listing Data Failures
    • Data Recovery Advisor Views
  • Moving Data
    • Describe ways to move data
    • Create and use directory objects
    • Use SQL*Loader to move data
    • Use external tables to move data
    • General architecture of Oracle Data Pump
    • Use Data Pump export and import to move data
  • Working with Support
    • Use the Enterprise Manager Support Workbench
    • Work with Oracle Support
    • Log service requests (SR)
    • Manage patches

Price on request