Oracle 11g PL/SQL Fundamentals II
An introduction to the PL/SQL database programming language
4.60 (346 reviews)
1,842
students
10 hours
content
Nov 2017
last update
$59.99
regular price
What you will learn
Prepare your environment
Introducing Database Program Units
Creating and Maintaining Stored Procedures & Functions
Creating and Maintaining Packages
Advanced Cursor Techniques
Using System-Supplied Packages
Creating and Maintaining Database Triggers
Implementing System Event Triggers
Description
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).
Content
Introduction
Introduction
Preparing Your Environment
Install Oracle XE
SQL Developer Installation
Workstation Setup
Database Program Units
Introducing the Database Program Unit
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 Errors
Maintaining Stored Procedures and Functions
Recompiling and Dropping Programs
Data Dictionary Storage
Managing Dependencies
Tracking Dependencies
Using the Dependency Tracking Utility
Creating and Maintaining Packages
What Is a Package?
Creating a Package
Package Definition Information
Advanced Programming Techniques
Using Persistent Global Objects
Including Initialization Logic
Object Oriented Support within Packages
Package Maintenance
Advanced Cursor Techniques
Learning to Use Cursor Variables
Weak Cursor Definitions
REFCURSOR Cursor Definition
Using Cursor Expression
Using System Supplied Packages
Using the DBMS OUTPUT() Package
Using the UTL FILE() Package
Creating Database Triggers
Understanding the Database Trigger
Statement-Level Triggers
Row-Level Triggers
Row Level Trigger Example 1
Row Level Trigger Example 2
Row Level Trigger Example 3
Working with the INSTEAD OF Trigger
Using Triggers within an Application
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
Working with System Event Triggers
What Is a System Event Trigger
Defining Scope
Identifying Available System Events
Conclusion
Conclusion
Screenshots
Reviews
Amaro
May 13, 2020
This is the best PL/SQL course available on Udemy. The instructor explains everything in good detail and even if you took this course just to keep training like me, I still strongly recommend this one.
Shafiq
November 8, 2017
great explanation of concepts.
This guy explains the concept in a way that engages you to learn and know more.
He doesnt make it sound boring.
If you are a layman to this stream, this is the right course to choose.
Jessie
August 23, 2017
Excellent follow on video to complement the content from part one. Some of the content was beyond my job description but I enjoyed understanding what is possible if I had total control of the database.
Felecia
March 25, 2016
Excellent quality and format for such a complex area. I would watch this trainer any time. I gave a 4 because some of the scripts provided in the lesson did not work as expected. So, I spent a little more time making them work. In hindsight, I learned more doing it that way. But, it would have been good to have a warning - disclaimer about the scripts. Overall, great learning experience.
Charts
Price
Rating
Enrollment distribution
Related Topics
126134
udemy ID
11/27/2013
course created date
8/13/2020
course indexed date
Bot
course submited by