Preferred method of contact:

Oracle Database 12c Administration



Course Number



5 Days

PDF Add to WishList

Databases represent the core of an organisation’s informational infrastructure. In this Oracle administration training course, you learn the fundamental knowledge and skills to configure and support Oracle 12c databases, maintain your organisation’s data, and ensure the availability of your data by deploying backup, recovery, and flashback operations.

You Will Learn How To

  • Create, configure, and maintain Oracle 12c databases
  • Automate database administration using OEM Cloud Control 12c
  • Ensure database security by managing user privileges and roles
  • Manage storage to optimise space and performance
  • Implement Oracle partitions to manage large tables and indexes

Important Course Information

  • Requirements

    • Some background and experience working with a SQL-based relational database management system (RDBMS)
    • Experience at the level of:
  • Recommended Experience

    • Knowledge at the level of:
  • Software

    • This course is currently running on Oracle 12c, on the Windows Server 2008, R2 platform

Course Outline

  • Overview of Oracle Database 12

Configuring the instance and database

  • Balancing user requirements and resources
  • Ensuring database availability

Conceptualising the Oracle 12c architecture

  • Processing transactions with the Oracle 12c server
  • Identifying types of processes, memory structures and files
  • Constructing an Oracle 12

Creating the database

  • Automating memory allocation with memory targets
  • Establishing network connectivity
  • Setting up control files and online redo log files

Starting and stopping the database

  • Mounting and opening the database
  • Authenticating connections having SYSDBA privilege
  • Automating Administration with Oracle Enterprise Manager (OEM) Cloud Control 12

Evaluating the OEM architecture

  • Navigating the graphical interface
  • Comparing command-line and graphical techniques

Maintaining the database with OEM Cloud Control 12c

  • Setting thresholds and generating alerts
  • Managing privileges and roles
  • Evaluating container and pluggable databases
  • Flashing Back Oracle 12

Configuring UNDO tablespaces

  • Setting UNDO retention targets
  • Switching to an alternative UNDO tablespace

Monitoring and reversing changes to data

  • Tracking changes to data values with row history
  • Backing out user errors with Flashback Table
  • Retrieving dropped tables from the recycle bin
  • Implementing the Valid Time support feature
  • Managing Users and Resources

Establishing user accounts

  • Authenticating users with Oracle 12c password validation
  • Allocating space quotas and limiting resource usage

Enforcing security

  • Granting and revoking system and object privileges
  • Simplifying privilege management with roles
  • Capturing the use of privileges with dbms_privilege_capture
  • Performing Space Management

Building the storage hierarchy

  • Configuring tablespaces and datafiles
  • Handling sort data with temporary tablespaces
  • Creating Oracle Managed Files

Structuring data and index segments

  • Managing extents, blocks and large objects (LOB) storage
  • Eliminating row migration with PCTFREE and Data Pump
  • Conserving storage by compressing table data
  • Regaining space by shrinking tables and indexes online
  • Partitioning for Performance and Administration

Creating partitioned and subpartitioned tables

  • Evaluating range, list and hash partitioning methods
  • Administering partitions with merge, split, add and drop
  • Deploying partitioned tables based on virtual columns and referenced tables

Maintaining index partitions

  • Comparing the performance and maintenance of local and global indexes
  • Monitoring index partitions and rebuilding unusable indexes
  • Limiting indexing of partitions with partial indexing
  • Building a Fault-Tolerant Database

Safeguarding the database

  • Role of the redo log and control file
  • Ensuring recovery using archiving
  • Protecting and tracing the control file

Backing up the database and performing recovery

  • Implementing user-managed hot and cold backups
  • Restoring and recovering the entire database
  • Recovering corrupted tablespaces
  • Managing logical errors with flashback transaction back out
Show complete outline
Show Less

Convenient Ways to Attend This Instructor-Led Course

Hassle-Free Enrolment: No advance payment required to reserve your seat.
Tuition Fee due 30 days after you attend your course.

In the Classroom

Live, Online

Private Team Training

In the Classroom — OR — Live, Online

Tuition Fee — Standard: £2445  

6 - 10 Jan ( 5 Days)
9:00 AM - 4:30 PM GMT
London / Online (AnyWare) London / Online (AnyWare) Reserve Your Seat

30 Mar - 3 Apr ( 5 Days)
9:00 AM - 4:30 PM BST
London / Online (AnyWare) London / Online (AnyWare) Reserve Your Seat

13 - 17 Jul ( 5 Days)
9:00 AM - 4:30 PM BST
London / Online (AnyWare) London / Online (AnyWare) Reserve Your Seat

5 - 9 Oct ( 5 Days)
9:00 AM - 4:30 PM BST
London / Online (AnyWare) London / Online (AnyWare) Reserve Your Seat

AFTERNOON START: Attend these live courses online via Anyware

21 - 25 Oct ( 5 Days)
2:00 PM - 9:30 PM BST
Online (AnyWare) Online (AnyWare) Reserve Your Seat

20 - 24 Apr ( 5 Days)
2:00 PM - 9:30 PM BST
Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

11 - 15 May ( 5 Days)
2:00 PM - 9:30 PM BST
Rockville, MD / Online (AnyWare) Rockville, MD / Online (AnyWare) Reserve Your Seat

Show all dates
Show fewer dates

Guaranteed to Run

When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time, location — will run. Guaranteed.

Private Team Training

Enrolling at least 3 people in this course? Consider bringing this (or any course that can be custom designed) to your preferred location as a private team training.

For details, call 0800 282 353 or Click here »

This event has been added to your cart.

Tuition Fee


In Classroom or



Private Team Training

Contact Us »

Course Tuition Fee Includes:

After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.

Free Course Exam
You can take your Learning Tree course exam on the last day of your course or online any time after class.


Training Hours

Standard class hours:
9:00 a.m. - 4:30 p.m.

Last day class hours:
9:00 a.m. - 3:30 p.m.

Free Course Exam – Last Day:
3:30 p.m. - 4:30 p.m.

Each class day:
Informal discussion with instructor about your projects or areas of special interest:
4:30 p.m. - 5:30 p.m.

AFTERNOON START class hours:
2:00 p.m. - 9:30 p.m.

Last day class hours:
2:00 p.m. - 8:30 p.m.

Free Course Exam – Last Day:
8:30 p.m. - 9:30 p.m.

Each class day:
Informal discussion with instructor about your projects or areas of special interest
9:30 p.m. - 10:30 p.m.

- ,

Chat Now

Please Choose a Language

Canada - English

Canada - Français