Oracle Database 21c: New Features for Administrators

Oracle Database 21c: New Features for Administrators

This course overviews new and enhanced features within Oracle Database 21c. Areas discussed include big data and data warehousing, security, management, performance and high availability, Oracle Multitenant, Oracle Sharding, application development, Flashback, database upgrade and utilities, and globalization. Through the areas, you will cover topics such as analytic functions in SQL, machine learning, Oracle blockchain tables and Database Vault, automatic operations, Oracle Database In-Memory, PDB application synchronization and tenancy management, Oracle Sharded Database architecture, SQL Macros, and upgrade and migrations. 

Duration: 5 Days

Prerequisites

• Knowledge of Oracle 19c Database

Audience

• Data Analysts
• Database Administrators
• Database Developers
• Security Administrators

Learning Objectives

• Discuss analytic view enhancements to SQL and PL/SQL
• Discover new analytical and statistical aggregate functions
• Use Oracle blockchain table
• Discuss authentication and authorization
• Discuss auditing enhancements
• Use Oracle Advanced Security
• Use Oracle Database Vault
• Discuss manageability and diagnosability
• Use Oracle ASM Cluster File System
• Use Oracle Automatic Storage Manager
• Discuss Clusterware enhancements
• Discuss automatic operations
• Discuss Oracle Database In-Memory enhancements
• Discuss Flashback enhancements
• Use Oracle Multitenant
• Use Oracle Sharding
• Discuss SQL and PL/SQL enhancements
• Use Oracle Database utilities
• Discuss upgrades and migration
• Discuss globalization

Topics

• New Features for Big Data and Data Warehousing
• New Features for Security
• New Features for Management Solutions
• New Features for Performance
• New Features for Multitenancy
• New Features in Sharding
• New Features for Application Development
• New Features in Flashback
• New Features for Upgrade and Utilities
• New Features in Globalization