• Presencial

Oracle Database 18c: New Features for Administrators

This course provides an overview of the Oracle Database 18c new features and enhancements related to Multitenant architecture, security, RMAN, general database areas, performance, data warehousing and Sharding.

Oracle Database 18c, Is the latest generation of the Oracle database, and may be deployed on – premises and/or in Oracle Cloud running on general purpose hardware or engineered systems specifically designed for database workloads such as Oracle Exadata and Oracle Database Appliance.

It provides businesses of all sizes with access to the world’s fastest, most scalable and reliable database technology for secure and cost – effective deployment of transactional and analytical workloads in the Cloud, On-premises and Hybrid Cloud configurations. Oracle Database 18c adds new functionality and enhancements to features previously introduced in Oracle Database 12c, including:

  • Multitenant Architecture for massive cost savings and agility.
  • In-Memory Column Store for massive performance gains for real-time analytics.
  • Native Database Sharding for high availability of massive web applications.
  • Many more critical capabilities for enhanced database performance, availability, security, analytics and application development.


  • Database Administrators
  • Database Developers


Suggested Prerequisite

  • Knowledge of Oracle Database 11g R2 and 12c

Required Prerequisite

  • Oracle Database 12c R2: New Features for Administrators Part 1 Ed 1
  • Oracle Database 12c R2: New Features for Administrators Part 2
  • Oracle Database 12c R2: High Availability New Features


Learn to:

  • Use new features like Application PDB Fleet and PDB snapshots carousel of the Multitenant architecture.
  • Understand new features like PDB keystores and encryption of sensitive data in Database Replay files of the Security.
  • Benefit from new features like reuse of preplugin backups and duplication of active PDBs into an existing CDB of RMAN.
  • Use new features like private temporary tables and online modification of partitioning and subpartitioning strategy of General Database.
  • Configure and use new features like Automatic In-Memory Management in Performance.
  • Manipulate new features like inline external tables and polymorphic table functions of the Data Warehousing.
  • Understand enhancements like user-defined sharding method and support for PDBs as shards in Sharding.


  • Leveraging Multitenant Enhancements
  • Managing Security
  • Using RMAN Enhancements
  • Applying General Database Enhancements
  • Improving Performance
  • Handling Enhancements in Big Data and Data Warehousing
  • Describing Sharding Enhancements

Leveraging Multitenant Enhancements

  • Use refreshable copy PDB switchover
  • Benefit from dynamic container map
  • Manage PDB snapshots carousel
  • Manage application PDBs fleet
  • Understand lockdown profile inheritance and create and use static and dynamic lockdown profiles

Managing Security

  • Configure encryption of sensitive data in Database Replay files
  • Export and import database links
  • Create and use a schema only account
  • Explain direct Active Directory Services integration
  • Isolate PDB keystores

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

Applying General Database Enhancements

  • Merging of partitions and subpartitions online
  • Generate batched DDL by using DBMS_METADATA_DIFF package
  • Manage private temporary tables
  • Online modification of partitioning and subpartitioning strategy
  • Use the new Data Pump Import option of the DATA_OPTIONS parameter

Improving Performance

  • Describe the new SQL Tuning Set package
  • Use IMEs window capture
  • Describe the concurrency of SQL execution of SQL Performance Analyzer tasks and Result Set Validation
  • Configure Automatic In-Memory

Handling Enhancements in Big Data and Data Warehousing

  • Use analytic view new query capabilities
  • Query inlined external tables and manage in-memory external tables
  • Create and use polymorphic table functions

Describing Sharding Enhancements

  • Understand support for PDBs as shards
  • Describe Oracle GoldenGate enhancements for Oracle Sharding support
  • Describe improved multi-shard query enhancements
  • Query system objects across shards
  • Describe the user-defined sharding method

Outras Edições

Oracle Database 18c: New Features for Administrators



Como chegou até nós

Os seus dados pessoais são recolhidos em conformidade com o Regulamento Geral de Proteção de Dados (RGPD).
Consente que os seus dados sejam utilizados, nos termos da nossa Politica de Privacidade, para o contacto/envio de:

Ações de informação, de marketing de produtos e serviços, como campanhas e eventos?

Para mais informações, consulte a Política de Privacidade do Grupo Rumos.
pode retirar o seu consentimento a qualquer momento através do botão Cancelar subscrição ou Unsubscribe que estão presentes em cada comunicação enviada, bem como exercer os direitos descritos na politica de privacidade

Para a subscrição da newsletter deverá desativar o bloqueio de pop-ups do seu browser.