Oracle Database 12c Administration Training

Level: Intermediate
Rating: 4.8/5 4.78/5 Based on 79 Reviews

Databases represent the core of an organization’s informational infrastructure. In this Oracle Database 12c Administration training course, you learn the fundamental knowledge and skills to configure and support Oracle 12c databases, maintain your organization’s data, and ensure the availability of your data by deploying backup, recovery, and flashback operations. You will learn to automate Oracle Database 12c administration using OEM Cloud Control 12c, ensure database security by managing user privileges and roles, manage storage to optimise space and performance, and implement Oracle partitions to manage large tables and indexes.

Key Features of this Oracle Database 12c Administration Training:

  • Attend online, in person, or bring this course to your facility
  • After-course instructor coaching

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

Choose the Training Solution That Best Fits Your Individual Needs or Organisational Goals

LIVE, INSTRUCTOR-LED

In Class & Live, Online Training

  • 5-day instructor-led training course
  • One-on-one after-course instructor coaching
  • Tuition fee can be paid later by invoice -OR- at the time of checkout by credit card
View Course Details & Schedule

Standard £2445

RESERVE SEAT

PRODUCT #2227

TRAINING AT YOUR SITE

Team Training

  • Bring this or any training to your organisation
  • Full - scale program development
  • Delivered when, where, and how you want it
  • Blended learning models
  • Tailored content
  • Expert team coaching

Customize Your Team Training Experience

CONTACT US

Save More on Training with Learning Tree Training Vouchers!

Our flexible, easy-to-redeem training vouchers are available to any employee within your organisation. For details, please call 0800 282 353 or chat live.

In Class & Live, Online Training

Note: This course runs for 5 Days *

*Events with the Partial Day Event clock icon run longer than normal but provide the convenience of half-day sessions.

  • 1 - 5 Feb 9:00 AM - 4:30 PM GMT Online (AnyWare) Online (AnyWare) Reserve Your Seat

  • 7 - 11 Jun 9:00 AM - 4:30 PM BST Online (AnyWare) Online (AnyWare) Reserve Your Seat

  • 23 - 27 Aug 9:00 AM - 4:30 PM BST Online (AnyWare) Online (AnyWare) Reserve Your Seat

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 — will run. Guaranteed.

Partial Day Event

Learning Tree offers a flexible schedule program. If you cannot attend full day sessions, this option consists of four-hour sessions per day instead of the full-day session.

Oracle Database 12c Administration Course Information

Oracle Database 12c Administration Course Outline

  • Overview of Oracle Database 12c Administration

    Configuring the instance and database

    • Balancing user requirements and resources
    • Ensuring database availability

    Conceptualizing the Oracle 12c architecture

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

    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 12c

    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 12c Data

    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

Team Training

Oracle Database 12c Administration Training FAQs

  • Can I learn to administer a Oracle Database 12c online?

    Yes! We know your busy work schedule may prevent you from getting to one of our classrooms which is why we offer convenient online training to meet your needs wherever you want. This course is available online, in person, or as Private Team Training.

Questions about which training is right for you?

call 0800 282 353
chat Live Chat




100% Satisfaction Guaranteed

Your Training Comes with a 100% Satisfaction Guarantee!*

*Partner-delivered courses may have different terms that apply. Ask for details.

Online (AnyWare)
Online (AnyWare)
Online (AnyWare)
Preferred method of contact:

Please Choose a Language

Canada - English

Canada - Français