The course covers various new features in Oracle Database 21c, focusing on enhancements across different areas:

1. Big Data and Data Warehousing: The course begins by revisiting the fundamentals of star schemas, including keys, fact tables, and measures. It then delves into analytic views, their components, and transparency views, alongside advancements in query transformation and remote source support. The section also explores new bitwise aggregate functions and enhancements to existing analytic functions, offering practical applications through examples.

2. Security Features: This section introduces blockchain tables, explaining their features, benefits, and operational mechanisms. It also covers password policy enhancements, blockchain table management, and unified auditing improvements. The segment on Transparent Data Encryption (TDE) provides insights into keystore management and Oracle Key Vault integration, alongside new functionalities in Oracle Database Vault.

3. Performance Enhancements: Here, the focus is on automatic indexing, materialized views, and SQL tuning. The section emphasizes optimizing performance through automatic index enhancements, object activity tracking, and SecureFiles defragmentation. It also covers advancements in Database In-Memory, highlighting automatic query optimizations and in-memory external table support.

4. Multitenancy Improvements: This part addresses regular and application containers in multitenant environments. It explains application synchronization, data dictionary views, resource management, and time zone support in pluggable databases (PDBs). The segment includes details on using Database Resident Connection Pool (DRCP) and DbNest for improved PDB management.

5. Sharding Features: This section provides an overview of sharding in Oracle Database, explaining the architecture and new enhancements in Oracle Sharding 21c.

6. Application Development: It covers improvements in SQL set operators, SQL macros, PL/SQL warnings, and user-defined object types. There’s also a focus on JSON data type enhancements and JSON functions in Oracle 21c.

7. Flashback and Utilities: This part discusses new features in Flashback technology, database upgrade utilities, and Oracle Data Pump enhancements. It includes practical aspects like index compression on import and auto-upgrade processing modes.

8. Globalization Features: Lastly, the training covers new globalization features such as Unicode 12.1 support, new linguistic sorts, and time zone file upgrades.

Each course module not only details the new features but also provides practical examples and exercises for better understanding and application.