Oracle Database 12c New Features for Administrators — A 5 day course

contact usEnquire about this course

Synopsis

This Oracle 12c New Features for Administrators course is designed to give Oracle Database Administrators practical experience in using the new features available in Oracle Database 12c. Delegates will gain an appreciation of how these features may be implemented at their own sites.

Objectives

This Oracle 12c New Features for Administrators course is designed to give existing Oracle 11g Database Administrators the knowledge and skills needed to implement the new features of 12c database. The Oracle Database 12c administrator will gain practical experience in administering and monitoring an Oracle 12c database.

The delegate will practise:

Suitable For

This Oracle 12c New Features for Administrators course is designed for Oracle professionals who need to gain an understanding of and implement the new features and functionality introduced in Oracle Database 12c.

Prerequisites

Delegates who wish to attend this Oracle 12c New Features for Administrators course should have good understanding of Oracle Database 11g administration. Knowledge of using PL/SQL packages is strongly recommended.

Examination

The course covers the major topics of the "New Features of Oracle Database 12c" elements required for the Oracle examination 1Z0-060: Upgrade to Oracle Database 12c. Note that this course covers only the "New Features of Oracle Database 12c" and does not cover the "Key DBA Skills" elements of this exam.

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, nor included in the course fee.

Publicly scheduled dates, locations, and prices

Select a date to enquire about availability of places. For dates after 28 January 2017, please call 0333 210 0140 or use our contact form to enquire about places and availability.

Leeds — £1945 (+VAT)

London — £1945 (+VAT)


Contents

Changes to Database Management Tools

Oracle Database 12c Architecture

Create a Database with the Database Configuration Assistant (DBCA)

Preparation for Upgrade to Oracle Database 12c

Perform an Upgrade to Oracle Database 12c

Post Upgrade Tasks

Migrate Data with Data Pump

Configure and Create a Container Database and Pluggable Databases

Manage a Container Database and Pluggable Databases

New Tablespaces and Management Features

Manage Common and Local Users, Roles and Privileges

Manage Back-Up, Recovery and Flashback of a CDB and PDB

On-Line Datafile Move and Automatic Data Optimisation

In Database Archiving

Enhancements to Database Auditing

Enhancements and Privileges

Data Redaction

New RMAN Features

Monitoring Database Operations

Schema and Data Changes

SQL and PL/SQL Enhancements

Performance Tuning New Features

Resource Manager and Other Performance Enhancements

ADR and Network Support

Data Pump and SQL*Loader Enhancements

Partitioning Enhancements