Oracle Database 23ai: New Features for Developers Training in South Africa

  • Learn via: Online Instructor-Led / Classroom Based / Onsite
  • Duration: 2 Days
  • Level: Intermediate
  • Price: Please contact for booking options
  • Upcoming Date:
  • UK & South Africa Based Global Training Provider

This course focuses on the latest advancements in Oracle Database 23ai. This course explores new SQL capabilities, offering developers enhanced flexibility in writing SELECT, DML, DDL, and Materialized View statements. It also delves into improvements in Oracle's analytic capabilities, upgrades to JSON functionality, and introduces new Globalisation features.

We can organize this training at your preferred date and location. Contact Us!

HAVELSAN
ASELSAN
PepsiCo Türkiye
JTI TÜTÜN ÜRÜNLERİ SANAYİ A.Ş.
ING Bank
DHL
MASTERCARD
Huawei
TotalEnergies
Mercedes-Benz Türk A.Ş.
Goodyear
FORD OTOMOTIV SANAYI A.S.
3M COMPANY
Schneider Electric
Central Bank of Azerbaijan
BP Petrolleri
Procter & Gamble (P&G)
Qatar Foundation
Bank Of China
GlaxoSmithKline (GSK)
MORGAN STANLEY & CO Inc
Novo Nordisk
DEUTSCHE BANK
Azerbaycan Cumhuriyeti Emek ve Ahalinin Sosyal Güvenliği Bakanlığı
ACCENTURE

Prerequisites

Participants should have existing database development experience with a modern version of Oracle Database.

Target Audience

This course is designed for database developers who want to leverage the new features of Oracle Database 23ai to enhance their development skills and productivity.

What You Will Learn

  • Understand and implement SQL enhancements for DML and DDL
  • Utilise new JSON features and improvements
  • Explore advancements in Oracle's analytic platform
  • Apply new vectorised query processing techniques
  • Implement staging tables effectively
  • Learn about materialised view enhancements
  • Leverage new time and date handling changes
  • Utilise the latest Globalisation support features

Training Outline

SQL Enhancements for DML & DDL

  • Objectives
  • DEFAULT ON NULL for UPDATE Statements
  • Enhancements to SQL Statements
  • Annotations
  • IF (NOT) EXISTS Enhancement
  • GROUP BY Column Alias or Position
  • SELECT Without FROM Clause
  • RETURNING Clause Enhancement
  • SQL Support for BOOLEAN Datatype
  • Table Value Constructor
  • Aggregation Over INTERVAL Data Types
  • Direct Joins for UPDATE and DELETE
  • Summary

JSON

  • Objectives
  • JSON Schema Support
  • SODA Enhancements
  • Enhancement to JSON_TRANSFORM
  • Comparing and Sorting JSON Datatypes
  • Predicates for JSON_VALUE and JSON_QUERY
  • JSON-Relational Duality View
  • Lock-Free Concurrency Control
  • CREATE_VIEW_ON_PATH
  • Summary

Analytic Platform

  • Objectives
  • Data Quality Operators
  • JSON Materialised Views Enhancements
  • Summary

Other New Features

  • Objectives
  • Vectorised Query Processing
  • Staging Tables
  • LPCT for Materialised View Refresh and Staleness Tracking
  • Summary

SQL Enhancements for Materialised Views

  • Objectives
  • Overview of a Materialised View (MV)
  • Semi-Join Materialised View
  • ANSI Join Materialised View
  • Materialised View (MV) Refresh Enhancements Techniques
  • DBMS_MVIEW Package APIs
  • Summary

Other SQL Enhancements

  • Objectives
  • Transportable Binary XML (TBX)
  • Indexes with Automatic Maintenance
  • Enhanced Automatic Indexing
  • Summary

Time and Date Handling Changes

  • Objectives
  • Enhanced Time Zone Data Upgrade
  • Timezone Definitions Change: Considerations
  • Optimising Time Zone File Upgrade
  • Tables with TIMESTAMP WITH TIME ZONE Data
  • New Parameter in init.ora File
  • SYSDATE and SYSTIMESTAMP
  • Date and Time in Oracle Databases
  • Setting Database-Specific Time Example
  • Summary

Globalisation Support

  • Objectives
  • Globalisation Improvements
  • Unicode IVS Support
  • Unicode 15.0 Support
  • Summary

