Oracle Database 23ai: New Features for Developers
This course will give you all the new features and enhancements of Oracle Database 23ai for the developers.
About the instructor Cuneyt Yilmaz
Cuneyt is working as senior instructor and consultant with specialty in Analytics, Business Intelligence, Data Management and Performance Tuning. He is a certified trainer for Microsoft and Oracle, and he also delivers training on MongoDB and PostgreSQL.
Cuneyt is based in Istanbul but has been working with customers in 35 countries across the Nordics and EMEA over the last 15 years. He combines top technology skills with his kindness and strong pedagogical skills. We dare to say, nobody leaves Cuneyt`s classroom disappointed!
Audience
This course content is designed for SQL and PL/SQL Developers who already have experience.
Prerequisites
Good knowledge of Oracle Database previous versions
Course topics
Module 1: SQL New Features
a. Application Usage Annotations
b. Direct Joins for Update and Delete
c. IF EXISTS Support
d. Aggregation over INTERVAL Data Types
e. Application Usage Domains
f. DESCRIBE and Column Annotations
g. Extended CASE Controls
h. GROUP BY and Aliases
i. SELECT Without FROM Clause
j. SQL Update Return Enhancements
k. Automatic PL/SQL to SQL Transpiler
l. FUZZY_MATCH and PHONIC_ENCODE Operators
Module 2: JSON New Features
a. JSON Relational Duality
b. JSON Schema
c. XML and JSON Search Index Enhancements
d. JSON_VALUE Enhancements
e. JSON_TRANSFORM Enhancements
f. JSON Data Dictionary Views
Module 3: MACHINE LEARNING and GRAPH New Features
a. Native Representation of GRAPHS in Database
b. SQL/PGQ Standards
c. Machine Learning Library (PgxML) for Graphs
d. Automated Time Series Model Search
e. Multiple Time Series
f. Generalized Linear Model Algorithm
g. Outlier Detection
Module 4: GENERAL New Features
a. SQL Firewall
b. Table DDL Change Notifications
c. ARGUMENT Command
d. SQL*Plus PING Command
e. SQL*Plus OERR Command
f. SQL*Plus SET ERRORDETAILS Command
g. Hybrid Partitioned Tables with Interval and Auto-List Partitioning
h. SQL Access to Kafka (DBMS_KAFKA)
i. Text Indexes
j. Schema Privileges
