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, memoptimizedrowstore 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.
- Oracle Database 12c R2: New Features for Administrators Part 1 Ed 1
- Oracle Database 12c R2: New Features for Administrators Part 2 Ed 1
- Oracle Database 12c R2: High Availability New Features Ed 1
- Knowledge of Oracle Database 11g R2 and 12c