Oracle Database 11g: Administration Workshop II (Self-Study Course)

 

Who should attend

  • Database designers
  • Developers
  • Database administrators

Prerequisites

  • Oracle Database 11g: Administration Workshop
  • Working knowledge of SQL

Course Objectives

  • Recognize the steps for making sure that you can recover data quickly by tuning RMAN to avoid bottlenecks
  • Steps for making sure that any changes to a database can be easily reversed,using Oracle Database 11g's flashback features.
  • Identify the steps for diagnosing and repairing database problems with the help of Oracle Support using Automatic Diagnostic Repository, Support Workbench, and health checks
  • Identify the steps for making sure your Oracle Database 11g database is performing well and has adequate space, by monitoring statistics, tuning SQL, testing workloads,
  • Identify ways to ensure that resources are being put to best use and database jobs are performed when they should be, using the Database Resource Manager and the Scheduler
  • Recognize the steps for utilizing Oracle Database 11g's globalization support features to ensure that information and data is displayed in a user's native language
  • Recognize steps for configuring aspects of backup and recovery functionality in Oracle Database 11g
  • Identify the steps for preparing a database for backup and then for performing various types of RMAN backups and monitoring them
  • Identify ways to use RMAN to ensure that data is not lost in Oracle Database 11g
  • Recognize the structural elements in Oracle Database 11g's architecture and the steps for managing storage using disk groups

Product Description

  • Oracle Database 11g: Database Architecture and ASM
    • Database Architecture and ASM Overview
    • Disk Group Management and Storage
  • Oracle Database 11g: Configuring for Recovery
    • Recovery Operations
    • The RMAN Recovery Catalog
  • Oracle Database 11g: Configuring for Backups
    • Backup Specifications and RMAN
    • Performing User-Managed Backup and Recovery
  • Oracle Database 11g: Using RMAN for Recovery
    • Using RMAN to Perform Recovery
    • Duplicate Databases and TSPITR
  • Oracle Database 11g: Supporting RMAN and Using Flashback Technology
    • Monitoring and Tuning RMAN
    • Using Flashback Technology
  • Oracle Database 11g: Diagnosing the Database and Managing Memory
    • Diagnosing the Database
    • Managing Memory
  • Oracle Database 11g: Database Performance and Space Management
    • Managing Database Performance
    • Space Management
  • Oracle Database 11g: Managing Resources and Task Automation
    • Managing Database Resources
    • Task Automation and Administration
  • Oracle Database 11g: Globalization
    • Globalization Support

Price on request