Oracle Database 23ai: New Features for Developers Training in Belgium

  • Learn via: Online Instructor-Led / Classroom Based / Onsite
  • Duration: 2 Days
  • Level: Intermediate
  • Price: Please contact for booking options
  • Upcoming Date:
  • UK 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!

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 live, interactive learning from the comfort of your home or office with Bilginç IT Academy's Online Instructor-Led Oracle Database 23ai: New Features for Developers Training in Belgium. Engage directly with expert trainers in a virtual environment that mirrors the energy and schedule of a physical classroom.

  • Live Sessions: Join scheduled classes with a live instructor and other delegates in real-time.
  • Interactive Experience: Engage in group activities, hands-on labs, and direct Q&A sessions with your trainer and peers.
  • Global Expert Trainers: Learn from a handpicked global pool of expert trainers with deep industry experience.
  • Proven Expertise: Benefit from over 30 years of quality training experience, equipping you with lasting skills for success.
  • Scalable Delivery: Accessible worldwide, including Belgium, with flexible scheduling to meet your professional needs.

Immerse yourself in our most sought-after learning style for Oracle Database 23ai: New Features for Developers Training in Belgium. Our hand-picked classroom venues in Belgium offer an invaluable human touch, providing a focused and interactive environment for professional growth.

  • Highly Experienced Trainers: Boost your skills with trainers boasting 10-20+ years of real-world experience.
  • State-of-the-Art Venues: Learn in high-standard facilities designed to ensure a comfortable and distraction-free experience.
  • Small Class Sizes: Our limited class sizes foster meaningful discussions and a personalized learning journey.
  • Best Value: Achieve your certification with high-quality training and competitive pricing.

Streamline your organization's training requirements with Bilginc IT Academy’s Onsite Oracle Database 23ai: New Features for Developers Training in Belgium. Experience expert-led learning at your own business premises, tailored to your corporate goals.

  • Tailored Learning Experience: Customize the training content to fit your unique business projects or specific technical needs.
  • Maximize Training Budget: Eliminate travel and accommodation costs, focusing your entire budget on the training itself.
  • Team Building Opportunity: Enhance team bonding and collaboration through shared learning experiences in your workspace.
  • Progress Monitoring: Track and evaluate your employees' progression and performance with relative ease and direct oversight.


Contact us for more detail about our trainings and for all other enquiries!

Available Training Dates

Join our public courses in our Belgium 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.
07 april 2026 (2 Days)
Brussels, Antwerp, Ghent
17 april 2026 (2 Days)
Brussels, Antwerp, Ghent
24 april 2026 (2 Days)
Brussels, Antwerp, Ghent
25 april 2026 (2 Days)
Brussels, Antwerp, Ghent
16 mei 2026 (2 Days)
Brussels, Antwerp, Ghent
14 juni 2026 (2 Days)
Brussels, Antwerp, Ghent
19 juni 2026 (2 Days)
Brussels, Antwerp, Ghent
24 juni 2026 (2 Days)
Brussels, Antwerp, Ghent

Belgium, with its capital Brussels serving as the heart of European policy and international administration, is a critical hub for corporate technology and digital governance. Cities like Antwerp and Ghent are also key players, fostering innovation in logistics technology and chemical engineering software. The presence of the University of Leuven (KU Leuven), consistently ranked as one of the world's most innovative universities, ensures a steady flow of high-tier technical talent. Our IT education services in Belgium are specifically tailored to the needs of international organizations and large-scale enterprises. We offer advanced curriculum in Enterprise Architecture, DevOps, and IT Governance to ensure that professionals in Belgium are equipped to lead innovation within the complex and multi-layered European tech landscape.

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