Download PDF
of this course

Oracle Database 11g: New Features for Administrators DBA (DB11GNF)

  • Overview
  • Who Should Attend
  • Certifications
  • Prerequisites
  • Objectives
  • Content
  • Schedule
Course Overview

Duration: 5 Days

Price: SGD 4,200.00

This Oracle Database 11g: New Features for Administrators DBA Release 2 training explores new change management features and other key enhancements in Oracle Database 11g Release 1 and Release 2. Participating in hands-on practice sessions help reinforce your understanding of the new capabilities.

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.

Benefits to You

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter.

Utilize New Features to Manage Change

Topics covered include: the benefits and use of the new features in managing change, diagnosing and recovering from problems, ensuring high availability, improving scalability and performance and strengthening security. Expert Oracle University instructors will also review several other areas that are of particular interest to database administrators.

Who Should Attend

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

Course Certifications

This course is part of the following Certifications:

Prerequisites

Required Prerequisites:

  • Working knowledge of Oracle Database 10g

Suggested Prerequisites:

  • Oracle Database 10g: Administration Workshop II

 

Course Objectives

  • Install Oracle Grid Infrastructure
  • Install Oracle Database 11g Release 2
  • Use Oracle Restart to manage components
  • Use Automatic Storage Management (ASM) enhancements
  • Implement table compression and hybrid columnar compression
  • Implement data warehousing and partitioning enhancements
  • Use the SQL Performance Analyzer
  • Use SQL Plan Management and load SQL plan baselines
  • Use Database Replay to record and replay workloads
  • Set and manage Automatic SQL Tuning
  • Use Resource Manager enhancements
  • Use Enterprise Manager to monitor SQL commands
  • Use the new and enhanced RMAN features
  • Use Total Recall to create, protect, and use history data
  • Use Data Pump in legacy mode
  • Use Data Recovery Advisor

Course Content

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

 

Course ID: DB11GNF


Show Schedule for 1 Month  3 Months  All 
Date Country Location Register