logo
Home

Oracle Database 19c New Features for Administrators

  • CMDBID 113402
  • Course Code 
  • Duration 2 Days
Scroll

Oracle Course

course overview

Click to View dates & book now

Overview

Official Oracle Curriculum

The course provides the Oracle Database 19c new features and enhancements related to database overall, security, availability, performance, data warehousing, and diagnosability. In the lessons, you learn the new and enhanced features of Oracle Database 19c amongst different areas such as database overall, security, availability, performance, big data and warehousing, and diagnosability.

  • Topics of the database overall module cover new features such as DBCA, OUI, and Data Pump enhancements.
  • Topics of the security module cover enhancements such as key management of encrypted Oracle-managed tablespaces in TDE, and Database Vault operations control.
  • Topics of the availability module cover enhancements in RMAN such as recovery catalog connection when the user is connected to the target database as PDB.
  • Topics of the performance module cover enhancements such as PDB-level ADDM analysis, Memoptimized Rowstore - Fast Ingest deferred writes and enabling SQL developers to use Real-Time SQL Monitor.
  • Topics of the data warehousing module cover enhancements such as hybrid partitioned tables and automated indexing.
  • Topics of the diagnosability module cover new features such as an end-to-end automated service for fault prediction, detection, and fixation to avoid or minimize the human intervention, and new service request data collections determining the data to collect for crucial errors.
  • Topics of the sharding module cover enhancements such as the support for multiple PDB-shards in the same CDB and of multiple table family for system-managed sharding.

Target

Audience

This course is intended for experienced

  • Oracle Database Administrators
  • System Administrators
  • Developers

Skills Gained

  • Understand the concept, benefits, configuration, and usage of the new features and enhancements in database overall area
  • Understand the concept, benefits, configuration, and usage of the new features and enhancements in the security area
  • Understand the concept, benefits, configuration, and usage of the new features and enhancements in the availability area
  • Understand the concept, benefits, configuration, and usage of the new features and enhancements in the performance area
  • Understand the concept, benefits, configuration, and usage of the new features and enhancements in big data and data warehousing area
  • Understand the concept, benefits, configuration, and usage of the new features and enhancements in diagnosability area
  • Understand the concept, benefits, configuration, and usage of the new features and enhancements in sharding area

Prerequisites

  • Oracle Database 12c R2: New Features for Administrators Part 1,
  • Oracle Database 12c R2: New Features for Administrators Part 2 OR
  • Oracle Database 18c: New Features for Administrators

Outline

  • Using General Database Overall Enhancements
  • Using Security Enhancements
  • Using Availability Enhancements
  • Using Performance Enhancements
  • Using Big Data and Data Warehousing Enhancements
  • Using Diagnosability Enhancements
  • Sharding Enhancements

Talk to an expert

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. Its a cost effective option. One on one training can be delivered too, at reasonable rates.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

All $ prices are in USD unless it’s a NZ or AU date

SPVC = Self Paced Virtual Class

LVC = Live Virtual Class

Please Note: All courses are availaible as Live Virtual Classes

Trusted by over 1/2 million students in 15 countries

Our clients have included prestigious national organisations such as Oxford University Press, multi-national private corporations such as JP Morgan and HSBC, as well as public sector institutions such as the Department of Defence and the Department of Health.