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. Introduction and What's New in Oracle Database 23ai
- Overview of the release, strategic positioning, and developer-focused roadmap for government applications.
- Comprehensive tour of key features including AI Vector Search, JSON/relational duality, and asynchronous drivers.
- Discussion on how 23ai transforms traditional developer workflows and application patterns in public sector environments.
2. Getting Hands-on: Environment and Tools (Lab)
- Installation and configuration of Oracle Database 23ai Free for laboratory exercises.
- Setup instructions for JDK, IDEs, and client drivers such as JDBC and R2DBC where applicable.
- Initial connection procedures, basic queries, and the creation of a sample project scaffold for government use cases.
3. JSON Relational Duality and New Data Types (Lab)
- Utilizing enhanced JSON data types and JSON collections in application development for government projects.
- Strategies for choosing between relational and JSON approaches based on specific use cases.
- Practical examples of storing, querying, and updating JSON objects from Java/Quarkus applications tailored for government operations.
4. AI Vector Search and Developer Use Cases (Lab)
- Introduction to AI Vector Search capabilities, including vector data types and indexes for government applications.
- Step-by-step guide to building a small semantic search example: embedding generation, storage, and similarity queries tailored for public sector needs.
- Conceptual discussion on integrating Vector Search with application code and libraries such as LangChain and LlamaIndex, emphasizing relevance for government use cases.
5. Asynchronous Programming, Pipelining, and Performance Patterns
- Explanation of driver-level pipelining and asynchronous request patterns for JDBC, R2DBC, and other drivers in the context of government applications.
- Client-side patterns (reactive streams, Java virtual threads) and their impact on server performance for government systems.
- Practical lab: implementation of pipelined calls and measurement of throughput improvements for government operations.
6. SQL, PL/SQL Enhancements, and Security Controls
- Overview of new SQL/PLSQL language features relevant to developers in the public sector, including schema annotations, direct joins in updates, and a new Boolean type.
- Introduction to SQL Firewall and its role in enhancing runtime security for executed SQL queries in government systems.
- Hands-on lab: migration of a small procedure to utilize new language features and testing of SQL Firewall behavior in a controlled environment for government applications.
7. Testing, Debugging, and Deployment Best Practices (Lab)
- Best practices for unit testing database logic, generating representative test data, and measuring behavior with new features for government projects.
- Packaging and deploying developer applications that leverage 23ai features to test environments in the public sector.
- Checklist: performance tuning, compatibility considerations, and next steps for achieving production readiness for government systems.
Summary and Next Steps
Requirements
- An understanding of SQL and relational database concepts for government applications
- Experience with application development in Java or similar languages
- Familiarity with basic PL/SQL or server-side scripting concepts
Audience
- Application developers working with Java, Quarkus, or similar technologies for government projects
- Database developers and PL/SQL engineers supporting government systems
- DevOps engineers responsible for developer tooling and CI environments in government agencies
14 Hours
