You are here:Courses|Oracle|Database Administration|Oracle Database 12c : New Features for 11g/ 10g DBAs

Oracle Database 12c : New Features for 11g/ 10g DBAs

This Oracle Database 12c course offers insights into the new features and functionalities available for administrators. Participants will learn how to utilize these features best in order to ensure reliable, fast and optimal performance.

Course Objectives :

  • Building, managing and maintaining pluggable and multitenant container databases
  • Managing data file operations, data lifecycle management using heat maps and ensuring automatic data optimization.
  • Setting up unified audit trail
  • Understanding and utilizing new privileges available, such as SYSDG, SYSBACKUP, SYSKM
  • Managing privilege analysis
  • Using the enhancements in Recovery Manager
  • Managing performance of the database by monitoring DB operations, using Compare Period ADDM and Real-Time ADDM
  • Comparing two databases with the help of Schema Change Plans in order to transmit changes in one environment to another
  • Comparing data across different environments using Data Comparisons
  • Tuning SQL performance with the help of SQL Plan Directives, Adaptive Execution Plans, and statistics enhancements
  • Using enhanced Resource Manager to manage resources in a pluggable and multitenant container database
  • Exploring features in SQL*Loader Express Mode and Oracle Data Pump
  • Using DDL and online operations while partition compression and movement
  • Implementing partial global partitioned indexes
  • Applying new and latest SQL enhancements such as SQL row limiting clause and extended data type columns
Course Exam # Exam Regular Track
(days)
Fast Track
(days)
Oracle Database 12c: New Features for Administrators NEW 1Z0-060 Upgrade to Oracle Database 12c 6 5
Balance Days  for day of arrival,exam(s)and practice 3 2
Total duration 9 7

Prerequisites:

  • Familiarity with data processing concepts and techniques
  • Basic knowledge of Linux Operating System
  • Using Oracle Enterprise Manager Cloud Control 12c

 

Our Location

Get In Touch

1st Floor of CHABAH House,

Chabah Bus Stop on the Odokor-Mallam HighWay

Opposite Total Filling Station

P. O. Box DS 2022

Accra, Ghana

Phone: +233 303 393 1256 / +233 302 325 815

Cell: +233 244036 522

Email:[email protected]