D97103 - Oracle Database 12c R2: New Features for Administrators Part 2

Throughout the lessons of the Oracle Database 12c R2: New Features for Administrators Part 2 course constituted by five modules; the Securing Data module, the Making Data Available module, the Partitioning Data module, the Managing Information Lifecycle module and the Monitoring DB Operations and Managing Performance module, students receive a good knowledge of the Oracle Database 12c Release 2 new and enhanced features in different areas of database administration like Unified Auditing, Transparent Data Encryption (TDE) and other areas of security, Recovery Manager, online operations, Oracle Data Pump, SQL*Loader, new partitioning methods, Automatic Data Optimization, In-Memory Column Store, Full Database In-Memory Caching, and Automatic Big Table Caching.

Learn To:

Gain an understanding of the new and enhanced features of Oracle Database 12c Release 2 ( amongst different areas such as security, availability, partitioning, performance, and Information Lifecycle Management (ILM).

Duration: 4.0 days

Enquire Now

Start learning today!

Click Hereto customize your Training


Upon completing this course, the learner will be able to meet these overall objectives:

  • Manage security by using Unified Auditing
  • Manage security by using privileges and profiles
  • Manage security by using Privilege Analysis
  • Manage security by using Data Redaction
  • Manage security by using Transparent Data Encryption
  • Manage security by using Transparent Sensitive Data Encryption
  • Describe the new RMAN enhancements
  • Manage data availability by using new features of Oracle Data Pump, SQL*Loader and external tables
  • Manage data availability by performing online operations
  • Manage data partitioning
  • Manage Information Lifecycle by using ADO
  • Manage Information Lifecycle by using In-Database Archiving and Temporal features
  • Describe database operations
  • Configure and use In-Memory Column Store
  • Use In-Memory Caching
  • Use Real Application Testing enhancements


  • Module 1: Introduction
  • Module 2: Auditing Using Unified Audit
  • Module 3: Controlling Data Access Using Privileges and Profiles
  • Module 4: Controlling Data Access Using Privilege Analysis
  • Module 5: Redacting Data
  • Module 6: Encrypting Data
  • Module 7: Controlling Data Access Using Transparent Sensitive Data Protection
  • Module 8: Making Data Available by Using RMAN Features
  • Module 9: Making Data Available by Using Oracle Data Pump, SQL*Loader and External Tables
  • Module 10: Making Data Available by Performing Online Operations
  • Module 11: Partitioning Data
  • Module 12: Managing Information Lifecycle Using ADO
  • Module 13: Managing Information Lifecycle Using In-Database Archiving and Temporal
  • Module 14: Monitoring DB Operations and Performance
  • Module 15: Configuring In-Memory Column Store
  • Module 16: Using In-Memory Column Store
  • Module 17: Improving Performance Using In-Memory Caching
  • Module 18: Improving SQL Performance
  • Module 19: Using Real Application Testing Enhancements
  • Module 20: Improving Performance Using Other Features


  • End Users
  • Database Administrators
  • System Administrator


  • Knowledge of Oracle Database 11g R2
  • Knowledge of Oracle Multitenant Container Database architecture

Suggested Prerequisites:

  • Oracle Database 12c R2: New Features for Administrators Part 1 Ed 1 NEW
  • Oracle Enterprise Manager Cloud Control 13c: Install & Upgrade Ed 2



This course is not associated with any Certification.

Course Benefits

  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

Oracle Popular Courses


This training is the first step in mastering MySQL, the world’s most popular open source database.


P10380 - Oracle Database 18c: Administration Workshop


Learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code.


D83527 - Java SE 8 Fundamentals
Enquire Now
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy