Oracle Database Administration Certification Training Course

Prepare for the Oracle Certified Associate Database Administration Training exam.


Upcoming Course Schedule

About this course

Learn more about the Oracle Database Administration 12c certification training course.



What is the course about

The Oracle Database 12c Administration course will teach you about the Oracle Database architecture. You will discover how to effectively manage an Oracle Database instance, configure the Oracle Network Environment and perform database maintenance. This is a required course to attain the Oracle Associate Database Administrator Certification for Oracle 12c.

Duration

The course is run 5 days full time.

Programming Experience

You will need some experience working with SQL. You should be able comfortable with basic SQL such as :

  • Adding into the database by performing an INSERT query
  • Removing records by performing a DELETE operation
  • Updating records using the UPDATE statement
  • Extract data from the database using the SELECT statement
Technical Skill

The Oracle Database runs on Linux and knowledge of basic Linux administration skills is required in order to succeed in this course. The course is suitable for database developers and administrators.

Private Training

This course is only offered privately. The training can run onsite or on our premises. We have offices in Cape Town and Johannesburg. A minimum of 4 delegates is required to schedule the course. The price for running onsite is R12 599 and R15 500 on our premises. There is no fixed date to run the course, we work with you to find a date that will suit your team.

Course Schedule

Download the full course schedule below

Oracle Database 12c New Features

Setup a Global Database Service (GDS)
Define declarative policies for Oracle Data Redaction
Apply best practices for running the ADDM Advisor

Design a database, identify requirements, create the logical design and physical database design
Install and configure a database
Grant Enterprise Manager administrative privileges
Use SQL*Plus and SQL Developer to access your database

Define the main components of an Oracle Instance
Describe the various stages of a database instance
Articulate the various basic memory structures
Describe how a block of data is written to the database
Articulate the mandatory background processes

Explain the Memory Structures
Describe the Process Structures
Overview of Storage Structures

Identify the tools for Administering an Oracle Database
Plan an Oracle Database installation
Install the Oracle software by using Oracle Universal Installer \(OUI\)

Creating an Oracle Database

Create a database by using the Database Configuration Assistant \(DBCA\)

Setting database initialization parameters
Describe the stages of database startup and shutdown
Using alert log and trace files
Using data dictionary and dynamic performance views

Configure and Manage the Oracle Network
Using the Oracle Shared Server architecture
Describe the differences between Shared Server and Dedicated Server architecture as it relates to Oracle Connection Manager
Describe the Oracle Database listener architecture
Configure and connect to a database service
Configure a database listener

Overview of tablespace and datafiles
Create and manage tablespaces
Space management in tablespaces

Create and manage database user accounts
Grant and revoke privileges
Create and manage roles Create and manage profiles

Managing Data and Concurrency

Monitor and resolve locking conflicts

Overview of Undo Transactions and undo data Managing undo

Database Security and Principle of Least Privilege
Work with Standard Database Auditing

Use and manage optimizer statistics
Use and manage Automatic Workload Repository \(AWR\)
Use advisory framework Manage Alerts and Thresholds

Use Automatic Memory Management
Use Memory Advisors Troubleshoot invalid and unusable objects

Intelligent Infrastructure Enhancements

Use the Enterprise Manager Support Workbench Managing Patches

Identify the types of failure that can occur in an Oracle database
Describe ways to tune instance recovery
Identify the importance of checkpoints, redo log files, and archived log files Overview of flash recovery area
Configure ARCHIVELOG mode

Overview of Data Recovery Advisor
Use Data Recovery Advisor to Perform recovery \(Control file, Redo log file and Data file\)

Explain general best practices and guidelines for backups on the Oracle database
Implement recovery procedures for various failure scenarios
Use the Data Recovery Advisor for backup and recovery solutions
Create consistent database backups
Back up your database without shutting it down
Create incremental backups
Automate database backups
Manage backups, view backup reports and monitor the flash recovery area

Explain the benefits of multitenant architecture for database consolidation
Create a pluggable database (PDB)
Articulate the difference between a Container database and a Pluggable database
Perform administration tasks on a container database (CDB)
Manage processes in a CDB
Manage physical and logical structures in a CDB
Describe the various storage options for a PDB

Oracle Database Monitoring

