Get in Touch

Course Outline

Introduction to Oracle 23ai

  • Summary of Oracle 23ai features and strategic vision
  • Significant distinctions compared to 19c and 21c
  • AI integration strategies and support for modern workloads

AI Vector Search and Embeddings

  • AI Vector Search: understanding architecture and practical applications
  • Techniques for storing and indexing vectors within Oracle 23ai
  • Real-world examples for search optimization and AI inference

Automation and Observability

  • New observability dashboards and telemetry capabilities
  • Enhanced automation to streamline DBA tasks
  • Proactive alerting mechanisms and resource monitoring improvements

Performance and SQL Improvements

  • SQL advancements in Oracle 23ai
  • Upgrades in indexing, join operations, and query optimization
  • Real-time statistical analysis and enhanced diagnostic tools

Security and Compliance

  • New auditing protocols and encryption capabilities
  • Improvements in policy management
  • Seamless integration with Oracle Cloud Infrastructure (OCI) security controls

Upgrade and Migration Strategy

  • Evaluating system readiness and compatibility
  • Tools and best practices for seamless upgrades
  • Considerations for hybrid cloud environments

Backup, Recovery, and Cloud Solutions

  • Changes to backup mechanisms in Oracle 23ai
  • Enhancements to Flashback and recovery processes
  • Multicloud strategies and autonomous database features

Recap and Future Steps

Requirements

  • Solid comprehension of Oracle database architecture and administrative responsibilities
  • Proven experience operating Oracle 19c or 21c environments
  • Proficiency in SQL, PL/SQL, and standard DBA toolsets

Target Audience

  • Oracle database administrators
  • Database architects
  • Infrastructure engineers supporting Oracle-based systems
 14 Hours

Testimonials (1)

Upcoming Courses

Related Categories