Oracle 11g PL/SQL Fundamentals II

An introduction to the PL/SQL database programming language

4.60 (346 reviews)
Udemy
platform
English
language
Oracle
category
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

Oracle 11g PL/SQL Fundamentals II - Screenshot_01Oracle 11g PL/SQL Fundamentals II - Screenshot_02Oracle 11g PL/SQL Fundamentals II - Screenshot_03Oracle 11g PL/SQL Fundamentals II - Screenshot_04

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

Oracle 11g PL/SQL Fundamentals II - Price chart

Rating

Oracle 11g PL/SQL Fundamentals II - Ratings chart

Enrollment distribution

Oracle 11g PL/SQL Fundamentals II - Distribution chart
126134
udemy ID
11/27/2013
course created date
8/13/2020
course indexed date
Bot
course submited by