Get in Touch
 Duration 14 hours

Course Outline

1. Introduction and Overview of Oracle Database 23ai Innovations

  • Release highlights, market positioning, and the developer-centric roadmap.
  • A high-level examination of AI Vector Search, JSON/relational duality, and asynchronous drivers.
  • How 23ai transforms standard developer workflows and application architectures.

2. Practical Setup: Environment and Tooling (Laboratory)

  • Installation and utilization of Oracle Database 23ai Free for hands-on practice.
  • Configuration of JDK, IDEs, and client drivers (including JDBC and R2DBC where relevant).
  • Establishing initial connections, executing basic queries, and scaffolding a sample project.

3. JSON Relational Duality and Advanced Data Types (Laboratory)

  • Integrating the enhanced JSON data type and collections into application code.
  • Duality patterns: determining when to employ relational versus JSON approaches.
  • Practical examples: persisting, retrieving, and modifying JSON objects from Java/Quarkus applications.

4. AI Vector Search and Application Scenarios (Laboratory)

  • Foundations of AI Vector Search, including vector data types and indexing mechanisms.
  • Constructing a basic semantic search application: embedding creation, data storage, and similarity lookups.
  • Integrating Vector Search into application logic and libraries (conceptual discussion of LangChain and LlamaIndex).

5. Asynchronous Programming, Pipelining, and Performance Optimization

  • Comprehending driver-level pipelining and asynchronous request patterns for JDBC, R2DBC, and other interfaces.
  • Client-side architectural patterns (reactive streams, Java virtual threads) and their impact on server performance.
  • Practical exercise: implementing pipelined calls and analyzing throughput enhancements.

6. SQL, PL/SQL Advances, and Security Mechanisms

  • Novel SQL and PL/SQL language features beneficial to developers (e.g., schema annotations, direct joins in updates, Boolean type).
  • An overview of SQL Firewall and its role in strengthening the runtime security of executed statements.
  • Hands-on activity: refactoring a procedure to utilize new language features and testing SQL Firewall behavior in a controlled environment.

7. Best Practices in Testing, Debugging, and Deployment (Laboratory)

  • Unit testing database logic, creating representative test data, and evaluating behavior with new features.
  • Packaging and deploying developer applications utilizing 23ai capabilities to test environments.
  • Checklist: performance tuning, compatibility review, and pathways to production readiness.

Summary and Future Directions

Requirements

  • A solid grasp of SQL and relational database principles
  • Practical experience in application development using Java or comparable programming languages
  • A basic understanding of PL/SQL or server-side scripting concepts

Target Audience

  • Application developers working with Java, Quarkus, or similar technologies
  • Database developers and PL/SQL specialists
  • DevOps engineers managing developer tooling and CI/CD environments

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories