We use cookies to give you the best experience when you browse our site. For more information about the cookies we use or to view our privacy policy, click here.
With thousands of short segment IT video lessons at your disposal, Intellezy is the most engaging IT online learning library available. Get started today! With thousands of short segment IT video lessons at your disposal. Get started today!

Oracle 11g PL/SQL Part 2

Request a Free Trial

Course Overview

Instructor: Timothy Miles
Subject: Oracle 11g PL/SQL Part 2
Duration: 10 Hour 10 Minutes
Level: Intermediate
Pre-requisites: Oracle PL/SQL Part 1.
CC Languages: Arabic, Chinese (Simplified) , English, French, German, Hindi, Japanese, Portuguese (Brazil), Russian, Spanish


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).

Introduction2min 47sec
Preparing Your Environment Database Program Units Working with Stored Procedures and Functions Maintaining Stored Procedures and Functions Creating and Maintaining Packages Advanced Cursor Techniques Using System Supplied Packages Creating Database Triggers Trigger Maintenance Working with System Event Triggers Conclusion
Conclusion1min 38sec

Timothy Miles

Tim has been a professional developer for over 20 years. He has worked with almost every industry, creating many different software solutions. If it requires code, he has probably worked with it.

Learn More About Timothy Miles