Preview unavailable

Course Materials

• Slides v1.0

• Lab Guide v1.0

About Oracle AI Database 26ai

• About Oracle AI Database 26ai

Preparing the Practice Environment

• 💻 Step-by-step Installation of Oracle AI Database 26ai

• (Optional) Importing pre-built Oracle 26ai VM Appliance

SQL*Plus New Features

• About SQL*Plus New Features

• Lab : SQL*Plus New Features

SELECT without FROM clause

• SELECT without FROM clause

Support for BOOLEAN Data Type in SQL

• Support for BOOLEAN Data Type in SQL

IF EXISTS, IF NOT EXISTS clause with DDL

• IF EXISTS, IF NOT EXISTS clause with DDL

DB_DEVELOPER_ROLE

• DB_DEVELOPER_ROLE

Wide Tables/Columns

• Wide Tables/Columns

Flashback Logs Placement

• Flashback Logs Placement

Schema Privileges

• Schema Privileges

New Features related to Tablespaces

• Bigfile Tablespaces and Shrinking Tablespaces

Lock-Free Reservations

• About Lock-Free Reservations

• Lab : Lock-Free Reservations

Priority Transactions

• About Priority Transactions

• Lab : Implementing Priority Transactions

Automatic Transaction Quarantine

• About Automatic Transaction Quarantine

PDB Priority

• PDB Priority

Read-only PDB Users

• Read-only PDB Users

Hybrid Read-only mode for PDBs

• Hybrid Read-only mode for PDBs

Oracle SQL Firewall

• About SQL Firewall

• Lab : Implementing SQL Firewall

Staging Tables

• Staging Tables

Unrestricted Parallel DMLs and Direct Loads

• Unrestricted Parallel DMLs and Direct Loads

Blockchain Tables

• About Blockchain Tables

• Lab : Blockchain Tables

JSON-Relational Duality Views

• About JSON Relational Duality Views

• Lab : JSON Relational Duality Views

Oracle AI Vector Search

• Overview of Vector Search

• What is Oracle AI Vector Search?

• Lab : Implementing Oracle AI Vector Search

Oracle True Cache

• About Oracle True Cache

• Lab : Implementing Oracle True Cache