Course Code: O12CDBA
Duration: 5 days
This Oracle Database 12cR2 Administration course is designed to give the Oracle database administrator practical experience in administering, monitoring, tuning and troubleshooting an Oracle 12c database.
A database administrator will gain an understanding of the architecture and processes of the Oracle database server. The delegate will learn how to ensure the integrity and availability of a company's data within the Oracle environment. The delegate will also learn how to monitor the performance of a database, allocate resources with the Resource Manager and schedule jobs with the Oracle Job scheduler.
Versions supported 12cR2, 18c, 19c.
This course aims to provide the delegate with the knowledge required to maintain successful and efficient day-to-day operations of an Oracle 18c or 12cR2 database. The delegate will gain practical experience in administering and monitoring an Oracle 12c database.
This Oracle Database 12cR2 Administration course is for anyone who needs to administer, monitor and support an Oracle 12c database.
The delegate will learn and acquire skills as follows:
Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.
This course will aid the delegate in their preparation for the following exam:
Attending this course together with the Oracle SQL Fundamentals course will help delegates gain many of the skills and product knowledge requirements as outlined in the exam objectives. Studying this course and its associated reference materials can form part of the preparation to achieve certification. Experience, practice, self-study and aptitude are also key requirements for exam success.
Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.
Exams are not included as part of the course.
Delegates who wish to attend the Oracle Database 12cR2 Administration course should have an understanding of relational database concepts and good operating system knowledge. They should have attended the Oracle SQL course or have a good working knowledge of Oracle SQL. The ability to describe and use Oracle built-in PL/SQL packages would be highly advantageous but is not essential.
This course is run on a Linux operating system, a basic knowledge of Linux/UNIX is recommended but is not essential.
The trainer patiently provided a good quality training even though it was 100% remote. The pace was correct and the contents adequate to the topic at hand. The training was one on one which doesn't make it easy on the instructor, but he performed really well and was able to transmit the knowledge from the course manual with ease. Thanks to the trainer and to the whole team for providing this good experience. Much appreciated, Nicolas.
Nicolas - Finance
Lots of information to go through in just the week. Overall, learned a lot and the structure and operation of the databases makes a lot more sense than it did before.
Noel - IT
This course has prepared me well for me to start as a DBA with my company.
Daniel - Database Administrator - Utilities
A very good course well delivered. The trainer frequently expanded on the provided material using real world examples and his own experience which was beneficially to all.
Kris - Systems Engineer - IT
Extremely useful course for any DBA, delves into lots of areas of Oracle 12c Administration. I've learnt lots of fundamental knowledge that I did not possess prior to the course. Course delivered very well by tutor. Tutor was more than happy to answer any uncertainties. Very positive and friendly. Course content is extremely detailed. Would recommend tutor and course to anyone looking to learn Oracle 12c Administration.
Raymond - Database Administrator - Government
The tutor was very knowledgable and very patient
John - DBA Team Leader
Duration: 5 days
Price: £2,250.00 exc. VAT
StayAhead Live Virtual Classroom
Our Customers Include
Our Course Curriculum