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
Testimonials (5)
overall a good training that responds to my needs. I received also information about Oracle VM VirtualBox allowing me to continue the practice on my own.
Liviu
Course - Oracle SQL LP - Fundamentals
I learned complex functions and how to apply them
Ana Alexandrescu - DB Global Technology
Course - Oracle SQL Advanced
Great comunication, Łukasz explained everything in easy and understandable way
Tomasz Wojciechowski - GP Strategies Poland sp. z o.o.
Course - ORACLE SQL Fundamentals
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