Oracle 11g PL/SQL: Part 2: Intermediate

In the PL/SQL Fundamentals II course, our main objective is to show you how to create 2 key objects: stored procedures and database triggers. To begin, you’ll learn about the basic form and structure of program units stored within the database. Then, you’ll learn how to create and maintain stored procedures and functions, as well as packages. Importantly, you’ll learn how to create and maintain database triggers, which are more complex, using handy techniques to simplify the process. The course also covers advanced programming techniques such as cursor variables and cursor expressions.
This Oracle 11g course will prepare students for the Oracle certification exams (OCP). It is the second and final part in a 2-part series on PL/SQL.