Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Overview of Oracle 23ai
- Oracle 23ai feature summary and vision
- Key differences from 19c and 21c
- AI integration and modern workloads
AI Vector Search and Embeddings
- AI Vector Search: architecture and use cases
- Storing and indexing vectors in Oracle 23ai
- Practical examples for search and AI inference
Automation and Observability
- New observability dashboards and telemetry
- Enhanced automation for DBA tasks
- Proactive alerting and resource monitoring
Performance and SQL Enhancements
- SQL enhancements in Oracle 23ai
- Improvements in indexing, joins, and query optimization
- Real-time statistics and improved diagnostics
Security and Compliance
- New auditing and encryption features
- Policy management enhancements
- Integration with Oracle Cloud Infrastructure (OCI) controls
Upgrade and Migration Planning
- Assessing readiness and compatibility
- Tools and best practices for upgrading
- Hybrid cloud considerations
Backup, Recovery, and Cloud Options
- Backup changes in Oracle 23ai
- Flashback and recovery enhancements
- Multicloud and autonomous database features
Summary and Next Steps
Requirements
- An understanding of Oracle database architecture and administration
- Experience working with Oracle 19c or 21c
- Familiarity with SQL, PL/SQL, and basic DBA tools
Audience
- Oracle database administrators
- Database architects
- Infrastructure engineers supporting Oracle environments
14 Hours
Testimonials (3)
I learned complex functions and how to apply them
Ana Alexandrescu - DB Global Technology
Course - Oracle SQL Advanced
the trainer was very helpful , the pace of the training was really good and the exercises weren't too hard, also not too easy. whenever I got stuck he helped me out very well and made sure I understood everything.
Jade Stappaerts - KULeuven
Course - Oracle SQL Language
the exercises
