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 Innovations in Oracle Database 23ai
- Overview of the release, strategic positioning, and the developer-oriented roadmap.
- High-level review of AI Vector Search, JSON/relational duality, and asynchronous drivers.
- Impact of 23ai on standard development workflows and application architecture patterns.
2. Practical Setup: Environment and Tooling (Laboratory)
- Installation and configuration of Oracle Database 23ai Free for training purposes.
- Configuration of the JDK, Integrated Development Environment (IDE), and client drivers (JDBC, R2DBC where applicable).
- Establishing initial connections, executing basic queries, and generating sample project structures.
3. JSON Relational Duality and Advanced Data Types (Laboratory)
- Implementation of the enhanced JSON data type and JSON collections within application code.
- Duality strategies: determining when to employ relational versus JSON methodologies.
- Case studies: storing, retrieving, and modifying JSON objects from Java/Quarkus applications.
4. AI Vector Search and Application-Driven Use Cases (Laboratory)
- Foundations of AI Vector Search, vector data types, and vector indexing mechanisms.
- Developing a semantic search prototype: generating embeddings, storing data, and executing similarity queries.
- Integrating Vector Search with application frameworks and libraries (conceptual review of LangChain/LlamaIndex).
5. Asynchronous Programming, Pipelining, and Performance Optimization
- Analysis of driver-level pipelining and asynchronous request patterns for JDBC, R2DBC, and other drivers.
- Client-side methodologies (reactive streams, Java virtual threads) and their impact on server performance.
- Practical exercise: implementing pipelined calls and assessing throughput enhancements.
6. SQL, PL/SQL Advancements, and Security Governance
- New SQL/PLSQL language features pertinent to developers (e.g., schema annotations, direct joins in updates, Boolean data type).
- Overview of SQL Firewall and its role in strengthening the runtime security of executed SQL statements.
- Practical exercise: refactoring procedures to utilize new language features and validating SQL Firewall behavior in a controlled environment.
7. Testing, Debugging, and Deployment Standards (Laboratory)
- Unit testing database logic, generating representative test datasets, and evaluating behavior with new features.
- Packaging and deploying developer applications leveraging 23ai features to staging environments.
- Validation checklist: performance tuning, compatibility analysis, and criteria for production readiness.
Summary and Strategic Next Steps
Requirements
- Demonstrated understanding of SQL and relational database architecture
- Proficiency in application development using Java or comparable programming languages
- Familiarity with fundamental PL/SQL or server-side scripting principles
Target Audience
- Application developers (Java, Quarkus, or equivalent frameworks)
- Database developers and PL/SQL engineers
- DevOps engineers managing developer tooling and continuous integration environments
Testimonials (1)
good explanation on each points and provide assignment for practices.