Seminar Details

Oracle Database 18c: New Features for Administrators (D101882GC10)

ETC
D101882GC10
Hersteller-ID: D101882
Prüfungs ID:
Dauer: 3 Tage
Preis: € 2.133.- exkl.MwST
Wissensgarantie: hier nicht automatisch anwendbar – bitte kontaktieren Sie Ihren Betreuer für Details
The Multitenant architecture lesson covers CDB fleet, PDB snapshots carousel, dynamic container map, lockdown profile inheritance, static & dynamic lockdown profiles, refreshable copy PDB switchover, parallel statement queuing at PDB level and PDB cloning with DBCA.
The Security lesson covers:
    schema only accounts, PDB keystore in isolated mode versus united mode, user-defined TDE master key, export and import database links, encryption of sensitive data in Database Replay files, Database Replay capture and replay with Database Vault,and direct Active Directory Services integration.

The RMAN lesson covers:
    reuse of preplugin backups before and after a non-CDB conversion as a PDB or of a PDB migration to another CDB, clone of active PDBs into another CDB using DUPLICATE command, duplication of on-premises CDBs to Cloud as encrypted.

The General Database lesson covers
    private temporary tables, Data Pump import with a new option of the DATA_OPTIONS parameter, online modification of partitioning and subpartitioning strategy, online merging partitions and subpartitions, batched DDL generation by using DBMS_METADATA_DIFF package, and benefit from Unicode 9.0 Support.

The Performance lesson
    covers configuration and usage of Automatic In-Memory, IMEs window capture, memoptimized rowstore feature and use of In-Memory Hash Index structures, description of the new SQL Tuning Set package, the concurrency of SQL execution of SQL Performance Analyzer tasks, the SQL Performance Analyzer Result Set Validation, SQL Exadata-aware profile.

The Data Warehousing lesson covers
    query inlined external tables, in-memory external tables, analytic view new query capabilities, polymorphic table functions and the new functions for approximate Top-N queries.

The Sharding lesson covers
    the user-defined sharding method, support for PDBs as shards, Oracle GoldenGate enhancements for Oracle Sharding support, query system objects across shards, how to set multi-shard query data consistency level, sharding support for JSON, LOBs, and spatial objects, improved multi-shard query enhancements, and where to find Oracle Sharding documentation in Oracle Database 18c.


Nach Abschluss dieses Seminars haben die Teilnehmer Wissen zu folgenden Themen:
  • 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.

Alle Details einblenden

Zielgruppe

Dieses Seminar richtet sich an:
  • Database Administrators
  • Database Developers

Vorkenntnisse

Schwerpunkte

  1. Leveraging Multitenant Enhancements
    1. Use refreshable copy PDB switchover
    2. Benefit from dynamic container map
    3. Manage PDB snapshots carousel
    4. Manage application PDBs fleet
    5. Understand lockdown profile inheritance and create and use static and dynamic lockdown profiles
  2. Managing Security
    1. Configure encryption of sensitive data in Database Replay files
    2. Export and import database links
    3. Create and use a schema only account
    4. Explain direct Active Directory Services integration
    5. Isolate PDB keystores
  3. Using RMAN Enhancements
    1. Reuse preplugin backups before and after a non-CDB conversion as a PDB or a PDB migration to another CDB
    2. Clone active PDB into another CDB using DUPLICATE and duplicate an on-premises CDB to Cloud as encrypted
  4. Applying General Database Enhancements
    1. Merging of partitions and subpartitions online
    2. Generate batched DDL by using DBMS_METADATA_DIFF package
    3. Manage private temporary tables
    4. Online modification of partitioning and subpartitioning strategy
    5. Use the new Data Pump Import option of the DATA_OPTIONS parameter
  5. Improving Performance
    1. Describe the new SQL Tuning Set package
    2. Use IMEs window capture
    3. Describe the concurrency of SQL execution of SQL Performance Analyzer tasks and Result Set Validation
    4. Configure Automatic In-Memory
  6. Handling Enhancements in Big Data and Data Warehousing
    1. Use analytic view new query capabilities
    2. Query inlined external tables and manage in-memory external tables
    3. Create and use polymorphic table functions
  7. Describing Sharding Enhancements
    1. Understand support for PDBs as shards
    2. Describe Oracle GoldenGate enhancements for Oracle Sharding support
    3. Describe improved multi-shard query enhancements
    4. Query system objects across shards
    5. Describe the user-defined sharding method
Alle Details ausblenden

1 Termin wählen

Was ist:
ILT

Ihr Klassenraumtraining - mehr Infos zu Instructor Led Trainings bei ETC erhalten Sie HIER

vILT

Mehr Infos zu vILT erhalten Sie hier

Live

Ihr virtuelles Training - mehr Infos zu ETC>Live erhalten Sie HIER

Hybrid VBT

Mehr Infos zu VBTs erhalten Sie HIER

Hybrid MOOC

Mehr Infos zu MOOCs erhalten Sie HIER

Coached Learning

Mehr Infos zu Coached Learning erhalten Sie HIER

Hotseat

Mehr Infos zum ETC Hotseat erhalten Sie HIER

Info

zusätzliche Infos zum Seminartermin

Alle Preise exkl. Mwst.

2 Paket wählen

Oracle Database 18c: New Features for Administrators

Coached Learning

  • Ihre Lernbegleitung mit einem zertifizierten Oracle Trainer
  • Seminarunterlagen, Teamwork, Labs als On Demand Training
  • Verpflegung vorort in einem der ETC Seminarzentren
  • Seminar-Services
€ 2.133.-
(€ 2.133.- p.P.)

Preis

  • Ihr ILT Seminar (Instructor Led Training)
  • Seminarunterlagen, Teamwork, Labs
  • Verpflegung vorort in einem der ETC Seminarzentren
  • Seminar-Services
€ 2.133.-
(€ 2.133.- p.P.)

Könnte sie auch interessieren

Ihre Fragen zum Seminar

CHAT mit Experten ODER Rückruf anfordern

Kein passender Termin dabei? Mehr als 5 Personen? Firmentermin gewünscht?

Rufen sie uns an +43/1/533 17 77 - 99

Bewertungen

Bisher keine Bewertungen