Oracle Database 11g: New Features for Administrators Accelerated (D72074)

Oracle Database 11g: New Features for Administrators Accelerated (D72074)

Overview

Duration: 5 Days

This Oracle Database 11g: New Features for Administrators Accelerated course teaches you about change management features and other key enhancements in Oracle Database 11g Release 1 and Release 2. You’ll explore managing change, diagnosing and recovering from problems, ensuring high availability, while improving scalability and performance.

Learn To:

  • Implement manageability features to simplify database management.
  • Use change management features to master database changes.
  • Use database advisors to provide proactive database monitoring.
  • Increase data availability by using ASM, RMAN and Flashback feature enhancements.
  • Describe the key new capabilities in Oracle Database 11g (11.2.0.2).
  • Identify how these new features can be applied in your own environments.
  • Identify technical advantages and business benefits associated with these technologies.
  • Proceed towards the adoption and implementation of Oracle Database 11g Patch Set 1 with greater confidence.

Objectives

Upon completing this course, the learner will be able to meet these overall objectives:
  • Use Total Recall to create, protect, and use history data
  • Use Data Pump in legacy mode
  • Describe the key new capabilities in Oracle Database 11g (11.2.0.2)
  • Manage space with the enhanced segment management
  • Use the capabilities of the enhanced database manageability
  • Install Oracle Database 11g Release 2
  • Install Oracle Grid Infrastructure
  • Use the Oracle ASM and ACFS enhancements
  • Implement table compression and hybrid columnar compression
  • Implement data warehousing and partitioning enhancements
  • Use the SQL Performance Analyzer
  • Use Database Replay to record and replay workloads
  • Use Resource Manager enhancements
  • Use Oracle Restart to manage components
  • Use Enterprise Manager to monitor SQL commands
  • Use the new and enhanced RMAN features
Module 1: Oracle Grid Infrastructure

Module 2: Installation and Upgrade Enhancements

Module 3: Oracle Restart

Module 4: ASM Enhancements

Module 5: Storage Enhancements

Module 6: Data Warehouse and Partitioning Enhancements

Module 7: Oracle SecureFiles

Module 8: Security and Networking Enhancements

Module 9: SQL Performance Analyzer

Module 10: SQL Plan Management

Module 11: Database Replay

Module 12: Automatic SQL Tuning

Module 13: Intelligent Infrastructure Enhancements

Module 14: Diagnosability Enhancements

Module 15: SQL Monitoring & Performance Enhancements

Module 16: Backup and Recovery Enhancements

Module 17: Flashback Technology, LogMiner, and Data Pump & Data Recovery Advisor

Module 18: Introduction to Oracle Database 11.2.0.2

Module 19: Oracle ASM and ACFS Enhancements

Module 20: Enhanced Segment Management

Module 21: Performance Enhancements

Module 22: Enhanced Real Application Testing
N/A
  • Working knowledge of Oracle Database 10g
Course ID:
D72074


Show Schedule for:

Please provide as much information as possible for us to help you with your enquiry.