МенюКонтакты
Обучение
Поиск

+7 (495) 913-75-75 доб.221

+7 (495) 668-08-42

+7 (812) 441-33-15

+7 (901) 374-07-97

Почта

edu@fors.ru

Oracle Database 18c: New Features for Administrators

Посмотреть расписание этого курса
  • Код курса: 18cNFA
  • Длительность: 3 д.
  • Цена: 67 050 р.
Записаться

Описание курса

Аннотация:

Курс содержит обзор новых возможностей и усовершенствований Oracle Database 18c, связанных с архитектурой Multitenant, безопасностью, RMAN, областями общей базы данных, производительностью, хранилищем данных и Sharding.

Предварительная подготовка:

  • Знание Oracle Database 11g R2 и 12c

Рекомендуемая дополнительная подготовка:

  • 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

Слушатели изучат:

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

Benefits to You

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.

Hands-on Practices and Demonstrations

Hands-on practices and available demonstrations help you learn how to use these new or enhanced features of Oracle Database 18c.

Аудитория:

  • Администраторы баз данных
  • Разработчики баз данных

Цели курса:

  • 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

Программа курса:

  • 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
Записаться на курс: Oracle Database 18c: New Features for Administrators

Начало курса: 01.08.2018



Поделиться
Отправьте другу или начальнику ссылку на почту
Заявка на обучение

Заявка на обучение

Записаться на курс:

Выберите дату начала курса: