We’re excited to introduce the Oracle Database 23ai Administration Professional Certification and Learning Path—now available on Oracle MyLearn! This new certification empowers Oracle DBAs to master the latest innovations in Oracle Database 23ai and confidently administer, secure, and optimize data systems in cloud, hybrid, and on-premises environments.
 

Why Oracle Database 23ai?

Oracle Database 23ai is packed with innovations that bring AI-driven automation, enhanced multitenant architecture, faster upgrades, secure backup/recovery, and breakthrough performance management tools.

Whether you’re deploying Oracle Grid Infrastructure, managing multitenant environments, or fine-tuning mission-critical databases, Oracle Database 23ai offers the advanced capabilities you need to support modern data workloads.
 

Before You Begin

If you’re new to Oracle Database administration or looking to build a strong foundation, we recommend starting with the Oracle Database 23ai: Administration Associate Certification. This credential covers essential database administration skills, including architecture, user management, storage, security, and basic backup and recovery. It provides the ideal preparation before pursuing the professional-level learning path.


Learning Path Overview

The Oracle Database 23ai Administration Professional Learning Path includes five comprehensive courses, featuring 75+ hours of guided instruction, interactive labs, and real-world scenarios that build practical expertise across core administrative domains.

Oracle Database 23ai: Deploy, Patch, and Upgrade: Learn how to install, configure, patch, and upgrade Oracle Database 23ai environments using best practices to ensure reliability, security, and minimal downtime. You will learn to:

  • Apply advanced deployment, patching, and upgrade techniques
  • Diagnose and resolve common upgrade-related issues
  • Streamline maintenance operations for better efficiency

Oracle Database 23ai: Multitenant Architecture: Explore how Oracle 23ai leverages container and pluggable databases to improve resource utilization and management. Gain practical skills in PDB migration, backup, recovery, and performance tuning. You will learn to:

  • Consolidate and manage PDBs and CDBs effectively
  • Perform backup/recovery at both PDB and CDB levels
  • Tune and manage performance across pluggable databases
  • Migrate data using Oracle Data Pump

Oracle Database 23ai: Backup and Recovery: Develop deep skills in backup and disaster recovery using RMAN and Flashback technologies to protect data and ensure availability. You will learn to:

  • Create backups and use recovery catalogs
  • Perform recovery and implement flashback technologies
  • Duplicate databases and transport PDBs or tablespaces
  • Create PDB snapshots for point-in-time recovery

Oracle Database 23ai: Performance Management and Tuning: Gain expertise in diagnosing and resolving performance bottlenecks with Oracle’s tuning tools and best practices. You will learn to:

  • Use diagnostic tools to resolve bottlenecks
  • Tune SQL queries and manage memory/storage
  • Apply performance management best practices

Oracle Database 23ai: New Features for Administrators: Stay current with the latest innovations in Oracle Database 23ai and learn how to apply them to improve performance, manageability, and security. You will learn to:

  • Use AI Vector Search to enhance data discovery and integration with LLM applications
  • Implement OLTP enhancements including Lock-Free Reservations, Wide Tables, and Parallel DML
  • Leverage availability features such as True Cache, Flashback log placement, and cross-platform migration with RMAN
  • Apply performance and manageability improvements like Fast ingest (Memoptimized Write), SecureFiles shrink, and Automatic SQL Plan Management
  • Strengthen database protection using enhanced security features and Blockchain Tables


Certification Exam Details

After completing the learning path, you’ll have the opportunity to validate your skills with a professional-level certification exam. This 120-minute test includes 65 questions and requires a passing score of 60%. The exam covers the following objectives:

Exam Objectives

% of Exam

Deploy, Patch, and Upgrade

15%

Managing Multitenant Architecture

20%

Performing Backup and Recovery

20%

Managing and Tuning Performance

25%

Oracle Database 23ai New Features for Administrators

20%


Note on exam changes: 
We are not planning to release a 23ai version of the Performance Management and Tuning exam. That content is now fully integrated into this certification, providing a consolidated and streamlined path for DBAs.
 

Get Started Today!

Whether you’re managing on-premises deployments or hybrid cloud environments, the Oracle Database 23ai Administration Professional Certification equips you with the practical skills and strategic knowledge needed to thrive in today’s data-driven world.

OCP


Good luck—and keep learning.