Oracle Database 18c: New Features for Administrators Ed 1

Oracle Database 18c: New Features for Administrators Ed 1 Certification Training 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
Test your current knowledge Qubits42

Oracle Database 18c: New Features for Administrators Ed 1 (24 Hours) Download Course Contents

Live Virtual Classroom
Group Training 2400
08 - 10 Nov GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 - 08 Dec 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 2800
4 Hours
8 Hours
Week Days

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here

Course Modules

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
Module 2: Managing Security
  • 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
Module 3: Using RMAN Enhancements
  • 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
Module 4: Applying General Database Enhancements
  • 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
Module 5: Improving Performance
  • 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
Module 6: Handling Enhancements in Big Data and Data Warehousing
  • Query inlined external tables and manage in-memory external tables
  • Use analytic view new query capabilities
  • Create and use polymorphic table functions
Module 7: Describing Sharding Enhancements
  • 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
Download Course Contents

Request More Information

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


Yes, fee excludes local taxes.