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.
Course Outline
1. Overview of Oracle Database 23ai Updates
- Overview of the release context, strategic positioning, and developer-focused deployment roadmap for government systems.
- Summary of key capabilities, including AI Vector Search, JSON-relational duality, and asynchronous driver support.
- Analysis of how version 23ai modifies standard developer workflows and application architectures for federal use cases.
2. Laboratory Environment Configuration and Tooling
- Deployment instructions for Oracle Database 23ai Free Edition in laboratory settings.
- Configuration of development environments, including JDK, integrated development tools, and client drivers such as JDBC and R2DBC.
- Establishment of initial database connections, execution of basic queries, and initialization of sample project structures.
3. Laboratory: Implementing JSON Relational Duality and Advanced Data Types
- Application of enhanced JSON data types and collection handling within application code.
- Evaluation of duality patterns to determine optimal use of relational versus JSON methodologies.
- Practical demonstrations for storing, querying, and modifying JSON objects using Java and Quarkus frameworks.
4. Laboratory: AI Vector Search and Developer Applications
- Foundational concepts of AI Vector Search, including vector data types and indexing strategies.
- Construction of a semantic search prototype involving embedding generation, data storage, and similarity retrieval.
- Integration of Vector Search with application libraries, including conceptual review of LangChain and LlamaIndex implementations for government contexts.
5. Asynchronous Programming, Pipelining, and Performance Optimization
- Examination of driver-level pipelining and asynchronous request patterns across JDBC, R2DBC, and other supported drivers.
- Analysis of client-side reactive patterns, including Java virtual threads, and their impact on server performance.
- Practical exercise: Implementation of pipelined calls with throughput measurement to demonstrate efficiency gains.
6. SQL/PLSQL Enhancements and Security Controls
- Review of new SQL and PLSQL language features pertinent to developers, such as schema annotations, direct join updates, and boolean data types.
- Overview of SQL Firewall capabilities for enhancing runtime security and integrity of executed SQL statements.
- Laboratory exercise: Migration of procedures to utilize new language features and validation of SQL Firewall behavior in a controlled environment.
7. Laboratory: Testing, Debugging, and Deployment Best Practices
- Methods for unit testing database logic, generating representative test data, and evaluating functionality with new features.
- Strategies for packaging and deploying applications utilizing 23ai features to test environments for government certification.
- Compliance checklist covering performance tuning, compatibility assessments, and criteria for production readiness.
Summary and Next Steps
Requirements
- Competency in SQL and relational database principles
- Practical background in application development using Java or comparable programming languages
- Knowledge of fundamental PL/SQL or server-side scripting frameworks
Audience
- Application developers proficient in Java, Quarkus, or equivalent technologies
- Database specialists and PL/SQL engineers
- DevOps professionals managing developer toolchains and continuous integration environments for government operations
14 Hours
Testimonials (1)
good explanation on each points and provide assignment for practices.
