Plan du cours
1. Introduction and What's New in Oracle Database 23ai
- Release overview, positioning, and developer-centric roadmap.
- High-level tour of AI Vector Search, JSON/relational duality, and async drivers.
- How 23ai changes typical developer workflows and application patterns.
2. Getting Hands-on: Environment and Tools (Lab)
- Installing and using Oracle Database 23ai Free for labs.
- Setting up JDK, IDE, and client drivers (JDBC, R2DBC where applicable).
- First connection, simple queries, and sample project scaffold.
3. JSON Relational Duality and New Data Types (Lab)
- Using the improved JSON data type and JSON collections in application code.
- Duality patterns: when to use relational vs JSON approaches.
- Examples: storing, querying, and updating JSON objects from Java/Quarkus apps.
4. AI Vector Search and Developer Use Cases (Lab)
- Introduction to AI Vector Search, vector data types, and vector indexes.
- Building a small semantic-search example: embedding generation, storage, and similarity queries.
- Integrating Vector Search with application code and libraries (LangChain/LlamaIndex examples discussed conceptually).
5. Asynchronous Programming, Pipelining, and Performance Patterns
- Understanding driver-level pipelining and async request patterns for JDBC, R2DBC, and other drivers.
- Client-side patterns (reactive streams, Java virtual threads) and server impact.
- Practical lab: implement pipelined calls and measure throughput improvements.
6. SQL, PL/SQL Enhancements, and Security Controls
- New SQL/PLSQL language features relevant to developers (e.g., schema annotations, direct joins in updates, new Boolean type).
- Overview of SQL Firewall and how it improves runtime security of executed SQL.
- Hands-on: migrate a small procedure to use new language features and test SQL Firewall behavior in a controlled lab.
7. Testing, Debugging, and Deployment Best Practices (Lab)
- Unit testing database logic, generating representative test data, and measuring behavior with new features.
- Packaging and deploying developer apps that use 23ai features to test environments.
- Checklist: performance tuning, compatibility considerations, and next steps for production readiness.
Summary and Next Steps
Pré requis
- An understanding of SQL and relational database concepts
- Experience with application development in Java or similar languages
- Familiarity with basic PL/SQL or server-side scripting concepts
Audience
- Application developers (Java, Quarkus, or similar)
- Database developers and PL/SQL engineers
- DevOps engineers responsible for developer tooling and CI environments
Nos clients témoignent (3)
Une communication excellente, Łukasz a expliqué tout de manière simple et compréhensible
Tomasz Wojciechowski - GP Strategies Poland sp. z o.o.
Formation - ORACLE SQL Fundamentals
Traduction automatique
le formateur était très utile, le rythme de la formation était vraiment bon et les exercices n'étaient ni trop difficiles, ni trop faciles. chaque fois que j'étais bloqué, il m'a aidé efficacement et s'est assuré que je comprenne tout.
Jade Stappaerts - KULeuven
Formation - Oracle SQL Language
Traduction automatique
les exercices
Amna AlAli - Federal Demographic Council
Formation - Oracle SQL for beginners
Traduction automatique