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 New Features in Oracle Database 23ai
- Overview of the release, its market positioning, and the developer-centric roadmap.
- High-level exploration of AI Vector Search, JSON/relational duality, and asynchronous drivers.
- Impact of 23ai on standard developer workflows and application design patterns.
2. Hands-On Setup: Environment and Tools (Lab)
- Installation and utilization of Oracle Database 23ai Free for laboratory exercises.
- Configuration of JDK, IDE, and client drivers (including JDBC and R2DBC where applicable).
- Initial connectivity checks, simple query execution, and project scaffolding.
3. JSON Relational Duality and New Data Types (Lab)
- Application of the improved JSON data type and JSON collections within application code.
- Duality patterns: determining when to adopt relational versus JSON approaches.
- Practical examples: storing, querying, and updating JSON objects from Java/Quarkus applications.
4. AI Vector Search and Developer Applications (Lab)
- Fundamentals of AI Vector Search, including vector data types and vector indexes.
- Developing a semantic-search example: generating embeddings, storing data, and executing similarity queries.
- Integration of Vector Search with application code and libraries (conceptual discussion of LangChain/LlamaIndex examples).
5. Asynchronous Programming, Pipelining, and Performance Optimization
- Comprehending driver-level pipelining and asynchronous request patterns for JDBC, R2DBC, and other drivers.
- Client-side implementation strategies (reactive streams, Java virtual threads) and their impact on server resources.
- Practical lab: Implementing pipelined calls and analyzing throughput improvements.
6. SQL, PL/SQL Enhancements, and Security Mechanisms
- New SQL/PLSQL language features relevant to developers (e.g., schema annotations, direct joins in updates, new Boolean type).
- Overview of SQL Firewall and its role in enhancing runtime security for executed SQL.
- Hands-on exercise: Migrate a sample procedure to utilize new language features and test SQL Firewall behavior in a controlled environment.
7. Testing, Debugging, and Deployment Best Practices (Lab)
- Unit testing of database logic, generating representative test data, and evaluating performance with new features.
- Packaging and deploying developer applications utilizing 23ai features into test environments.
- Checklist covering performance tuning, compatibility considerations, and preparation steps for production readiness.
Summary and Future Directions
Requirements
- Proficiency in SQL and core relational database concepts.
- Experience in application development using Java or similar programming languages.
- Basic familiarity with PL/SQL or server-side scripting principles.
Audience
- Application developers working with Java, Quarkus, or equivalent technologies.
- Database developers and PL/SQL engineers.
- 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