Course Introduction

This Oracle training course takes the candidates beyond the scope of Workshop I. It gives a better and a deeper understanding of the duties of the DBA. It mainly deals with Backup and Recovery using almost all the tools at the disposal of the DBA.

  • topics-icons

    Have an in-depth understanding of the duties of an Oracle DBA

  • topics-icons

    Use Flashback to recover data to a past state

  • topics-icons

    Use RMAN to perform BACKUP and RECOVERY

  • topics-icons

    Salaries Range from £26,500 to £48,000

  • topics-icons

    Expert Professionals Provide Training with Hands-On Practices

  • topics-icons

    Very Low Prices

What’s included

BPT offers more benefits. Here is what's included with this course:

exam

Tutor Support

exam

Certificate

Prerequisites

The candidates must hold a certificate in Oracle Database 11g Administration Workshop I Release 2. Familiarity with Oracle SQL or equivalent and PL/SQL will be an added advantage.

Show More

Delegates will learn how to

The Candidates will be able to perform the following actions after the course completion:

  • Backup and Recovering a Database using RMAN (Command Line Interface and Enterprise Manager)
  • Using Flashback to View Past States of Data and Revert the Database or Objects to that state.
  • Using an Adaptable Memory Configuration for the Database
  • Isolating sessions with heavy Traffic and bad performing SQL Statements
  • Configuring the Oracle Database for Optimal Recovery
  • Configure the Database instance to allocate Resources appropriately among Sessions and Tasks
  • Scheduling jobs
  • Optimizing Database storage
Show More

Target Audience

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

Course Information

The candidates learn to implement Performance evaluation and Tuning of the Oracle Database including some advisors. They also use various advisors, flashback technologies, and job scheduling for such purposes. Also they learn to control resource usage.

During the course the participants will learn the following:

  • Diagnose and repair data failures with Flashback technology
  • Monitor and manage major database components, including as memory, performance, and resources
  • Automate DBA tasks with the Scheduler
  • Diagnose and repair data failures with Flashback technology
  • Secure the availability of your database by appropriate backup and recovery strategies
Southampton

Southampton

Our state of the art venue based in Southampton has the latest learning tools to help you enhance your skills as a professional proje... Learn More

Popular Locations

Reaching You Across The World

enquireEnquiry call02380
001008