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. Overview and Novelty in Oracle Database 23ai
- Release summary, market positioning, and the developer-focused roadmap.
- A high-level examination of AI Vector Search, JSON/relational duality, and asynchronous drivers.
- How 23ai transforms standard developer workflows and application architectures.
2. Practical Setup: Environment and Tooling (Lab)
- Installation and configuration of Oracle Database 23ai Free for lab activities.
- Setup of JDK, IDEs, and client drivers (JDBC, R2DBC where relevant).
- Establishing the first connection, executing basic queries, and scaffolding a sample project.
3. JSON Relational Duality and Advanced Data Types (Lab)
- Utilizing the refined JSON data type and collections within application logic.
- Duality strategies: determining when to favor relational versus JSON approaches.
- Case studies: storing, querying, and modifying JSON objects from Java/Quarkus applications.
4. AI Vector Search and Practical Developer Applications (Lab)
- Foundations of AI Vector Search, including vector data types and indexing.
- Developing a semantic search example: generating embeddings, storing data, and performing similarity lookups.
- Integrating Vector Search with application code and libraries (conceptual discussion of 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 implementations (reactive streams, Java virtual threads) and their impact on server performance.
- Practical exercise: implementing pipelined calls and evaluating throughput enhancements.
6. SQL, PL/SQL Advances, and Security Measures
- New SQL/PLSQL language features pertinent to developers (e.g., schema annotations, direct joins in updates, Boolean type).
- Introduction to SQL Firewall and its role in enhancing runtime security for executed SQL.
- Practical task: updating a small procedure to leverage new language features and testing SQL Firewall behavior in a controlled lab.
7. Best Practices for Testing, Debugging, and Deployment (Lab)
- Unit testing database logic, generating relevant test data, and measuring performance with new features.
- Packaging and deploying developer applications utilizing 23ai features into test environments.
- Readiness checklist: performance tuning, compatibility checks, and next steps for production deployment.
Wrap-up and Future Directions
Requirements
- A solid grasp of SQL and relational database principles
- 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 stacks
- Database developers and PL/SQL specialists
- DevOps engineers managing developer tooling and CI 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
