Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
The objective of this Oracle 11g training course is to provide an introduction to develop database server-side PL/SQL program units within an Oracle database. The areas covered include 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).
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
The instructor has provided additional resources and example files for you to use. If you would like to access these, please download the attached .zip file, which contains the files shown in this course.
|Section 2: Preparing Your Environment|
Install Oracle XEPreview
SQL Developer Installation
|Section 3: Database Program Units|
Introducing the Database Program Unit
|Section 4: Working with Stored Procedures and Functions|
Creating Stored Procedures and Functions
Understanding the Parameter Specification
Executing Procedures and Functions
Calling Functions from within SQL
Handling Compilation ErrorsPreview
|Section 5: Maintaining Stored Procedures and Functions|
Recompiling and Dropping Programs
Data Dictionary Storage
Using the Dependency Tracking Utility
|Section 6: Creating and Maintaining Packages|
What Is a Package?
Creating a Package
Package Definition Information
Advanced Programming Techniques
Using Persistent Global ObjectsPreview
Including Initialization Logic
Object Oriented Support within Packages
|Section 7: Advanced Cursor Techniques|
Learning to Use Cursor Variables
Weak Cursor Definitions
REFCURSOR Cursor Definition
Using Cursor Expression
|Section 8: Using System Supplied Packages|
Using the DBMS OUTPUT() Package
Using the UTL FILE() Package
|Section 9: Creating Database Triggers|
Understanding the Database Trigger
Row Level Trigger Example 1
Row Level Trigger Example 2Preview
Row Level Trigger Example 3
Working with the INSTEAD OF Trigger
Using Triggers within an Application
|Section 10: Trigger Maintenance|
Using the CALL Statement
Trigger Maintenance Tasks
Work with Multiple Triggers for a Single Table
Handling Mutating Table Issues
Using the Compound Trigger
|Section 11: Working with System Event Triggers|
What Is a System Event TriggerPreview
Identifying Available System Events
|Section 12: Conclusion|
At Intellezy, we believe learning should be simple, engaging, and relevant. We make this possible by building innovative, short-segment eLearning videos and easy-to-use quick reference cards designed to educate and empower companies and individuals. In today’s rapidly evolving workplace it is imperative to make sure you have the skills required to succeed. Our library provides dynamic, task-focused videos right at your fingertips, right when you need them. Our goal? To educate the world, one video at a time.