Database 23c AI: The Art of AI-Powered Querying

Learn how AI is transforming querying—this is the future of databases.

Main Speaker

Learning Tracks

Course ID

42813

Date

24/11/2025

Time

Daily seminar
9:00-16:30

Location

Daniel Hotel, 60 Ramat Yam st. Herzliya

Overview

SQL is de-facto the standard language to work with a database for more than 40 years. Each version adds new and different capabilities that allow us to improve and simplify complex and long queries. In this seminar we will go over advanced SQL capabilities and different additions to the language. We will see the new Features that appeared in 23AI, how they enrich existing features, and how we can use them in our daily work. In 23AI Oracle added more than 300 new Features, many of them are for improving the developer’s life.

Who Should Attend

Anyone who wants to improve their SQL skills, DBA, BI developers

Prerequisites

Basic knowledge of SQL

Course Contents

  • What is Converged Database
  • Aggregations, including Rollup, Cube, Grouping Sets, Concatenated Groupsand more
  • Analytical functions, including window functions and new window clause enhancements
  • Pivoting and unpivoting data
  • Hierarchal queries and recursive queries
  • Regular expressions
  • Identifying patterns in the data (dive into match_recognize)
  • Top N queries and Pagination
  • Approximate queries
  • What is JSON, JSON support in Oracle, and its evolvement over the new versions
  • SQL Macros
  • UsingQuickSQL to generate table DDL and sample data
  • We will also go through new 23ai features, such as:
    • UPDATE and DELETE Statements via direct Joins
    • Select Without FROM Clause
    • GROUP BY Column Alias or Position
    • IF [NOT] EXIST DDL Clause
    • Boolean Data Type
    • Better error messages means less errors
    • Schema JSON
    • AI vector search
    • Schema-level privilege grants
    • Database Developer Role
    • JSON duality representations
    • Select AI
    • Aggregation over INTERVAL Data Types
    • And more

The conference starts in

Days
Hours
Minutes
Seconds