• info@koenig-solutions.com
  • +91 81307 98752
  • +1 877 226 2244

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

  • Overview

    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. After completing thsi course, students will be able to: use the enhancements in Recovery Manager, manage privilege analysis, and understand and utilize new privileges available, such as SYSDG, SYSBACKUP, and SYSKM.

    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 Content / Exam(s)

    Schedule for Oracle Database 12c : New Features for 11g/ 10g DBAs
    Course Exam # Exam Regular Track
    (days)
    Oracle Database 12c: New Features for Administrators NEW 1Z0-060 Upgrade to Oracle Database 12c 5
    Total 5
    Prerequisites
    • Familiarity with data processing concepts and techniques
    • Basic knowledge of Linux Operating System
    • Good Knowledge of 11G Database
    Recommended Courses and Certification:
  • Students Reviews
    Loveness  Dumwa Koenig IT Training Student

    I attended Oracle OCA/OCP training at Koenig Dubai during the period 02 to 21 September with one of their excellent trainers. The centre has a comfy environment and the staff is very hospitable....

    Read MoreLoveness DumwaZimbabwe
    Mauro Das  Neves Koenig IT Training Student

    I just have to thank Koenig Dubai and its employees who have given the best conditions at all levels for me to prepare for the OCP exam. Personally I had never heard of them but now I will consider...

    Read MoreMauro Das NevesAngola
    Ibrahim Saad Abdulhamid  Almahanawi Koenig IT Training Student

    Hello every one, I would like to thank everyone who supported me, I really spent very unforgettable moments in Koenig with a very marvelous team, specially my great teacher, she is really very smart,...

    Read MoreIbrahim Saad Abdulhamid AlmahanawiLiberia
    Peter  Olumolu Koenig IT Training Student

    I came to know about Koenig from a colleague who had earlier been here for a number of courses and after careful evaluation and comparisons I choose to do my training here for a number of...

    Read MorePeter OlumoluNigeria
    Paulo  Cunha Koenig IT Training Student

    I am Paulo Faustino da Cunha from Angola. I took a customized course of SQL Server 2008 DBA, OCP, PMP® and MS Project 2010.I was at Koenig Delhi from 01/02/2013 to 09/03/2013 and it was my 2nd time...

    Read MorePaulo CunhaAngola
    View All Testimonials
  • Schedule & Prices
    1
    2
    3


    4
     

    5
    Price includes Official Curriculum and Exam(s).
    For any Query or Custom Plan info@koenig-solutions.com +1 877 226 2244
  • Enquire Now
    * Required Fields