Course Description

Introduction
Working with Oracle Cloud Exadata Express Cloud Service
Introduction to PL/SQL
Declare PL/SQL Variables
Write Anonymous PL/SQL Blocks
SQL Statements in a PL/SQL block
Control Structures
Composite Data Types
Explicit Cursors
Exception Handling
Stored Procedures
Stored Functions
Debugging Subprograms
Packages
Deploying Packages
Implement Oracle-Supplied Packages in Application Development
Dynamic SQL
Design Considerations for PL/SQL Code
Triggers
Creating Compound, DDL, and Event Database Triggers
PL/SQL Compiler
Manage Dependencies