• Understand the major new features introduced in Oracle Database 23ai.
• Explore improvements in database availability and architecture.
• Use enhanced RMAN capabilities for database migration.
• Work with Wide Columns and Lock-Free Reservations.
• Understand improvements to Hybrid Columnar Compression.
• Apply new performance and data-storage enhancements.
• Explore enhanced database security capabilities.
• Understand new database sharding features.
• Evaluate 23ai features for enterprise database environments.

Module 1: Blockchain Tables

• Blockchain Tables overview
• Blockchain Table user chains
• Delegate signer
• Countersignature
• Blockchain Table management

Module 2: Availability

Simplified Database Migration Across Platforms Using RMAN Backups

• Overview
• Transport methods using Recovery Catalog
• Transport methods in NOCATALOG mode
• Transport over network links
• Generic prerequisites
• Platform-specific prerequisites
• Recovery Catalog methods for PDBs
• Transporting PDBs using existing backups
• Transporting PDBs using multiple incremental backups
• Recovery Catalog methods for tablespaces

Lock-Free Reservations

• Lock-Free Reservations benefits
• Functionality requirements
• Creating, modifying, and deleting reservations
• Lock-Free Journal Table
• Journal Table restrictions
• Lock-Free Reservations
• Related views

Unrestricted Parallel DML

• Parallel DML overview
• 23ai parallel DML improvements
• Benefits and use cases

Wide Columns

• Previous column limitations
• Wide Column enhancements
• Increased column limits
• Performance considerations

Improved Hybrid Columnar Compression

• HCC before 23ai
• HCC enhancements
• Database compatibility
• Performance considerations

Module 3: Performance

Fast Inserts Enhancements

• Fast Ingest overview
• Deferred Inserts
• Using Fast Ingest
• Enhancements
• Benefits
• Management considerations

Accelerate SecureFiles LOB Write Performance

• SecureFiles LOB performance
• Performance improvements
• Benefits

Data Storage Improvements

• SecureFiles
• Traditional SecureFiles shrinking
• Automatic SecureFiles shrinking
• Advantages of automatic shrinking
• Database-specific time considerations

Module 4: Security

• Oracle Database 23ai security enhancements
• Pluggable Database hybrid read-only mode
• Read-only users and sessions
• New Developer role
• Simplified schema privileges
• Column-level auditing
• Database Vault authorization controls
• Microsoft Azure Active Directory integration
• Security management considerations

Module 5: Database Sharding

• Oracle Database Sharding overview
• New sharding capabilities
• Native replication using RAFT
• Directory-based sharding
• Coordinated backup and restore
• Centralized backup and recovery
• Automatic bulk data movement following sharding-key updates
• Split and move of a partitionset with bulk data movement

3 Days

• Configure and explore the Oracle Database 23ai training environment.
• Work with Blockchain Tables.
• Configure and test Blockchain Table features.
• Perform database migration using RMAN backups.
• Explore RMAN-based cross-platform migration.
• Work with Lock-Free Reservations.
• Configure and use Wide Columns.
• Explore unrestricted parallel DML.
• Test improved Hybrid Columnar Compression capabilities.
• Work with Fast Ingest and deferred inserts.
• Explore SecureFiles LOB write-performance improvements.
• Configure and test new security capabilities.
• Explore database sharding enhancements.
• Work with native sharding replication.
• Explore coordinated backup and restore for sharded databases.

Course Completion Certificate by Network Binary

• Oracle Database Administrators
• Database Architects
• Database Engineers
• Infrastructure Engineers supporting Oracle databases
• Oracle professionals upgrading from earlier database versions
• Professionals responsible for Oracle database performance, security, and availability

• Experience administering Oracle Database.
• Familiarity with Oracle database architecture.
• Working knowledge of SQL and basic DBA tools.
• Experience with Oracle Database 19c or 21c is recommended.