OD-AI-NFD: Oracle AI Database New Features for Developers

Module 1: AI Vector Search

• AI Vector Search
• Oracle AI Vector Search Benefits
• VECTOR Data Type
• Vector Embeddings
• Vector Embeddings Models
• Basic Queries and Similarity Search

Module 2: SQL Enhancements for DML & DDL

• SQL Enhancements for DML and DDL
• DEFAULT ON NULL for UPDATE Statements
• Demo: DEFAULT ON NULL for UPDATE Statements
• Annotations
• Demo: Annotations
• IF (NOT) EXISTS Enhancement
• Demo: IF (NOT) EXISTS
• GROUP BY Column Alias or Position
• Demo: GROUP BY Alias or Column Position
• SELECT Without FROM Clause
• Demo: SELECT Without FROM Clause
• RETURNING Clause Enhancement
• Demo: SQL UPDATE RETURN Clause Enhancements
• SQL Support for BOOLEAN Datatype
• Demo: SQL Support for Boolean Datatype
• Table Value Constructor
• Demo: Table Value Constructor
• Aggregation Over INTERVAL Types
• Direct Joins for UPDATE and DELETE
• Summary: SQL Enhancements for DML and DDL

Practices

• Practice 1-1: DEFAULT ON NULL for UPDATE Statements
• Practice 1-2: Annotations
• Practice 1-3: IF (NOT) EXISTS
• Practice 1-4: GROUP BY Alias or Column Position
• Practice 1-5: SELECT Without FROM Clause
• Practice 1-6: SQL UPDATE RETURN Clause Enhancements
• Practice 1-7: SQL Support for Boolean Datatype
• Practice 1-8: Table Value Constructor
• Practice 1-9: Aggregation Over INTERVAL Data Types
• Practice 1-10: Direct Joins for UPDATE and DELETE Statements – Part 1
• Practice 1-10: Direct Joins for UPDATE and DELETE Statements – Part 2

Module 3: JSON

• JSON
• JSON Schema Support
• SODA Enhancements
• Demo: JSON
• Enhancement to JSON_TRANSFORM
• Demo: Enhancement to JSON_TRANSFORM
• Comparing and Sorting JSON Datatypes
• Demo: Comparing and Sorting JSON Datatypes
• Predicates for JSON_VALUE and JSON_QUERY
• Demo: Predicates for JSON_VALUE and JSON_QUERY
• JSON-Relational Duality View
• Summary: JSON

Practices

• Practice 2-1: JSON – Part 1
• Practice 2-1: JSON – Part 2
• Practice 2-2: Enhancement to JSON_TRANSFORM
• Practice 2-3: Comparing and Sorting JSON Datatypes
• Practice 2-4: Predicates for JSON_VALUE and JSON_QUERY

Module 4: Analytic Platform

• Analytic Platform
• Data Quality Operators
• JSON Materialized Views Enhancements
• Demo: Data Quality Operators in Oracle Database
• Summary: Analytic Platform

Practices

• Practice 3-1: Data Quality Operators in Oracle Database

Module 5: Other New Features

• Other New Features
• Vectorized Query Processing
• Staging Tables
• Demo: Staging Tables
• LPCT for Materialized View Refresh and Staleness Tracking
• Summary: Other New Features

Practices

• Practice 4-1: Vectorized Query Processing – Multilevel Joins and Aggregation
• Practice 4-2: Staging Tables

Module 6: SQL Enhancements for Materialized Views

• SQL Enhancements for Materialized Views
• Semi-Join Materialized View
• Demo: Semi-Join Materialized View
• ANSI Join Materialized View
• Demo: ANSI Join Materialized View
• Materialized View (MV) Refresh Enhancement Techniques
• Concurrent Refresh
• Demo: Concurrent Refresh
• DBMS_MVIEW Package APIs
• Summary: SQL Enhancements for Materialized Views

Practices

• Practice 5-1: Materialized View Using ANSI JOIN
• Practice 5-2: Concurrent Materialized View

Module 7: Other SQL Enhancements

• Other SQL Enhancements
• Transportable Binary XML (TBX)
• Demo: Transportable Binary XML
• Indexes with Automatic Maintenance
• Demo: Indexes with Automatic Maintenance
• Enhanced Automatic Indexing
• Summary: Other SQL Enhancements

Practices

• Practice 6-1: Search JSON Index

Module 8: Time and Date Handling Changes

• Time and Date Handling Changes
• Enhanced Time Zone Data Upgrade
• SYSDATE and SYSTIMESTAMP

Module 9: Globalization Support

• Globalization Support
• Globalization Improvements
• Unicode IVS Support
• Unicode 15.0 Support

Practices

• Practice 8-1: Experiment with Unicode IVS Options – Part 1
• Practice 8-1: Experiment with Unicode IVS Options – Part 2