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 and Key Updates in Oracle Database 23ai
- Overview of the release, its market positioning, and the developer-focused roadmap.
- A high-level exploration of AI Vector Search, JSON/relational duality, and asynchronous drivers.
- Examining how 23ai transforms standard developer workflows and application architectures.
2. Practical Setup: Environment and Tools (Lab)
- Installation and configuration of Oracle Database 23ai Free for laboratory exercises.
- Configuring 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 Enhanced Data Types (Lab)
- Applying the advanced JSON data type and JSON collections within application code.
- Understanding duality patterns: determining when to prefer relational versus JSON approaches.
- Demonstrations: storing, retrieving, and modifying JSON objects via Java/Quarkus applications.
4. AI Vector Search and Practical Developer Scenarios (Lab)
- Fundamentals of AI Vector Search, vector data types, and vector indexing.
- Creating a semantic search example: generating embeddings, storing data, and performing similarity queries.
- Integrating Vector Search with application logic and libraries (conceptual discussion of LangChain/LlamaIndex examples).
5. Asynchronous Programming, Pipelining, and Performance Optimization
- Analyzing driver-level pipelining and asynchronous request patterns for JDBC, R2DBC, and other drivers.
- Client-side strategies (reactive streams, Java virtual threads) and their impact on server performance.
- Practical lab: implementing pipelined calls to measure and improve throughput.
6. SQL, PL/SQL Advances, and Security Mechanisms
- Introduction to new SQL/PLSQL language features pertinent to developers (e.g., schema annotations, direct joins in updates, new Boolean type).
- An overview of SQL Firewall and its role in enhancing runtime security for executed SQL.
- Hands-on exercise: refactoring a small procedure to leverage new language features and testing SQL Firewall behavior in a controlled environment.
7. Best Practices for Testing, Debugging, and Deployment (Lab)
- Unit testing database logic, generating relevant test data, and assessing performance with new features.
- Packaging and deploying developer applications utilizing 23ai features to test environments.
- Checklist: performance tuning, compatibility review, and steps toward production readiness.
Conclusion and Future Directions
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 overseeing developer tooling and CI environments
Testimonials (1)
good explanation on each points and provide assignment for practices.