Oracle 11g PL/SQL Part 2 Intermediate
interactive

Oracle 11g PL/SQL Part 2 Intermediate

Understand the basic form and structure of program units stored within the database.

Intellezy
Updated May 22, 2025

What you'll learn

  • Build and maintain stored procedures
  • Create and manage database triggers
  • Utilize advanced cursor techniques
  • Prepare for Oracle certification exams
Course Description

In part 2, students will dive into topics such as understanding the basic form and structure of program units stored within the database, building and maintaining stored procedures, functions, packaged programs, and database triggers. Additional topics include taking advantage of advanced programming techniques such as cursor variables and cursor expressions. This Oracle 11g course will prepare students for the Oracle certification exams (OCP).

 

Prerequisites

The recommended prerequisite for this course is Oracle PL/SQL Part 1.