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: Innovations in Oracle Database 23ai
- Overview of the release, market positioning, and the developer-centric roadmap.
- A high-level exploration of AI Vector Search, JSON/relational duality, and asynchronous drivers.
- How 23ai transforms standard developer workflows and application architectures.
2. Practical Setup: Environment and Tools (Lab)
- Installing and configuring Oracle Database 23ai Free for laboratory exercises.
- Preparing the development environment with JDK, IDE, and client drivers (JDBC, R2DBC where relevant).
- Establishing initial connections, executing simple queries, and scaffolding sample projects.
3. Advancing JSON Relational Duality and Data Types (Lab)
- Integrating the enhanced JSON data type and JSON collections into application logic.
- Strategic patterns: determining when to adopt relational versus JSON approaches.
- Case studies: storing, retrieving, and modifying JSON objects from Java/Quarkus applications.
4. AI Vector Search: Developer Applications (Lab)
- Foundations of AI Vector Search, including vector data types and indexing strategies.
- Developing a semantic search prototype: generating embeddings, storing data, and executing similarity queries.
- Conceptual integration of Vector Search with application code and libraries (e.g., LangChain/LlamaIndex).
5. Asynchronous Programming, Pipelining, and Performance Optimization
- Analyzing driver-level pipelining and asynchronous request patterns for JDBC, R2DBC, and other interfaces.
- Client-side architectures (reactive streams, Java virtual threads) and their impact on server performance.
- Practical lab: implementing pipelined calls to quantify throughput enhancements.
6. SQL, PL/SQL Refinements, and Security Mechanisms
- Novel SQL/PLSQL language features for developers (e.g., schema annotations, direct joins in updates, new Boolean type).
- An overview of SQL Firewall and its role in strengthening runtime SQL security.
- Hands-on exercise: refactoring procedures to leverage new language features and testing SQL Firewall behavior in a controlled setting.
7. Best Practices for Testing, Debugging, and Deployment (Lab)
- Unit testing database logic, generating realistic test data, and evaluating performance with new features.
- Packaging and deploying developer applications utilizing 23ai capabilities to test environments.
- Readiness checklist: performance tuning, compatibility checks, and preparation for production deployment.
Summary and Path Forward
Requirements
- A solid grasp of SQL and relational database principles
- Practical experience in application development using Java or comparable languages
- Basic familiarity with PL/SQL or server-side scripting concepts
Target Audience
- Application developers working with Java, Quarkus, or similar frameworks
- Database developers and PL/SQL engineers
- DevOps engineers managing developer tooling and CI environments
Testimonials (3)
good explanation on each points and provide assignment for practices.
Piseth Ben - ACLEDA Bank Plc.
Course - Oracle Database 19c: SQL Tuning Workshop
presentation skills, prompt answers to all questions
Oana - OPEN COURSE
Course - Oracle SQL LP - Fundamentals
The exercises and "tests" that we performed
Paola Maccali
Course - Oracle SQL for beginners
Machine Translated