Oracle Database 18c: New Features for Administrators Ed 1 Course Overview

The Oracle Database 18c: New Features for Administrators Ed 1 training course takes you through the Oracle Database 18c new features and enhancements. During this training you will learn the features related to Multitenant architecture, security, RMAN, general database areas, performance, data warehousing and Sharding.

Who Should Do Oracle Database 18c: New Features for Administrators Ed 1 training?

  • Database Administrators
  • Database Developers
  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Flexible Dates
4-Hour Sessions
  • View video
  • The course will be free if we are not able to start within 7 days of booking.
  • Only applicable for courses on which this logo appears.

Your will learn:

Module 1: Leveraging Multitenant Enhancements
  • Manage application PDBs fleet
  • Manage PDB snapshots carousel
  • Benefit from dynamic container map
  • Understand lockdown profile inheritance and create and use static and dynamic lockdown profiles
  • Use refreshable copy PDB switchover
  • Create and use a schema only account
  • Isolate PDB keystores
  • Export and import database links
  • Configure encryption of sensitive data in Database Replay files
  • Explain direct Active Directory Services integration
  • Reuse preplugin backups before and after a non-CDB conversion as a PDB or a PDB migration to another CDB
  • Clone active PDB into another CDB using DUPLICATE and duplicate an on-premises CDB to Cloud as encrypted
  • Manage private temporary tables
  • Use the new Data Pump Import option of the DATA_OPTIONS parameter
  • Online modification of partitioning and subpartitioning strategy
  • Merging of partitions and subpartitions online
  • Generate batched DDL by using DBMS_METADATA_DIFF package
  • Configure Automatic In-Memory
  • Use IMEs window capture
  • Describe the new SQL Tuning Set package
  • Describe the concurrency of SQL execution of SQL Performance Analyzer tasks and Result Set Validation
  • Query inlined external tables and manage in-memory external tables
  • Use analytic view new query capabilities
  • Create and use polymorphic table functions
  • Describe the user-defined sharding method
  • Understand support for PDBs as shards
  • Describe Oracle GoldenGate enhancements for Oracle Sharding support
  • Query system objects across shards
  • Describe improved multi-shard query enhancements
Live Online Training (Duration : 24 Hours)
Group Training 3400 Per Participant Incl. Official Courseware
30 May - 01 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
06 - 08 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
04 - 06 Jul 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training 6800 3950 + If you accept merging of other students. Incl. Official Courseware
8 Hours
Week Days

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Ultra-Fast Track

If you can't spare 24 hours. We can offer you an Ultra-Fast Track for 12 hours for only USD 3,160

Course Prerequisites
  • Knowledge of Oracle Database 11g R2 and 12c

Upon Completion of this course you will know following:

  • Using Multitenant architecture's new features
  • Know the benefits of new features of the Database Security
  • New features of RMAN & General Database
  • New features in Performance & Data Warehousing
  • Understanng the improvements in Sharding

Request More Information

Add Name and Email Address of participant (If different from you)


Yes, fee excludes local taxes.
The Fee includes:
  • Official courseware
  • Testing Via Qubits
Yes, Koenig Solutions is a Oracle Learning Partner