Login
Oracle Database 26ai New Features for DBAs

Oracle Database 26ai: New Features for DBAs

Instructor-led Live Online Training

  • Time to move beyond 19c

  • Start learning the AI Database

  • Start your AI Journey

  • Learn the Futuristic Skills

  • Learn before others and stay ahead

  • 100% hands-on and quality commitment

Enroll Now (₹25,000/$360)

About the Course

Oracle AI Database 26ai is the next long-term release (LTS) of Oracle Database.

It includes over 300 new features with a focus on artificial intelligence (AI) and developer productivity.

It is the next-generation Artificial Intelligence (AI) native database, with AI architected into the entire data and development stack. It is designed to bring AI directly to the data, facilitating AI-powered application development and advanced analytics. It is also a converged database featuring advanced in-database AI Vector Search, support for multi-model data (relational, graph, JSON), and introduces agentic AI capabilities for creating autonomous agents.

This course covers the latest additions and improvements in Oracle Database 26ai.

It equips Oracle Database Administrators with knowledge about enhanced tools for better management, focusing on AI Vector Search, True Cache, Blockchain Tables, performance, architecture, security, and database sharding, Wide Tables, and Lock-Free Reservations and more...

Enroll today and upgrade your Oracle DBA skills to stay up to date and competitive.

What is Covered in this Course?

This course covers all the new features for DBAs, introduced in Oracle Database 21c through Oracle Database 26ai.

It includes new features introduced in Oracle Database 21c + Oracle Database 23ai + Oracle Database 26ai

Learn all the new features in one single course and keep yourself up-to-date with Oracle Database features.

Course Curriculum

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....