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 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
Testimonials (2)
good explanation on each points and provide assignment for practices.
Piseth Ben - ACLEDA Bank Plc.
Course - Oracle Database 19c: SQL Tuning Workshop
Greg was very patient and helpful