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 Overview of New Capabilities in Oracle Database 23ai
- Summary of the release, strategic positioning, and the development-oriented roadmap.
- High-level examination of AI Vector Search, JSON/relational duality, and asynchronous driver mechanisms.
- Analysis of how version 23ai modifies standard development workflows and application architectural patterns.
2. Practical Application: Environment Setup and Tooling (Laboratory Exercise)
- Installation and operational use of Oracle Database 23ai Free for controlled experimental environments.
- Configuration of the Java Development Kit (JDK), integrated development environments (IDE), and client drivers (JDBC, R2DBC where applicable).
- Establishment of initial connectivity, execution of basic queries, and creation of a sample project framework.
3. JSON Relational Duality and Enhanced Data Types (Laboratory Exercise)
- Implementation of the improved JSON data type and JSON collections within application logic.
- Evaluation of duality models: determining optimal usage between relational and JSON-based approaches.
- Demonstrations: storage, retrieval, and modification of JSON objects from Java/Quarkus applications.
4. AI Vector Search and Developer Application Scenarios (Laboratory Exercise)
- Foundational concepts of AI Vector Search, vector data structures, and vector indexing strategies.
- Development of a semantic search prototype: embedding generation, persistence, and similarity assessment queries.
- Integration of Vector Search capabilities with application code and supporting libraries (conceptual discussion of LangChain/LlamaIndex implementations).
5. Asynchronous Programming, Pipelining, and Performance Optimization
- Comprehension of driver-level pipelining and asynchronous request handling for JDBC, R2DBC, and related protocols.
- Client-side design patterns (reactive streams, Java virtual threads) and their impact on server resources.
- Practical exercise: implementation of pipelined calls and quantitative measurement of throughput enhancements.
6. SQL, PL/SQL Advancements, and Security Governance
- New SQL/PLSQL language capabilities relevant to development (e.g., schema annotations, direct joins in update statements, introduction of the Boolean type).
- Overview of the SQL Firewall mechanism and its role in strengthening runtime security of executed SQL statements.
- Hands-on task: migration of a sample procedure to utilize new language features and verification of SQL Firewall behavior in a controlled laboratory setting.
7. Testing, Debugging, and Deployment Best Practices (Laboratory Exercise)
- Unit testing of database logic, generation of representative test datasets, and behavioral assessment of new features.
- Packaging and deployment of developer applications utilizing 23ai capabilities to non-production environments.
- Compliance checklist: performance tuning, compatibility review, and subsequent steps for production readiness.
Summary and Future Actions
Requirements
- Foundational understanding of SQL and relational database concepts
- Experience in application development using Java or comparable programming languages
- Familiarity with basic PL/SQL or server-side scripting principles
Target Audience
- Application developers (Java, Quarkus, or similar technologies)
- Database developers and PL/SQL engineers
- DevOps engineers responsible for developer tooling and continuous integration environments
Testimonials (1)
good explanation on each points and provide assignment for practices.
