We provide virtual course about Oracle Database 23ai: New Features for Developers in english. This course will give you all the new features and enhancements of Oracle Database 23ai for the developers.
Course topics:
Module 1 - SQL New Features:
• Application Usage Annotations
• Direct Joins for Update and Delete
• IF EXISTS Support
• Aggregation over INTERVAL Data Types
• Application Usage Domains
• DESCRIBE and Column Annotations
• Extended CASE Controls
• GROUP BY and Aliases
• SELECT Without FROM Clause
• SQL Update Return Enhancements
• Automatic PL/SQL to SQL Transpiler
• FUZZY_MATCH and PHONIC_ENCODE Operators
Module 2 - JSON New Features:
• JSON Relational Duality
• JSON Schema
• XML and JSON Search Index Enhancements
• JSON VALUE Enhancements
• JSON TRANSFORM Enhancements
• JSON Data Dictionary Views
Module 3 - MACHINE LEARNING and GRAPH New Features:
• Native Representation of GRAPHS in Database
• SQL/PGQ Standards
• Machine Learning Library (PgxML) for Graphs
• Automated Time Series Model Search
• Multiple Time Series
• Generalized Linear Model Algorithm
• Outlier Detection
Module 4 - GENERAL New Features:
• SQL Firewall
• Table DDL Change Notifications
• ARGUMENT Command
• SQL*Plus PING Command
• SQL*Plus OERR Command
• SQL*Plus SET ERRORDETAILS Command
• Hybrid Partitioned Tables with Interval and Auto-List Partitioning
• SQL Access to Kafka (DBMS_KAFKA)
• Text Indexes
• Schema Privileges
Target audience:
This course content is designed for SQL and PL/SQL Developers who already have experience
Prerequisites:
• Good knowledge of Oracle Database previous versions
Language:
• English course material, english speaking instructor