Oracle 11g PL/SQL Fundamentals II
4.8 (317 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,738 students enrolled

Oracle 11g PL/SQL Fundamentals II

An introduction to the PL/SQL database programming language
4.8 (317 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,738 students enrolled
Last updated 11/2017
English
English [Auto], French, 7 more
  • German
  • Hindi
  • Japanese
  • Portuguese
  • Russian
  • Simplified Chinese
  • Spanish
Current price: $59.99 Original price: $99.99 Discount: 40% off
7 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 10 hours on-demand video
  • 3 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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
Requirements
  • Familiarity with database and programming principles
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).

Who this course is for:
  • Application designers and developers
  • Database administrators
  • Business users and non-technical senior end users
Course content
Expand all 46 lectures 10:08:46
+ Introduction
1 lecture 02:40

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.

Preview 02:40
+ Database Program Units
1 lecture 19:05
Introducing the Database Program Unit
19:05
+ Working with Stored Procedures and Functions
5 lectures 01:29:44
Creating Stored Procedures and Functions
18:44
Understanding the Parameter Specification
23:04
Executing Procedures and Functions
26:18
Calling Functions from within SQL
13:12
+ Maintaining Stored Procedures and Functions
5 lectures 01:12:03
Recompiling and Dropping Programs
16:06
Data Dictionary Storage
24:54
Managing Dependencies
12:59
Tracking Dependencies
08:32
Using the Dependency Tracking Utility
09:32
+ Creating and Maintaining Packages
8 lectures 01:34:17
What Is a Package?
10:02
Creating a Package
19:10
Package Definition Information
07:59
Advanced Programming Techniques
06:13
Including Initialization Logic
15:24
Object Oriented Support within Packages
13:51
Package Maintenance
17:54
+ Advanced Cursor Techniques
4 lectures 58:51
Learning to Use Cursor Variables
23:38
Weak Cursor Definitions
16:17
REFCURSOR Cursor Definition
05:13
Using Cursor Expression
13:43
+ Using System Supplied Packages
2 lectures 41:14
Using the DBMS OUTPUT() Package
11:38
Using the UTL FILE() Package
29:36
+ Creating Database Triggers
8 lectures 01:44:33
Understanding the Database Trigger
23:18
Statement-Level Triggers
22:42
Row-Level Triggers
12:11
Row Level Trigger Example 1
11:15
Row Level Trigger Example 3
07:42
Working with the INSTEAD OF Trigger
11:00
Using Triggers within an Application
08:54
+ Trigger Maintenance
5 lectures 01:00:21
Using the CALL Statement
09:08
Trigger Maintenance Tasks
12:22
Work with Multiple Triggers for a Single Table
10:54
Handling Mutating Table Issues
22:16
Using the Compound Trigger
05:41