D72074 - Oracle Database 11g: New Features for Administrators Accelerated

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.

Duration:

Enquire Now

Start learning today!

Click Hereto customize your Training

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

Content

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

Audience

  • Database Administrators
  • Sales Consultants
  • Support Engineer
  • Technical Consultant
  • Data Warehouse Administrator

Prerequisites

Working knowledge of Oracle Database 10g

Certification

product-certification

This course is not associated with any Certification.

Course Benefits

product-benefits
  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

Oracle Popular Courses

d90871

This training is the first step in mastering MySQL, the world’s most popular open source database.

p10380

P10380 - Oracle Database 18c: Administration Workshop

d79995

Learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code.

d83527

D83527 - Java SE 8 Fundamentals
Enquire Now
 
 
 
 
4F7CzD
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy