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
1. Introduction and What's New in Oracle Database 23ai
- Release overview, positioning, and developer-centric roadmap.
- High-level tour of AI Vector Search, JSON/relational duality, and async drivers.
- How 23ai changes typical developer workflows and application patterns.
2. Getting Hands-on: Environment and Tools (Lab)
- Installing and using Oracle Database 23ai Free for labs.
- Setting up JDK, IDE, and client drivers (JDBC, R2DBC where applicable).
- First connection, simple queries, and sample project scaffold.
3. JSON Relational Duality and New Data Types (Lab)
- Using the improved JSON data type and JSON collections in application code.
- Duality patterns: when to use relational vs JSON approaches.
- Examples: storing, querying, and updating JSON objects from Java/Quarkus apps.
4. AI Vector Search and Developer Use Cases (Lab)
- Introduction to AI Vector Search, vector data types, and vector indexes.
- Building a small semantic-search example: embedding generation, storage, and similarity queries.
- Integrating Vector Search with application code and libraries (LangChain/LlamaIndex examples discussed conceptually).
5. Asynchronous Programming, Pipelining, and Performance Patterns
- Understanding driver-level pipelining and async request patterns for JDBC, R2DBC, and other drivers.
- Client-side patterns (reactive streams, Java virtual threads) and server impact.
- Practical lab: implement pipelined calls and measure throughput improvements.
6. SQL, PL/SQL Enhancements, and Security Controls
- New SQL/PLSQL language features relevant to developers (e.g., schema annotations, direct joins in updates, new Boolean type).
- Overview of SQL Firewall and how it improves runtime security of executed SQL.
- Hands-on: migrate a small procedure to use new language features and test SQL Firewall behavior in a controlled lab.
7. Testing, Debugging, and Deployment Best Practices (Lab)
- Unit testing database logic, generating representative test data, and measuring behavior with new features.
- Packaging and deploying developer apps that use 23ai features to test environments.
- Checklist: performance tuning, compatibility considerations, and next steps for production readiness.
Summary and Next Steps
Requirements
- An understanding of SQL and relational database concepts
- Experience with application development in Java or similar languages
- Familiarity with basic PL/SQL or server-side scripting concepts
Audience
- Application developers (Java, Quarkus, or similar)
- Database developers and PL/SQL engineers
- DevOps engineers responsible for developer tooling and CI environments
14 Hours
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 3200 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (4)
Generating reports with the graphical interface.
Harold Romero Romero - OSFEM
Course - Oracle Database 19c: Administration
Machine Translated
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
