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 practise:
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.
NOTE: Course technical content is subject to change without notice.
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.
Having previously undertaken a similar course in the past I expected this course to not be especially beneficial, however this was not the case at all. I have garnered some very useful new skills and knowledge. The trainer's subject knowledge and delivery are a credit to himself and Stayahead. I was constantly engaged and rarely found myself requiring a repeat of the coursework but when needed he was more than helpful in explaining where I was struggling.Laurence - Operations Support - Finance - September 2017