Skip to Main Content
Oracle AI Database 26ai New Features

About This Workshop

Youtube Video

About This Workshop
Explore the latest features in Oracle AI Database 26ai. Oracle AI Database 26ai is the new long term support release version of the database, packed with hundreds of new features. Each lab in this workshop can be run individually or in any order you choose.

Workshop Info

5 hours

Introduction

  • Get Started
  • Database Setup

Application Development

  • Lab: (NEW in 23.26) GraphQL Table Function
  • Lab: AI Vector Search
  • Lab: JSON Collection and MongoDB API
  • Lab: JSON Duality Views
  • Lab: Property Graphs
  • Lab: SQL Domains 
  • Lab: Annotations
  • Lab: JSON Schema
  • Lab: JavaScript Stored Procedures

High Availability

Security

  • Lab: SQL Firewall
  • Lab: Schema Level Privileges
  • Lab: Developer Role

Performance & Database Lifecycle Management

  • Lab: Shrink Tablespace
  • Lab: Error Message Improvements
  • Lab: SQL Analysis Report

SQL Enhancements

  • Lab:  (NEW in 23.26) QUALIFY Clause
  • Lab: UUID
  • Lab: Boolean
  • Lab: IF Exists for DDL
  • Lab: New Table Value Clause
  • Lab: Direct Joins for Updates and Deletes
  • Lab: Enhanced DML RETURNING clause
  • Lab: GROUP BY ALL

- Need Help?

  • Familiarity with Oracle Database and SQL is desirable, but not required
  • Some understanding database terms and SQL is helpful

Other Workshops you might like