Learn more about the Oracle Database Administration 12c certification training course.
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.
The course is run 5 days full time.
You will need some experience working with SQL. You should be able comfortable with basic SQL such as :
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.
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.
Download the full course schedule below
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\)
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
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
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
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
Choose your training options. Attend a public or private training.
This is what our clients have to say
Answers to some of the most frequently asked questions.
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.
The training runs at your premises or you can come to us. We require a minimum of 4 delegates for a private training.
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.
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.
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.
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.
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.
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.