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


D83527 - Java SE 8 Fundamentals


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


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


P10380 - Oracle Database 18c: Administration Workshop
Enquire Now
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy