Oracle Database 23ai: New Features for Developers
This course explores developer-centric features in the Oracle Database 23ai release, starting with the AI Vector Search feature. It covers new capabilities in SQL for developers, offering flexibility in writing SELECT, DML, DDL, and Materialized View statements. The course also covers improvements in Oracle’s analytic capabilities, upgrades to JSON functionality, and introduces new Globalization features.
STUDENTS WILL LEARN TO
- AI Vector Search
- Enhancements for SQL: DML, DDL, Materialized Views
- JSON Enhancements
- New Features for Analytic Platform
- In-Memory Enhancements
- Other New Features
- Globalization
|
Phone
|
Phone
|
|---|---|
|
Product
|
Oracle
|
|
Code
|
D1105780GC10
|
|
Duration
|
2 Days
|
|
Price (baht)
|
40,000
|
About the course
COURSE OUTLINE
MODULE 01: Course Overview
- Course Overview – Oracle Database 23ai: New Features for Developers
MODULE 02: AI Vector Search
- Oracle AI Vector Search Benefits
- VECTOR Data Type
- Vector Embeddings
- Vector Embeddings Models
- Basic Queries and Similarity Search
MODULE 03: SQL Enhancements for DML & DDL
- SQL Enhancements for DML and DDL
- DEFAULT ON NULL for UPDATE Statements
- Annotations
- IF (NOT) EXISTS Enhancement
- GROUP BY Column Alias or Position
- SELECT without FROM clause
- RETURNING Clause Enhancement
- SQL Support for BOOLEAN Datatype
- Table Value Constructor
- Aggregation over INTERVAL types
- Direct Joins for UPDATE and DELETE
- Summary: SQL Enhancements for DML and DDL
MODULE 04: JSON
- JSON Schema Support
- SODA Enhancements
- Enhancement to JSON_TRANSFORM
- Comparing and Sorting JSON Datatypes
- Predicates for JSON_VALUE and JSON_QUERY
- JSON-Relational Duality View
- Summary: JSON
MODULE 05: Analytic Platform
- Data Quality Operators
- JSON Materialized Views Enhancements
- Summary: Analytic Platform
MODULE 06: Other New Features
- Vectorized Query Processing
- Staging Tables
- LPCT for Materialized View Refresh and Staleness Tracking
- Summary: Other New Features
MODULE 07: SQL Enhancements for Materialized Views
- Semi-Join Materialized View
- ANSI Join Materialized View
- Materialized View (MV) Refresh Enhancements Techniques
- Concurrent Refresh
- DBMS_MVIEW Package APIs
- Summary: SQL Enhancement
MODULE 08: Other SQL Enhancements
- Transportable Binary XML (TBX)
- Indexes with Automatic Maintenance
- Enhanced Automatic Indexing
- Summary: Other SQL Enhancements
MODULE 09: Time and Date Handling Changes
- Enhanced Time Zone Data Upgrade
- SYSDATE and SYSTIMESTAMP
MODULE 10: Globalization Support
- Globalization Improvements
- Unicode IVS Support
- Unicode 15.0 Support
MODULE 11: Course Summary
- Course Summary – Oracle Database 23ai: New Features for Developers
Register for Training
Schedule
| Start Date | End Date | Duration (days) | Price | Code |
|---|