Use Oracle Enterprise Manager to view database storage structures
Apply different strategies for interacting with the database using SQL Developer
Describe the EM Cloud Control and EM Express architecture as it relates to the database
Manage structures used to undo changes made to the database and maintain data consistency

Implement the various Data Guard configurations available
Explain the architectural differences between Data Guard and Active Data Guard
Implement the various replication options available to the Oracle database
Create an MAA architecture that leverages Active Data Guard and Oracle Golden Gate
Choose the appropriate high availability architecture based on various planned and unplanned scenario

Download Course Outline
Course Pricing

Choose your training options. Attend a public or private training.

Public Training
R13860
  • Training at our center
  • Small class size
  • 5 days instructor led
  • Access to Slack channel
  • Access to materials website
  • 6 months after training support
  • Teamviewer, email and telephone support
  • Personalized feedback
  • Light lunches
Reserve Seat
Popular
Private Training - Onsite
R10450
  • Training on your site
  • Choose as many delegates as you want
  • 5 days instructor led
  • Access to Slack channel
  • Access to materials website
  • 6 months after training support
  • Teamviewer, email and telephone support
  • Personalized feedback
  • Customized course content
  • You provide the lunches
Enquire Now

Newsletter Sign Up

No Spam - Only latest news, price and activity updates
What people say about our courses

This is what our clients have to say

After attending the Xamarin training from Peruzal on our site, we were able to drastically accelerate our internal mobile app development efforts. Peruzal was a phone call away each time we needed support.
Jonathan Winnaar Scientist @ Institute for Maritime Technology
Came across your courses on Google search, after searching for Ruby training around South Africa. We were completely blown away with how much your trainers know stuff.
Divan Santan Infrastrucutre Engineer @ First National Bank
After our DBA left, we were left with noone with the skills to manage the research and scientific database Infrastrucutre. With Peruzal, we were able to get our team running in a matter of a week.
Encarni Colmenero Astronomer @ Southern African Large Telescope
Our team had different backgrounds, application programmers and astronomers with varied database interactions, we did not have formal training in the MySQL database. Peruzal delivered the training onsite and we were comfortable working with MySQL.
Lucian Botha Astronomy Information System Specialist @ South African Astronomical Observatory
“Coming from an academic background, with no prior exposure to programming, I had to develop an Android mobile app for tuition and research purposes. Peruzal helped me to build and implement the app in record time!”
Thuli Shandu Lecturer @ Univeristy of South Africa
Having years of experience in automation and embedded systems, we wanted our team to have experience in developing for Android. Peruzal did send a trainer onsite and we were blown away with the amount of information we had learnt in just 5 days
Cobus Smith Automation Manager @ ArcelorMittal
FAQS

Answers to some of the most frequently asked questions.



Public Training
What is public training

With public training you attend the course with other delegates from other companies at our premises. If you would like private training we can arrange that the training be done at your premises, however, we require a minimum of 4 delegates for a private course.

What is private training

The training runs at your premises or you can come to us. We require a minimum of 4 delegates for a private training.

Refund Policy

Should you not be happy with the training, this should be raised within the first hour of training. We will try to resolve the issue and if we can't we refund 100% your money.

Cancelling Training

You can not cancel the course once you have booked. Please make sure that you have resolved your dates before making a booking. It takes a long time to organise the training, so we will not be able to refund once you book, however we can try to re-schedule the course at a later date for you.

Course Pricing
How much does the course cost?

The course price depends on whether the course will be on your site(private training) or at our offices(public). For a private course we require a minimum of 4 delegates in order to schedule the course.

How long does it take to complete the course

Most of our coruses are offered over 5 days full time, except for the Xamarin Cross Platform Mobile App Development course which is offered over 2 weeks. No part-time courses are offered at the moment.

Accomodation

We don't provide accomodation but we can help you find accomodation close to the center. We can also help you with arranging transport to pick you up from the airport.

Our preferred accomodation provider is AirBnb. We recommmend if its your first time, only book from a Super Host on AirBnB.

Certificate of Completetion

Our mobile app development courses are hands on, for you to receive a certificate of completion, you will need to demonstrate that you have master the concepts during the course by developing a production mobile application and deploying it to the Google Play or Apple store. No certificates of completion will be awarded without proof that you have developed and deployed your app to the relevant store.