Home > Vendors > oracle > d50079

Share

D50079 - Oracle Database 11g: Administration Workshop II

This Oracle Database 11g: Administration Workshop II Release 2 training takes the database administrator beyond the basic tasks covered in the first workshop. You’ll begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery.

Learn To:

  • Diagnose and repair data failures with Flashback technology.
  • Manage space to optimize database storage so you can respond to growing space requirements.
  • Monitor and manage major database components, including memory, performance and resources.
  • Secure the availability of your database through appropriate backup and recovery strategies.
  • Automate DBA tasks with the Scheduler.

Duration: 5.0 days

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:
  • Configure the Oracle Database for optimal recovery
  • Configure the database instance such that resources are appropriately allocated among sessions and tasks
  • Schedule jobs to run inside or outside of the database
  • Use compression to optimize database storage and duplicate a database
  • Back and recover a database (and its parts) with RMAN (command-line and Enterprise Manager)
  • Use flashback technology to view past states of data and to revert either objects or the entire database back to a past state
  • Use an appropriate and flexible memory configuration for your database
  • Identify burdensome database sessions and poorly performing SQL

Content

Module 1: Oracle Database 11g Release 2: Database Architecture and Recovery Operations
Module 2: Oracle Database 11g Release 2: The RMAN Catalog and Creating Backups
Module 3: Oracle Database 11g Release 2: Performing Restore and Recovery Tasks
Module 4: Oracle Database 11g Release 2: Using, Monitoring and Tuning RMAN
Module 5: Oracle Database 11g Release 2: Database Diagnostics and Flashback Technologies
Module 6: Oracle Database 11g Release 2: Managing Database Memory and Performance
Module 7: Oracle Database 11g Release 2: Managing Database Resources and the Scheduler
Module 8: Oracle Database 11g Release 2: Managing Database Space and Duplication

Audience

  • Database Administrators
  • Support Engineer
  • Technical Consultant
  • Technical Administrator

Prerequisites

  • Oracle Database 11g Database Administration
  • Oracle Database 11g: Administration Workshop I Release 2

Suggested Prerequisites:

  • Working knowledge of SQL and how to use PL/SQL packages

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
OjZIJz
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy
➤