Oracle 11g PL/SQL Fundamentals II

An introduction to the PL/SQL database programming language
4.3 (23 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
208 students enrolled
$19
$50
62% off
Take This Course
  • Lectures 46
  • Length 10.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2013 English

Course 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).

What are the requirements?

  • Familiarity with database and programming principles

What am I going to get from this course?

  • 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

What is the target audience?

  • Application designers and developers
  • Database administrators
  • Business users and non-technical senior end users

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
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.

Section 2: Preparing Your Environment
Install Oracle XE
Preview
10:59
SQL Developer Installation
Preview
19:47
Workstation Setup
Preview
12:14
Section 3: Database Program Units
Introducing the Database Program Unit
19:05
Section 4: Working with Stored Procedures and Functions
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
Handling Compilation Errors
Preview
08:26
Section 5: Maintaining Stored Procedures and Functions
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
Section 6: Creating and Maintaining Packages
What Is a Package?
10:02
Creating a Package
19:10
Package Definition Information
07:59
Advanced Programming Techniques
06:13
Using Persistent Global Objects
Preview
03:44
Including Initialization Logic
15:24
Object Oriented Support within Packages
13:51
Package Maintenance
17:54
Section 7: Advanced Cursor Techniques
Learning to Use Cursor Variables
23:38
Weak Cursor Definitions
16:17
REFCURSOR Cursor Definition
05:13
Using Cursor Expression
13:43
Section 8: Using System Supplied Packages
Using the DBMS OUTPUT() Package
11:38
Using the UTL FILE() Package
29:36
Section 9: Creating Database Triggers
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 2
Preview
07:31
Row Level Trigger Example 3
07:42
Working with the INSTEAD OF Trigger
11:00
Using Triggers within an Application
08:54
Section 10: Trigger Maintenance
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
Section 11: Working with System Event Triggers
What Is a System Event Trigger
Preview
05:25
Defining Scope
03:43
Identifying Available System Events
12:19
Section 12: Conclusion
Conclusion
01:31

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Intellezy Trainers, Computer Training Specialists

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.

Ready to start learning?
Take This Course