interactive
Oracle 11g PL/SQL Part 2 Intermediate
Understand the basic form and structure of program units stored within the database.
Intellezy
Updated Nov 26, 2024
What you'll learn
- 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
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.
