Preparing Practice Environment

• Installing Oracle AI Database 26ai

• Creating Database

• Preparing the server for labs

Oracle AI Vector Search

• Overview of Oracle AI Vector Search

• Benefits of Vector Search

• VECTOR Data Type

• Vector Embeddings

• Vector Embedding Models

• Basic Queries and Similarity Search

True Cache

• Overview of True Cache

• Configuring and Deploying True Cache

• Monitoring True Cache

JSON-Relational Duality Views

• About JSON

• Use cases for JSON

• JSON data, JSON object, JSON array

• JSON support in Oracle Database

• About JSON-Relational duality views in Oracle Database

• Creating duality views

• Updatable duality views

• Data Dictionary

SQL*Plus New Features

• SET ERRORDETAILS command

• PING command

• OERR command

• SET|SHOW CONNECTION command 

Support for BOOLEAN Data Type

• Creating Tables with Boolean Data Type

• Assigning Boolean values

• SQL Support

• The TO_BOOLEAN function

• PL/SQL Support

Wide Tables

• Prior Challenges

• Benefits of Wide Columns

• Increase Column Limit

• Performance

Blockchain Tables

• Blockchain Tables overview

• New Features in 26ai

• Creating Blockchain Tables

• Altering Blockchain Tables

• DDL, DML on Blockchain Tables

• Controlling Retention Times

Flashback Log Placement

• Overview of Flashback Log

• Flashback Log Parameters

• Flashback Log Management

Priority Transactions

• Overview of Priority Transactions

• Using Priority Transactions

• Monitoring Priority Transactions

• Priority Transactions Behavior

Automatic Transaction Quarantine

• Overview of Automatic Transaction Quarantine

• Monitoring Quarantined Transactions

• Dropping Quarantined Transactions

• Quarantined Transaction Escalation

Lock Free Reservations

• Comparing Locking – Optimistic, Lock Free

• Lock Free Reservations

• Functionality Requirements

• Create, Modify, Delete reservable columns

• Lock Free Reservations Journal Table

• Data Dictionary Views

PDB Priority

• About PDB Priority

• How Priorities work?

• Setting PDB Priorities

• Viewing PDB Priorities

Read-only PDB User

• About Read-only PDB Users

• Creating Read-only PDB Users

• Altering Read-only PDB Users

• Viewing the Read-only User status

Hybrid Read-only mode for PDBs

• About Hybrid Read-only mode

• Use of Hybrid Read-only mode for PDBs

• Implementing and testing Hybrid Read-only mode

Schema Privileges

• About Schema Privileges

• Benefits of Schema Privileges

• Excluded Privileges

• Granting and Revoking Schema Privileges

• Finding Information about Schema Privileges

Developer Role

• About DB_DEVELOPER_ROLE

• Privileges assigned to DB_DEVELOPER_ROLE

• Granting and Revoking DB_DEVELOPER_ROLE

Oracle SQL Firewall

• About SQL Firewall

• Advantages of SQL Firewall

• Enabling SQL Firewall

• Initiating Capture Process

• Checking Capture Logs

• Generating Allow-List

• Enforcing Allow-List

• Viewing Violations

• SQL Firewall Licensing

Staging Tables

• About Staging Tables

• Benefits of Staging Tables

• Creating Staging Tables

• Viewing Staging for a table

• Enabling/Disabling Staging for a table

• Prohibited operations on Staging Tables

Unrestricted Parallel DMLs

• Overview of Parallel DMLs

• Improvements in 26ai

• Benefits

Unrestricted Direct Load

• Direct Load pre 26ai

• Improvements in 26ai

• Benefits

SELECT without FROM clause

IF [NOT] EXISTS DDL clause

And more....