Oracle Database 23ai Developer Virtual Machine Training Appliance

This Oracle Database 23ai Developer Virtual Machine Training Appliance is a Developer Workshop CBT course bundled with a 23ai Database Virtual Machine - VM Training Appliance for practical hands-on training purposes.

This course introduces students to the fundamentals of SQL & PL/SQL programming using Oracle Database 23ai database technology. In this course students learn the concepts of relational databases and the powerful SQL and PL/SQL programming languages. This course provides the essential SQL & PL/SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects.

The Virtual Machine Training Appliance is a hands-on Lab designed to complement our Oracle Database 23ai Developer Workshop CBT and eLearning titles; it is delivered in either Oracle Virtual Box (ova) or VMWare format.

The Oracle Database 23aiDeveloper Workshop Virtual Machine Training Appliance is bundles Oracle Database 23ai VM software with our Oracle Oracle Database 23ai DBA Workshop Computer Based Training - CBT courses.

On successful Completion of this course you will be able to:

• Run data definition language (DDL) statements
• Identify the major structural components of the Oracle Database
• Retrieve row and column data from tables with the SELECT statement
• Create reports of sorted and restricted data
• Employ SQL functions to generate and retrieve customized data
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• Create reports of aggregated data
• Use the SET operators to create subsets of data
• Run data manipulation statements (DML) to update data
• Employ SQL & PL/SQL functions to generate and retrieve customized data
• Utilise new JSON features and improvements
• Understand and implement SQL enhancements for DML and DDL
• Create PL/SQL Triggers
• Create PL/SQL Stored Procedures and Functions
• Create PL/SQL Packages