Oracle Database Oracle Database 11g OCM Exam Preparation Workshop Ed 2.x

Duration: 
5 days
Codes: 
11G,D69748,OCM
Versions: 
2.X

Overview

This course takes the database administrator beyond the basic tasks covered in the first workshop. You'll begin by gaining a much deeper understanding of possibly the most important job of a DBA: backup and recovery.Learn To:Automate DBA tasks with the Scheduler.Diagnose and repair data failures with Flashback technology.Manage space to optimize database storage and to be able to respond to growing space requirements.Monitor and manage major database components, including as memory, performance and resources.Secure the availability of your database by appropriate backup and recovery strategies.Backup RecoveryExpert instructors will also help you explore the concepts and architecture that support backup and recovery. You'll become familiar with the steps of how to carry it out in various ways and situations. Gain the skills to define and test your own backup and recovery scenarios. Learn Performance Evaluation Tuning TasksThis course will also teach DBAs how to manage memory effectively. Learn how to perform some performance evaluation and tuning tasks, including using some of the advisors.You'll also learn about the different types of flashback technologies, scheduling jobs inside and outside of the database and controlling system resource usage.

Audience

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

Skills Gained

  • 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
  • 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

Prerequisites

Required Prerequisites:

  • Advanced knowledge and use of Oracle Enterprise Server technology and features
  • Proficiency in Oracle 11g SQL
  • Oracle Database 11g OCP Certification
  • Working knowledge of LINUX command language

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
Onsite
Onsite5 2500 £2500 2019-05-20