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

  • 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 Sweden. 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 Sweden, 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 Sweden. Our hand-picked classroom venues in Sweden 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 Sweden. 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 Sweden 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)
Stockholm, Gothenburg, Malmo
17 april 2026 (2 Days)
Stockholm, Gothenburg, Malmo
24 april 2026 (2 Days)
Stockholm, Gothenburg, Malmo
25 april 2026 (2 Days)
Stockholm, Gothenburg, Malmo
16 maj 2026 (2 Days)
Stockholm, Gothenburg, Malmo
14 juni 2026 (2 Days)
Stockholm, Gothenburg, Malmo
19 juni 2026 (2 Days)
Stockholm, Gothenburg, Malmo
24 juni 2026 (2 Days)
Stockholm, Gothenburg, Malmo

Sweden is the historic birthplace of global technology legends like Spotify and Ericsson, maintaining its status as a world leader in software engineering and sustainable digital solutions. Stockholm and Gothenburg serve as premier destinations for innovation, fueled by the academic prestige of KTH Royal Institute of Technology and a culture that embraces early technological adoption. The Swedish tech scene is characterized by its leadership in game development, green-tech, and secure communication systems, fostering a highly collaborative and creative professional environment. Our IT training programs in Sweden are tailored to this culture of excellence, focusing on Software Architecture, Cloud-Native development, and Cyber Defense. We support the Swedish workforce in maintaining their competitive edge within a Nordic region that consistently sets the global benchmark for digital integration and social innovation.

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