This five-day instructor-led course provides database administrators with the knowledge and practical skills required to administer Oracle Database 23ai in enterprise environments. Aligned with the latest Oracle University curriculum, the [...]
  • OCDBAW23AI-QA
  • Price on request

This five-day instructor-led course provides database administrators with the knowledge and practical skills required to administer Oracle Database 23ai in enterprise environments. Aligned with the latest Oracle University curriculum, the course equips learners with the expertise needed to create, configure, secure, monitor and manage Oracle Database instances within multitenant architectures.Through a combination of instructor-led learning and extensive hands-on labs, participants gain practical experience managing Oracle database environments while exploring the latest Oracle Database 23ai capabilities, including AI-powered database features, automation, performance optimisation, and high availability. Successful completion of the course prepares learners to confidently administer Oracle Database 23ai within modern enterprise environments.The concepts, architecture and administration techniques covered in this course remain relevant to Oracle AI Database 26ai.

  • Understand Oracle Database architecture, memory structures and process architecture.
  • Create and manage Oracle databases using DBCA and SQL-based methods.
  • Administer Container Databases (CDBs) and Pluggable Databases (PDBs).
  • Configure Oracle Net Services, listeners and database connectivity.
  • Manage database storage, tablespaces, undo data and space utilisation.
  • Administer users, roles, privileges and resource limits.
  • Implement auditing, compliance monitoring and database security controls.
  • Load and transport data using Oracle Data Pump, SQL*Loader and external tables.
  • Configure automated maintenance tasks and monitor database performance.
  • Analyse SQL execution and apply Oracle performance tuning techniques.

I am interested in selected QA course