YoVDO

Oracle Database Application Development - What's New, What's Next

Offered By: Oracle via YouTube

Tags

Oracle CloudWorld Courses SQL Courses PL/SQL Courses Continuous Integration Courses Cloud-Native Applications Courses Oracle Database Courses

Course Description

Overview

Discover the latest advancements in Oracle Database application development in this informative CloudWorld 2022 conference talk. Explore new features and functionalities designed to simplify and accelerate modern, cloud-native application development. Learn about improvements in SQL and PL/SQL, integration with cloud-native and CI/CD environments, and productivity-enhancing tools. Gain insights into Oracle Database 23C upgrades, schema-level privileges, annotations, key-value pairs, SQL and Object Domains, JSON Schema validation, JavaScript stored procedures, and enhanced error messages. Understand how these innovations can streamline your development process and boost productivity. Delve into the reasons why both developers and operations teams prefer Oracle Database, and get a glimpse of future developments in database technology.

Syllabus

Introduction
Oracle Database 23C
Upgrade to 23C
Why developers like Oracle Database
Why operations like Oracle Database
Two key goals for application development
Schema level privileges
Select on any table
Annotations
Keyvalue pairs
Keyvalue pairs on columns
SQL Domains
Object Domains
Reusing Domain
Domain Display Domain Order
Column Limits
Json Schemers
Schema Validation
Boolean Data Type
Update Base Tables
JavaScript Store Procedure
If Not Exist
Group By
Table Values
Value Scan
Enhanced Returning Clause
Developer Role
System Privileges
Expression Helper
Better Error Messages
Invalid Number
Conversion failed
Select from table that does not exist
Which table of view does not exist
Database name that is not there
Conclusion


Taught by

Oracle

Tags

Related Courses

Introduction to Cloud Foundry and Cloud Native Software Architecture
Linux Foundation via edX
Architecting with Google Kubernetes Engine: Production em Português Brasileiro
Google Cloud via Coursera
Introduction to Cloud Native, DevOps, Agile, and NoSQL
IBM via edX
Cloud Applications
Georgia Institute of Technology via Coursera
Introduction to Containers, Kubernetes and OpenShift
IBM via edX