Oracle Database 23ai PL/SQL Workshop

This course is designed for Developers and Database Administrators, beginning with the foundational concepts of relational databases and the PL/SQL programming language. It covers writing Executable Statements against single and multiple tables, Declaring PL/SQL Variables, Working with Composite Data Types, manipulating data within tables, and conditionally control code flows. Participants will learn how to create Stored Procedures and Functions, Triggers, Packages, manage schema objects.

Certification: This course will help you to pass the Oracle Database 23ai SQL and Administration Associate | 1Z0-171 and 1Z0-182 exams.

On successful Completion of the Fundamentals of Modelling course you will be able to:

• Write Executable Statements
• Declaring PL/SQL Variables
• Working with Composite Data Types
• Conditionally control code flow (loops, control structures)
• Explicit cursors
• Handle runtime errors
• Describe and Create PL/SQL Stored Procedures and Functions
• Describe and Create PL/SQL Triggers
• Describe and Create PL/SQL Packages
• Employ PL/SQL functions to generate and retrieve customized data
• Utilise new JSON features and improvements
• Blockchain Table