Workshop

Oracle-Datenbank 21c/23ai – New Features («O23AIN»)

This course deals with all new features of the Oracle database from Oracle 21c onwards, with a special focus on Oracle 23ai.
Duration 3 days
Price 2'950.–
Course documents Digital courseware

Course facts

Content

Some of the new features can also be found in older versions, but they appear here because they were either backported into 19c or were introduced so secretly and quietly that they practically flew «under the radar» and hardly anyone noticed them.

The focus is of course on the features that were introduced or improved with Oracle Database 23ai. The course covers administrative as well as development-specific innovations.

Topics:

1 Upgrade

  • Upgrade via AutoUpgrade Tool

2 JSON

  • Oracle has supported JSON since 12c, some new features have been added

3 Converged Database: JavaScript, MongoDB and Kafka

  • Oracle opens up for NoSQL databases, can use JavaScript and creates interfaces for Kafka for the use of High Performance Transaction Event Queues

4 SQL – New Features

  • No more DUAL! Boolean!

5 PL/SQL – New Features

  • The most comprehensive changes in PL/SQL since 9i

6 DDL and Administration

  • SQl domains, annotations and much more

7 Network/Security

  • Login with TLS has become even easier, EZConnect can do even more

8 Data Ware House New Features

9 Multitenant Database

10 Special 23ai features

  • True Cache
  • Property Graph Queries
  • AI Vector Search
  • AI Natural Speach to SQL
  • Scalable Ordered Sequences
  • Oracle Globally Distributed Database with RAFT
  • SQL Firewall
Target audience

Oracle database administrators, including experienced Oracle developers or architects who operate/develop Oracle databases and/or applications on them and want to know what possibilities the latest versions offer.

Requirements

For a workshop with participants from different companies (participants must take care of Oracle licensing themselves), the basics of Oracle database administration are a prerequisite

In a workshop with participants from a single company, at least one Oracle DBA should attend to carry out the pure DBA exercises. All other participants can be developers or architects.

Additional information

Course environment (and Oracle license requirements)

  • Supported Oracle versions: Oracle 23ai of course. Features that require more than a standard edition license or an additional package are priced separately.
  • This workshop is based on Oracle Database 23ai Free. Further information on the course environment and Oracle licensing can be found here.
  • SQL*Plus is used as the front end. The use of Oracle SQL*Developer or one of the numerous third party tools (Toad, SolarWind etc) is partially possible, but leads to different exercise sequences.

Download

Questions

Any questions?
First name
Last name
Company optional
Email
Phone
I would like to book this course as a company course
First name
Last name
Company
Email
Phone
Number of participants
Desired course location
Start date (DD.MM.YYYY)
End date (DD.MM.YYYY)

Choose your date

27
Aug
2025
29
Aug
2025
Virtual Training
German
Timetable
CHF 2’950.-
exkl. 8.1% Mwst.
CHF 2’950.-
exkl. 8.1% Mwst.
24
Nov
2025
26
Nov
2025
Virtual Training
German
Timetable
CHF 2’950.-
exkl. 8.1% Mwst.
CHF 2’950.-
exkl. 8.1% Mwst.
Next date
27
Aug
2025
29
Aug
2025
Virtual Training
German
Timetable
CHF 2’950.-
exkl. 8.1% Mwst.
CHF 2’950.-
exkl. 8.1% Mwst.