Why Choose Us

Experience Oracle Database 23ai: New Features for Developers in South Africa through Bilginç IT Academy's live and interactive virtual classroom environment, accessible from your home, office, or any location. Connect with expert trainers in real time and bring the energy of classroom learning into the digital experience.

  • Live Instructor-Led Sessions: Join scheduled training sessions with your instructor and fellow delegates in real time.
  • Interactive Learning Experience: Take part in discussions, practical exercises, group activities, and Q&A sessions throughout the course.
  • Expert Trainer Network: Learn from experienced trainers with strong industry backgrounds and practical field expertise.
  • Over 30 Years of Training Expertise: Benefit from Bilginç IT Academy's long-standing experience in delivering professional training since 1995.
  • Flexible and Scalable Delivery: Access live virtual classrooms from South Africa and worldwide, with flexible planning options for individual and corporate training needs.

Experience Oracle Database 23ai: New Features for Developers in a focused classroom environment in South Africa. Bilginç IT Academy's carefully selected training venues provide a professional setting where delegates can interact directly with expert trainers and peers.

  • Experienced Trainers: Learn from specialists with extensive field experience and real-world knowledge.
  • Professional Training Venues: Attend courses in comfortable, well-equipped classrooms designed to support effective learning.
  • Focused Classroom Experience: Benefit from limited class sizes that encourage discussion, interaction, and personalized support.
  • Quality-Driven Learning: Develop practical skills through structured, up-to-date, and professionally designed training content.

Meet your team's training needs with Bilginç IT Academy's onsite Oracle Database 23ai: New Features for Developers in South Africa solution, delivered at your office or preferred location. Align your team's development with your business goals through a training experience tailored to your organization.

  • Tailored Course Content: Adapt the training program to your organization's projects, team structure, and specific business requirements.
  • Time and Cost Efficiency: Reduce travel, accommodation, and operational costs while maximizing the value of your training investment.
  • Team-Focused Learning: Help your employees develop around the same knowledge base and strengthen collaboration across your organization.
  • Simplified Planning and Tracking: Manage the training process, participant development, and organizational requirements with greater control.
Contact us for more detail about our trainings and for all other enquiries!

Oracle Database 23ai: New Features for Developers Training Course in South Africa Schedule

Join our public courses in our South Africa facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

We can organize this training at your preferred date and location.
22 June 2026 (2 Days)
Cape Town, Johannesburg, Pretoria
22 July 2026 (2 Days)
Cape Town, Johannesburg, Pretoria
14 August 2026 (2 Days)
Cape Town, Johannesburg, Pretoria
11 September 2026 (2 Days)
Cape Town, Johannesburg, Pretoria
07 October 2026 (2 Days)
Cape Town, Johannesburg, Pretoria
11 October 2026 (2 Days)
Cape Town, Johannesburg, Pretoria
12 October 2026 (2 Days)
Cape Town, Johannesburg, Pretoria
18 October 2026 (2 Days)
Cape Town, Johannesburg, Pretoria

Blog posts related to Oracle Database 23ai: New Features for Developers Training Course in South Africa

WHO IS AN ORACLE DATABASE ADMINISTRATOR (DBA)?

An Oracle Database Administrator (DBA) is a technical specialist responsible for ensuring the stability, security, performance, and availability of Oracle database systems.

What Is Oracle 23ai? What Has Changed Compared to Previous Versions?

Oracle Database 23ai represents Oracle’s strategic shift toward an AI-native database architecture. Unlike Oracle 19c (long-term support) and 21c (innovation-focused), 23ai embeds artificial intelligence directly into the database engine.

South Africa is the most advanced technological market on the continent, with Cape Town and Johannesburg acting as world-class centers for fintech, telecommunications, and digital entrepreneurship. Cape Town’s vibrant tech scene, often called 'Silicon Cape,' attracts international venture capital and research talent, while Johannesburg remains the industrial and financial heart of technical innovation. The country's top universities, including the University of Cape Town and Wits, provide a strong academic foundation for research in Artificial Intelligence and Big Data. Our educational frameworks in South Africa focus on equipping the professional workforce with the high-level skills needed to manage complex enterprise infrastructures. We provide elite training in Cybersecurity, Enterprise Architecture, and Data Science to support South Africa's leading role in the global digital economy.

Bilginç IT Academy All Rights Reserved

By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.