Get in Touch
 Duration 14 hours

Course Outline

Introduction to Oracle 23ai

  • Summary of Oracle 23ai features and strategic vision
  • Distinct advantages compared to 19c and 21c
  • AI integration for modern workload requirements

AI Vector Search and Data Embeddings

  • AI Vector Search: architectural overview and application scenarios
  • Techniques for storing and indexing vectors in Oracle 23ai
  • Real-world examples of search capabilities and AI inference

Automation and System Observability

  • New observability dashboards and telemetry insights
  • Advanced automation for routine DBA operations
  • Proactive alert mechanisms and resource monitoring capabilities

Performance Optimisations and SQL Advancements

  • SQL improvements specific to Oracle 23ai
  • Enhancements in indexing, join operations, and query optimisation
  • Real-time statistics and refined diagnostic tools

Security Protocols and Compliance

  • Updated auditing and encryption capabilities
  • Advanced policy management features
  • Alignment with Oracle Cloud Infrastructure (OCI) security controls

Upgrade and Migration Strategy

  • Evaluating system readiness and compatibility
  • Recommended tools and best practices for the upgrade process
  • Considerations for hybrid cloud architectures

Backup, Recovery, and Cloud Solutions

  • Changes to backup mechanisms in Oracle 23ai
  • Enhanced Flashback and recovery options
  • Multicloud capabilities and autonomous database features

Conclusion and Future Directions

Requirements

  • A solid grasp of Oracle database architecture and administrative principles
  • Professional experience with Oracle 19c or 21c
  • Proficiency in SQL, PL/SQL, and standard DBA utilities

Target Audience

  • Oracle database administrators
  • Database architects
  • Infrastructure engineers managing Oracle environments

Custom Corporate Training

Training solutions designed exclusively for businesses.

  • Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
  • Flexible Schedule: Dates and times adapted to your team's agenda.
  • Format: Online (live), In-company (at your offices), or Hybrid.
Investment

Price per private group, online live training, starting from 2600 € + VAT*

Contact us for an exact quote and to hear our latest promotions

Testimonials (2)

Provisional Upcoming Courses (Contact Us For More Information)

Related Categories