Online Oracle Database 11g Administration II (1Z0-053) Training

Database » Oracle

Only $99.95

ONLINE Oracle TRAINING FEATURES

  • Learn Oracle online with these interactive online Oracle courses.
  • Affordable Pricing (Only $99.95 for the complete series)
  • A full year to complete the Oracle courses
  • Retake the Oracle courses as many times as you like
  • Measure your progress with assessment tests after each course
  • Earn completion certificates after passing each assessment test
  • Oracle Database 11g Administration II (1Z0-053) Series (26 hours)

1. Oracle Database 11g Administration II (1Z0-053):1 Using Oracle ASM

Time: 2 hours
This course discusses how Automatic Storage Management (ASM) can help manage disk space for all Oracle file types, including online and archived logs, RMAN backup sets, flashback logs, and even initialization parameter files (spfiles). This course examines what ASM is, how to configure an ASM instance, how to manage an ASM instance, and how to use ASM from within an Oracle database.

Objectives

  • Describe Automatic Storage Management (ASM)
  • Set up initialization parameter files for ASM and database instances
  • Start up and shut down ASM instances
  • Administer ASM diskgroups

Topics

  • Using Oracle ASM


2. Oracle Database 11g Administration II (1Z0-053):2 Performing User-Managed Backups

Time: 2 hours
This course provides an overview of Oracle 11g backup and recovery.

Objectives

  • Configure backup settings
  • Configure multiple archive log file destinations to increase availability
  • Identify the need of backup mode
  • Perform user-managed backups and server-managed backups
  • Back up and recover a control file

Topics

  • Performing User-Managed Backups


3. Oracle Database 11g Administration II (1Z0-053):3 Performing User-Managed Database Recoveries

Time: 2 hours
This course shows you how to restore databases with user-based backups. It covers backups taken in NOARCHIVELOG mode and ARCHIVELOG mode.

Objectives

  • Perform user-managed complete database recovery
  • Perform user-managed incomplete database recovery
  • Backup and recover a control file
  • Recover from a lost TEMP file
  • Recover from a lost redo log group
  • Recover from the loss of a password file

Topics

  • Performing User-Managed Database Recoveries


4. Oracle Database 11g Administration II (1Z0-053):4 Configuring and Backing Up Using RMAN

Time: 2 hours
This course provides an introduction to RMAN: its features and configuration and how to use it to back up your Oracle database.

Objectives

  • Allocate channels to use in backing up
  • Configure backup optimization
  • Define, apply and use a retention policy
  • Configure the Flash Recovery Area
  • Use Flash Recovery Area
  • Create image file backups
  • Create a whole database backup
  • Enable fast incremental backup
  • Create duplex backup and back up backup sets
  • Create an archival backup for long-term retention
  • Create a multi-section compressed and encrypted backup

Topics

  • Configuring and Backing Up Using RMAN


5. Oracle Database 11g Administration II (1Z0-053):5 Using the RMAN Recovery Catalog

Time: 1 hours
This course provides an overview of RMAN recovery catalogs, which can make your life as a DBA easier by providing a centralized repository for RMAN-related data.

Objectives

  • Identify situations that require an RMAN recovery catalog
  • Create and configure a recovery catalog
  • Synchronize the recovery catalog
  • Create and use RMAN stored scripts
  • Back up the recovery catalog
  • Create and use a virtual private catalog

Topics

  • Using the RMAN Recovery Catalog


6. Oracle Database 11g Administration II (1Z0-053):6 Recovering Databases with RMAN

Time: 1 hours
This course provides an overview of the use of Oracle Recovery Manager RMAN for database backup and recovery.

Objectives

  • Perform complete recovery from a critical or non-critical data file loss using RMAN
  • Perform incomplete recovery using RMAN
  • Recover using incrementally updated backups
  • Switch to image copies for fast recovery
  • Recover using a backup control file

Topics

  • Recovering Databases with RMAN


7. Oracle Database 11g Administration II (1Z0-053):7 Reporting, Monitoring, and Tuning with RMAN

Time: 1 hours
This course provides information on the reporting, monitoring, and tuning features available in RMAN.

Objectives

  • Monitor RMAN sessions and jobs
  • Tune RMAN
  • Configure RMAN for Asynchronous I/O
  • Report on and maintain backups

Topics

  • Reporting, Monitoring, and Tuning with RMAN


8. Oracle Database 11g Administration II (1Z0-053):8 Performing Advanced Recovery

Time: 1 hours
This course covers advanced recovery topics, including RMAN incarnations, RMAN database duplication, tablespace point-in-time recovery, and disaster recovery for Oracle databases.

