Konsultasiya almaq
Training Center MUKКурсыOracleDatabaseOracle Database 18c: New Features for Administrators Ed 1

Oracle Database 18c: New Features for Administrators Ed 1

Kursun kodu
Orcl_Db18NF
Müddət
3 Gün, 24 Saat
Kursun təsviri
Məqsədlər
Tələblər
Kursun proqramı
Kursun təsviri

Course overview

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.

Məqsədlər

Course objectives

  • 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
Tələblər

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

Audience

  • Database Administrators
  • Database Developers
Kursun proqramı

Course Topics

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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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
Ən yaxın kurs üçün qeydiyyat
Oracle Database 18c: New Features for Administrators Ed 1
Kursun kodu:
Orcl_Db18NF
Müddət:
3 Gün, 24 Saat
Qeydiyyatan keç
Konsultasiya almaq
Свяжитесь со мной
Konsultasiya almaq
Отправить заявку
Vebinara qeydiyyat
Отправить заявку
Müraciətiniz qəbul olundu!
Yaxın zamanda sizinlə əlaqə saxlanılacaq.