Course Overview
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.
Who should attend
This course is intended for experienced
- Oracle Database Administrators
- System Administrators
- Developers
Prerequisites
Course Objectives
Upon completion of this course, the student should be able to:
- 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
Course Content
- 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