Oracle Database 18c : New Features for Administrators Ed 1

QUESTIONS ?

Oracle Database 18c : New Features for Administrators Ed 1

Prix: 2 133 €Durée: 3 joursCode de Réference: D101882 Catalogue
Oracle Database 18c
Print Friendly, PDF & Email



Cette formation fournit une vue d'ensemble des nouvelles fonctionnalités et améliorations d'Oracle Database 18c relatives à l'architecture Multitenant, à la sécurité, à RMAN, aux domaines de base de données généraux, aux performances, à l'entreposage de données et à Sharding.

Objectifs de la formation :

  • Use new features of the Multitenant architecture
  • Understand and benefit from new features of the Database Security
  • Benefit from new features of RMAN
  • Use new features of General Database
  • Configure and use new features in Performance
  • Manipulate new features of the Data Warehousing
  • Understand enhancements in Sharding

Public :

Cette formation Oracle Database 18c : New Features for Administrators s’adresse aux administrateurs de base de données et développeurs de base de données.

Pré-requis :

Knowledge of Oracle Database 11g R2 and 12c. Il est conseillé d'avoir suivi les cours suivants ou disposer de connaissances et compétences équivalentes : Oracle Database 12c R2: New Features for Administrators Part 1 Ed 1 Oracle Database 12c R2: New Features for Administrators Part 2 Ed 1 Oracle Database 12c R2: High Availability New Features

Programme de la formation :

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

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

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

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

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

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

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
Print Friendly, PDF & Email
retour vers le catalogue des formations