OR2001

Ladda ner som PDF

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.

Audience

  • Database Administrator
  • Developer

Prior knowledge

Required Prerequisite

- Knowledge of Oracle Database 11g R2 and 12c

Suggested Prerequisite

- 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 Ed 1

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.

Course Topics

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... Läs mer

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.

Course Topics

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

Utbildningen levereras i samarbete med

Kursfakta

Kurs-ID: OR2001
Längd: 3 dagar
Pris exkl moms: 19 089 kr
Inregistrering: 08.30
Kursstart: 09.00
Kursslut (ca): 17.00

Frågor om kursen?

Har du frågor om kursens innehåll, leveransdatum/ort eller behöver en företagsanpassad variant? Fyll i formuläret nedan!


Kan betalas med:
TRAINING CARD

Avtalsrabatter och kampanjer kan ej nyttjas på denna kurs.


Ort och datum

Stockholm
16 mar-18 mar
Boka nu!

Tipsa