Course Code: O11GDBAII
This Oracle Database 11g Release 2 DBA - Part II course introduces the delegate to advanced administration tasks. Participants will learn how to plan and implement a backup and recovery strategy using Recovery Manager. They will also learn how to control database resources using the Resource Manager; how to automate administration tasks with the Scheduler and how to carry out performance monitoring and tuning.
This Oracle Database 11g Release 2 DBA - Part II course is suitable for both users of Release 1 and Release 2.
The delegate will learn and acquire skills as follows:
This Oracle Database 11g Release 2 DBA - Part II course is designed for database administrators and technical support staff who are required to plan and implement database backup and recovery strategies for Oracle Database 11g Release 1 or Release 2 databases. Administrators will also learn about the tools available to monitor database performance and the steps that can be taken to improve database performance.
The Oracle Database 11g Release 2 DBA - Part II course introduces delegates to the main concepts of Oracle backup and recovery. They will learn how to plan and implement a backup and recovery strategy using RMAN. Delegates will also learn to manage memory effectively, carry out some evaluation and tuning exercises, control database resources using Resource Manager and automate tasks with the Scheduler.
The course covers the major topics required for the Oracle examination 1Z0-053 Oracle Database 11g: Administration II.
Exams are not included as part of the course.
Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.
Delegates who wish to attend this Oracle Database 11g Release 2 DBA - Part II course should have a working knowledge of Oracle SQL and Oracle Database Administration, good operating system knowledge is also essential. This can be obtained by attendance on the Oracle SQL and Oracle Database 11g Release 2 DBA - Part I courses. Knowledge of Oracle PL/SQL would be beneficial.
Very enjoyable course with an excellent instructor with lots of real world experience to backup the course content with plenty of additional information to use once we are back in a production environment. I thoroughly enjoyed the course and will be recommending it to my colleagues
Ian - Systems and Infrastructure Manager - Storage - June 2017
The instructor was exceptional.
Josh - System Administrator - Government
A complex topic explained clearly and methodically at an easily digestible pace. Well done StayAhead.
Simon - Lead Application Specialist
Good instruction. Instructor was flexible in what we asked for. Very pleased with course.
- Developer DBA - Government
Very good course, extremely knowledgeable tutors and good practical's to go with the tutor lead sections.
Peter - Transport
Good course, well delivered. Objectives met. Thankyou very much.
Matthew - assistant dba - IT
Our independent Oracle, Solaris & Red Hat Linux curriculums helps prepare delegates for official certification.
Technical course content was excellent and just what I required regards procedures, functions and packages, so the exercises were very useful and learning the syntax and formats and commands. Plenty of time was allocated for practical exercises and writing code which I would encourage on future courses. The theory was much needed also and improved my understanding of PL/SQL I have already seen in daily tasks. The trainer was very knowledgeable and took time to explain sections as required and answers to any questions. The folder will be very beneficial in practicing back at work to consolidate these Oracle skills.Andrew - Application Support Manager - Postal/Distribution - February 2018