Oracle Database 11g: New Features for Administrators Release 2 (Self-Study Course)

 

Who should attend

  • Database administrators
  • Data Warehouse administrators
  • Sales consultants
  • Technical consultants

Prerequisites

  • Working knowledge of Oracle Database 10g

Course Objectives

  • Identify how to install Oracle Grid Infrastructure for a stand-alone server
  • Identify how to Install, configure and maintain Oracle Database 11g
  • Recognize the ASM enhancements in Oracle Database 11g Release 2
  • Recognize the ASM enhancements in Oracle Database 11g Release 2
  • Identify the data warehouse and partitioning enhancements in Oracle Database 11g Release 2
  • Provide a secure database and control access to the network using Oracle Database 11g Release 2
  • Plan for and then measure the effectives of changes within the data center infrastructure
  • Identify how to adequately test system changes
  • Identify how to use the intelligent infrastructure enhancements to automatically gather performance information and tune the database
  • Recognize how to quickly identify and resolve database issues
  • Identify how to monitor SQL statements in real time and enhance database performance
  • Identify how to use the improved features of Oracle Database 11g Release 2 to improve application performance
  • Identify the backup and recovery improvements Oracle Database 11g Release
  • Identify the flashback technology, LogMiner and data pump improvements in Oracle Database 11g Release 2
  • Identify how to use the Data Recovery Advisor to repair data failures
  • Implement task scheduling and database backup features

Product Description

  • Oracle Database 11g Release 2: Installation and Oracle Restart
    • Installing the Oracle Grid Infrastructure
    • Oracle Database 11g Release 2 Installation
  • Oracle Database 11g Release 2: ASM, Storage and Partitioning Enhancements
    • ASM Enhancements
    • Storage Enhancements
  • Oracle Database 11g Release 2: Oracle Partitioning and Security Features
    • Data Warehouse and Partitioning Enhancements
    • Security and Network Enhancements
  • Oracle Database 11g Release 2: Using Change Management Solutions
    • SQL Performance Analyzer and Plan Management
    • SQL Performance Analyzer and Plan Management
  • Oracle Database 11g Release 2: Intelligent Infrastructure Enhancements
    • Intelligent Infrastructure
  • Oracle Database 11g Release 2: SQL Monitoring and Performance Enhancements
    • SQL Monitoring and Performance Enhancements
  • Oracle Database 11g Release 2: Application Performance Enhancements
    • Application Performance Enhancements
  • Oracle Database 11g Release 2: Backup, Recover, Archive, and Repair Data
    • Backup and Recovery Enhancements
    • Flashback, LogMiner, and Data Pump Enhancements
    • Data Recovery Advisor
  • Oracle Database 11g Release 2: Oracle Scheduler and Secure Backup
    • Oracle Scheduler and Secure Backup Cloud

Price on request