DBA 12c R2: Program with PL/SQL Ed 2

  • Course level: Intermediate
  • Total Enrolled 1
  • Last Update February 26, 2021


The Database Program with PL/SQL training provides you with the learning of developing stored procedures, functions, packages and database triggers. You will be able to discover the managing PL/SQL program units and dependencies and also using of some of the Oracle-supplied packages.

Topics for this course

147 Lessons


PL/SQL development environments available in this course00:00:00
Introduction to SQL Developer
Course Objectives
Describe the Human Resources (HR) Schema
Course Agenda

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


Deploying Packages

Implement Oracle-Supplied Packages in Application Development

Dynamic SQL

Design Considerations for PL/SQL Code


Creating Compound, DDL, and Event Database Triggers

PL/SQL Compiler

Manage Dependencies