Objectives

  • Restore a database onto a new host
  • Perform disaster recovery
  • Create a duplicate database
  • Use a duplicate database
  • Identify the situations that require TSPITR
  • Perform automated TSPITR

Topics

  • Performing Advanced Recovery


9. Oracle Database 11g Administration II (1Z0-053):9 Understanding Flashback Technology

Time: 2 hours
This course gives an overview of the functionality provided by Flashback technology in Oracle 11g, including the recovery of dropped objects, querying data as it existed at a point in time in the past, and returning the entire database to a point in time or SCN.

Objectives

  • Restore dropped tables from the Recycle Bin
  • Use Flashback Query and Flashback Transaction Query
  • Perform Flashback Table operations
  • Configure, monitor, and perform Flashback Database operations
  • Set up and use a Flashback Data Archive

Topics

  • Understanding Flashback Technology


10. Oracle Database 11g Administration II (1Z0-053):10 Diagnosing the Database and Managing Performance

Time: 2 hours
This course introduces tools you can use to diagnose problems in a database, and then detect and resolve performance issues.

Objectives

  • Set up Automatic Diagnostic Repository
  • Use Support Workbench
  • Perform block media recovery
  • Use the SQL Tuning Advisor
  • Use the SQL Access Advisor to tune a workload
  • Recognize Database Replay

Topics

  • Diagnosing the Database and Managing Performance


11. Oracle Database 11g Administration II (1Z0-053):11 Managing Database Resources

Time: 2 hours
This course describes how to effectively manage memory, space, and resources in Oracle 11g.

Objectives

  • Implement Automatic Memory Management
  • Configure SGA parameters
  • Configure automatic PGA memory management
  • Manage resumable space allocation
  • Use segment shrink functionality to reclaim table and index space
  • Create and use Database Resource Manager Components

Topics

  • Managing Memory
  • Managing Space
  • Managing Resources


12. Oracle Database 11g Administration II (1Z0-053):12 Using the Scheduler to Automate Tasks

Time: 2 hours
This course provides an overview of Oracle Scheduler and how to use it to manage jobs in the Oracle database.

Objectives

  • Create a job, program, and schedule
  • Use a time-based or event-based schedule for executing Scheduler jobs
  • Create lightweight jobs
  • Use job chains to perform a series of related tasks
  • Create Windows and Job Classes
  • Use advanced Scheduler concepts to prioritize jobs

Topics

  • Using the Scheduler to Automate Tasks


13. Oracle Database 11g Administration II (1Z0-053):13 Implementing Globalization Support

Time: 2 hours
This course explains how Oracle's globalization support lets you manage data in multiple native languages within the same database instance and simplifies global application development.

Objectives

  • Customize language-dependent behavior for the database and individual sessions
  • Work with database and NLS character sets

Topics

  • Implementing Globalization Support


14. Oracle Database 11g Administration II (1Z0-053):14 Practice Exam 1

Time: 1 hours
This course presents questions that will help you prepare for the Oracle Database 11g Administration II (1Z0-053) exam.

Objectives

  • Complete the practice exam questions

Topics

  • Practice Exam


15. Oracle Database 11g Administration II (1Z0-053):15 Practice Exam 2

Time: 1 hours
This course presents questions that will help you prepare for the Oracle Database 11g Administration II (1Z0-053) exam.

Objectives

  • Complete the practice exam questions

Topics

  • Practice Exam


16. Oracle Database 11g Administration II (1Z0-053):16 Practice Exam 3

Time: 1 hours
This course presents questions that will help you prepare for the Oracle Database 11g Administration II (1Z0-053) exam.

Objectives

  • Complete the practice exam questions

Topics

  • Practice Exam


17. Oracle Database 11g Administration II (1Z0-053):17 Practice Exam 4

Time: 1 hours
This course presents questions that will help you prepare for the Oracle Database 11g Administration II (1Z0-053) exam.

Objectives

  • Complete the practice exam questions

Topics

  • Practice Exam



Resources for Oracle Database 11g Administration II (1Z0-053)

  • Know of a good resource for Oracle Database 11g Administration II (1Z0-053) Online Training? Please Let Us Know.
Student Login



  1. Forgot My Password
  2. Support

Live eLearning

Like a class you would go to, but you don't have to go anywhere

More...

Try a Free Course

Click here to try a free course.

Partners & Resources
  1. View Partners & Resources
  2. Become a Partner
© Webucator, Inc. All rights reserved. | Toll Free: 877-932-8228 | UK: 0808-101-3484 | From outside the USA: 315-849-2724| Fax: 315-849-2723