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 New Features in Oracle Database 23ai
- Release summary, market positioning, and the developer-focused roadmap.
- Comprehensive look at AI Vector Search, JSON/relational duality, and async drivers.
- Examining how 23ai transforms standard developer workflows and application designs.
2. Practical Setup: Environment and Tools (Lab)
- Deployment and usage of Oracle Database 23ai Free for laboratory work.
- Configuring the JDK, IDE, and client drivers (JDBC, R2DBC where relevant).
- Establishing initial connections, executing basic queries, and scaffolding a sample project.
3. JSON Relational Duality and Data Types (Lab)
- Incorporating the enhanced JSON data type and JSON collections into application logic.
- Exploring duality patterns: deciding between relational and JSON approaches.
- Demonstrations: storing, retrieving, and modifying JSON objects via Java/Quarkus applications.
4. AI Vector Search and Practical Use Cases (Lab)
- Fundamentals of AI Vector Search, vector data types, and vector indexing.
- Creating a semantic search prototype: generating embeddings, storing data, and running similarity queries.
- Connecting Vector Search to application code and libraries (conceptual discussions of LangChain/LlamaIndex integration).
5. Async Programming, Pipelining, and Performance Strategies
- Analyzing driver-level pipelining and asynchronous request patterns for JDBC, R2DBC, and other interfaces.
- Client-side methodologies (reactive streams, Java virtual threads) and their server-side implications.
- Practical exercise: executing pipelined calls to benchmark throughput gains.
6. SQL, PL/SQL Advancements, and Security Measures
- New SQL/PLSQL language capabilities for developers (e.g., schema annotations, direct joins in updates, new Boolean type).
- Understanding SQL Firewall and its role in enhancing runtime security for executed SQL.
- Practical task: adapting a small procedure to utilize new features and validating SQL Firewall behavior in a controlled lab.
7. Testing, Debugging, and Deployment Standards (Lab)
- Unit testing database logic, creating realistic test data, and evaluating behavior with new features.
- Building and deploying developer applications leveraging 23ai features to test environments.
- Readiness checklist: performance optimization, compatibility checks, and steps toward production deployment.
Conclusion and Future Directions
Requirements
- A solid grasp of SQL and relational database fundamentals
- Practical experience in application development using Java or comparable languages
- Broad knowledge of basic PL/SQL or server-side scripting principles
Target Audience
- Application developers working with Java, Quarkus, or similar technologies
- 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
