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.
Duration 14 hours
Course Outline
1. Introduction: What’s New in Oracle Database 23ai
- Release highlights, market positioning, and the developer-first roadmap.
- High-level exploration of AI Vector Search, JSON-relational duality, and asynchronous drivers.
- How 23ai transforms standard developer workflows and application architectures.
2. Getting Started: Environment Setup and Tools (Lab)
- Installation and configuration of Oracle Database 23ai Free for lab exercises.
- Setup of JDK, IDE, and client drivers (including JDBC and R2DBC where relevant).
- Establishing initial connections, executing simple queries, and scaffolding a sample project.
3. JSON Relational Duality and Advanced Data Types (Lab)
- Leveraging the improved JSON data type and JSON collections within application logic.
- Duality patterns: determining when to adopt relational versus JSON approaches.
- Case studies: storing, querying, and modifying JSON objects from Java/Quarkus applications.
4. AI Vector Search: Developer Applications (Lab)
- Fundamentals of AI Vector Search, vector data types, and vector indexing.
- Constructing a semantic search prototype: generating embeddings, storing vectors, and running similarity queries.
- Integrating Vector Search into application code, with conceptual discussion of LangChain and LlamaIndex implementations.
5. Asynchronous Programming, Pipelining, and Performance Optimization
- Exploring driver-level pipelining and asynchronous request patterns for JDBC, R2DBC, and other interfaces.
- Client-side design patterns (reactive streams, Java virtual threads) and their impact on server performance.
- Practical lab: implementing pipelined calls to quantify and verify throughput gains.
6. SQL, PL/SQL Enhancements, and Security Features
- New SQL/PLSQL language features beneficial to developers (e.g., schema annotations, direct joins in updates, new Boolean type).
- Introduction to SQL Firewall and its role in strengthening runtime SQL security.
- Hands-on exercise: refactoring a procedure to utilize new language features and testing SQL Firewall behavior in a sandbox environment.
7. Testing, Debugging, and Deployment Best Practices (Lab)
- Unit testing database logic, creating representative test data, and assessing behavior with new features.
- Packaging and deploying 23ai-enabled applications to testing environments.
- Readiness checklist: performance tuning, compatibility checks, and pathways to production deployment.
Summary and Future Steps
Requirements
- Solid grasp of SQL and relational database fundamentals
- Hands-on experience with application development in Java or comparable languages
- Working knowledge of basic PL/SQL or server-side scripting principles
Target Audience
- Application developers working with Java, Quarkus, or similar frameworks
- Database specialists and PL/SQL engineers
- DevOps engineers managing developer tooling and CI/CD environments
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
