Descrizione del corso
In this course, you will learn about the new features and capabilities in Oracle, including:
- AI Vector Search
- True Cache
- Database Sharding
- Database Availability
- Database Architecture
- Performance Improvements
- Database Manageability
- Blockchain Tables
- Database Security
Programma
SQL Enhancements for DML & DDL
- DEFAULT ON NULL for UPDATE Statements
- Enhancements to SQL 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 Data Types
- Direct Joins for UPDATE and DELETE
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
- Lock-Free Concurrency Control
- CREATE_VIEW_ON_PATH
Analytic Platform
- Data Quality Operators
- JSON Materialised Views Enhancements
- Vectorised Query Processing
- Staging Tables
- LPCT for Materialised View Refresh and Staleness Tracking
SQL Enhancements for Materialized Views
- Overview of a Materialized View (MV)
- Semi-Join Materialized View
- ANSI Join Materialized View
- Materialized View (MV) Refresh Enhancements Techniques
- DBMS_MVIEW Package APIs
Other SQL Enhancements
- Transportable Binary XML (TBX)
- Indexes with Automatic Maintenance
- Enhanced Automatic Indexing
Time and Date Handling Changes
- Enhanced Time Zone Data Upgrade
- Timezone Definitions Change: Considerations
- Optimising Time Zone File Upgrade
- Tables with TIMESTAMP WITH TIME ZONE Data
- New Parameter in init.ora File
- SYSDATE and SYSTIMESTAMP
- Date and Time in Oracle Databases
- Setting Database-Specific Time Example
Outline
- Blockchain Table Overview
- Blockchain Table User Chains
- Blockchain Table Delegate Signer
- Blockchain Table Countersignature
AI
- Application availability—zero downtime for database clients
- Automatic Transaction Rollback
- DBMS_Search
- Fast Ingest enhancements
- Raft-based replication in Globally Distributed Database
- SQL Analysis Report
- True Cache
- AI Vector Search
- Operational property graphs
