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

  • by admin
  • Course level: Intermediate
  • Categories Oracle
  • Total Enrolled 0
  • Last Update August 6, 2020


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.

What Will I Learn?

  • Conditionally control code flow such as loops and control structures.
  • Create stored procedures and functions.
  • Making use of PL/SQL packages to group and contain related constructs.
  • Generate triggers to solve business challenges.
  • Generate screen output and file output using some of the Oracle supplied PL/SQL packages to Create custom packages for applications.
  • Write Dynamic SQL code for applications.
  • Create custom packages for applications.

Topics for this course

147 Lessons


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

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


Material Includes

  • Duration: Part-time-3 Saturdays
  • 28 hours on-demand video
  • 11 articles
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion


  • No coding experience is necessary to take this course!
  • Any computer and OS will work — Windows, macOS or Linux.
  • A basic understanding of HTML and CSS is a plus.

Target Audience

  • Practice your new skills with coding challenges.
  • Organize and structure your code using software.
  • Get friendly and fast support in the course.