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.
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)
good explanation on each points and provide assignment for practices.
Piseth Ben - ACLEDA Bank Plc.
Course - Oracle Database 19c: SQL Tuning Workshop
Greg was very patient and helpful