Oracle 11g: Administration Workshop II Training

  • Overview
  • Course Content
  • Drop us a Query

Focusing on the fundamentals of the Oracle database structure and architecture, Oracle Database 11g Administration Workshop II training imparts knowledge on managing the space so that database storage can be optimized to respond to growing space requirements. The Oracle Database 11g: Administration Workshop II certification facilitates in-depth understanding of the responsibilities that a DBA has to perform: performing backup and recovery and a lot more which helps them to add perfection in their work.

After completing the Oracle Database 11g Administration Workshop II certification, the candidates would be able to:

  • Diagnose and repair data failures with Flashback technology.
  • Make the use of compression to optimize database storage and duplicate a database.
  • Understand and describe what is Back and recover a database (and its parts) with RMAN (command-line and Enterprise Manager)?
  • Implement the intelligence of configuring the database instance, such a way that resources are appropriately allocated among sessions and tasks.
  • Manage major database components, including memory, performance and resources.
  • Make an effective use of flashback technology to view past states of data and to revert either objects or the entire database back to a past state.
  • Describe as well as test your own backup and recovery scenarios.
  • Manage memory effectively, perform the performance evaluation and tuning tasks.
  • Make an effective use of the compression to optimize database storage and duplicate a database
Target audience
  • Support Engineer
  • Technical Consultant
  • Database Administrators
  • Technical Administrator
Prerequisites

The candidates should have knowledge of Oracle Database 11g Database Administration and working knowledge of SQL and how to use PL/SQL packages

1 Oracle Database 11g Release 2: Database Architecture and Recovery Operations

  • Oracle Database Architecture
  • Backup and Recovery Operations

2 Oracle Database 11g Release 2: The RMAN Catalog and Creating Backups

  • The RMAN Recovery Catalog
  • Creating Backups with RMAN

3 Oracle Database 11g Release 2: Performing Restore and Recovery Tasks

  • Restore and Recovery Tasks
  • Performing User-Managed Backup and Recovery

4 Oracle Database 11g Release 2: Using, Monitoring and Tuning RMAN

  • Using RMAN to Perform Recovery
  • Monitoring and Tuning RMAN

5 Oracle Database 11g Release 2: Database Diagnostics and Flashback Technologies

  • Diagnosing the Oracle Database
  • Flashback Technologies

6 Oracle Database 11g Release 2: Managing Database Memory and Performance

  • Managing Memory
  • Managing Database Performance

7 Oracle Database 11g Release 2: Managing Database Resources and the Scheduler

  • Managing Resources
  • Task Automation and Administration

8 Oracle Database 11g Release 2: Managing Database Space and Duplication

  • Oracle Database 11g Release 2: Managing Database Space and Duplication
  • Duplicate Databases

Partners

A Few Things You'll Love!

What our Students Speak

+