Office Productivity
Oracle
Pl/SQL
Oracle PL/SQL Fundamentals vol. I & II
4.5 (4,130 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.
21,277 students enrolled

Oracle PL/SQL Fundamentals vol. I & II

A complete introduction to PL/SQL database programming language
Bestseller
4.5 (4,130 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.
21,277 students enrolled
Created by Intellezy Trainers
Last updated 5/2020
English
English [Auto-generated], Indonesian [Auto-generated], 5 more
  • Polish [Auto-generated]
  • Portuguese [Auto-generated]
  • Romanian [Auto-generated]
  • Spanish [Auto-generated]
  • Thai [Auto-generated]
Preview this course
Oracle PL/SQL Fundamentals vol. I & II
Current price: $104.99 Original price: $149.99 Discount: 30% off
5 hours left at this price!
Buy now
30-Day Money-Back Guarantee
This course includes
  • 20 hours on-demand video
  • 7 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
  • Over 90 lectures and 20 hours of content
  • Prepare your enviornment
  • Introducing Database Program Units
  • Creating and Maintaining Packages
  • Using System-Supplied Packages
  • Creating and Maintaining Database Triggers
  • Implementing System Event Triggers
  • Work with Oracle database tools
  • Understand and work work language features
  • Work with DECLARE, BEGIN & EXCEPTION clause
  • Understand and use nested blocks
  • Use explicit cursors
Requirements
  • Familiarity with database and programming principles
Description

In this Oracle 11g PL/SQL Bundle you will receive introduction training on PL/SQL database programming language covering syntax, structure and features of the language within the context of database applications and programming. In volume II students will dive into topics such as 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
Featured review
Michael Hirun
Michael Hirun ( 69 courses, 5 reviews )
a year ago
Only completed fundamental 1. It was the typical basic topics that we all should expect to cover in any language but it was a really in-depth coverage. I really like that Tim gave a lot of tips on application based on his experiences. I'm excited to learn more advance topics in fundamental 2.
Course content
Expand all 97 lectures 19:59:18
+ – Oracle 11g PL/SQL Fundamentals I
51 lectures 09:50:45

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.

Introduction
Preview 03:06
Course Setup
Preview 37:03
Selecting the Appropriate Database Tool
30:45
Understanding PL/SQL
Preview 17:59
PL/SQL Blocks
15:19
Working with SQL Plus
Preview 11:00
DECLARE Clause Objects
16:25
PL/SQL Available Data Types
16:55
Declaring Simple Data Types and Assignments
12:16
Declaring Complex Data Types and Assignments
10:38
Declaring Complex RowTypes and Assignments
07:02
Declaring Complex Tables
07:44
Declaring Complex Records
08:12
Creating and Declaring User-Defined Types
Preview 08:48
What Can Be Included in the BEGIN Clause
07:02
Working with CHAR and VARCHAR2 Variables
07:30
Handling String Literals
07:41
Working with Numeric Variables
06:40
Working with Date Variables
06:00
Assigning and Using Boolean Variables
07:44
Using Comparison Operators
07:24
Using SQL Functions
06:11
SQL DML within PL/SQL
15:05
Using SELECT
06:32
Exceptions and Embedded SQL
11:16
Using Sequences
14:28
Logic Control and Branching
06:58
Using GOTO
Preview 05:52
Working with LOOPS
18:53
Creating and Using the Indefinite Loop
06:59
Creating and Using the Conditional Loop
08:48
Using Nested Loops
11:33
Using the If-Then-Else
18:54
Using the CASE Statement
17:43
What Are the Types of Exceptions
05:31
Trapping Exceptions
05:32
Identify Exception Details
10:57
Creating User-Defined Exceptions
10:49
Using SQLCODE and SQLERRM Objects
08:29
Understand the Implicit Cursor
14:37
Creating User-Defined Events
12:26
Understanding the Concept and Purpose of Explicit Cursors
18:10
Learn about Cursor Attributes
10:12
Using the Continue Statement
05:44
Working with Updateable Cursors
19:25
Creating and Using Cursor Parameters
14:45
FOR...LOOP Cursors
06:53
Understanding Nested Blocks
10:46
Difference between Global vs Local Objects and Exceptions
12:35
Subprograms: How They Differ from Nested Blocks
17:37
Conclusion
Preview 03:52
+ – Oracle 11g PL/SQL Fundamentals II
46 lectures 10:08:33

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.

Introduction
Preview 02:40
Install Oracle XE
10:59
SQL Developer Installation
19:47
Workstation Setup
12:14
Introducing the Database Program Unit
19:05
Creating Stored Procedures and Functions
18:44
Understanding the Parameter Specification
22:57
Executing Procedures and Functions
26:11
Calling Functions from within SQL
13:05
Handling Compilation Errors
Preview 08:26
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
What Is a Package?
10:02
Creating a Package
19:11
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
Learning to Use Cursor Variables
23:38
Weak Cursor Definitions
16:17
REFCURSOR Cursor Definition
05:13
Using Cursor Expression
13:43
Using the DBMS OUTPUT() Package
11:38
Using the UTL FILE() Package
29:36
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
07:31
Row Level Trigger Example 3
07:42
Working with the INSTEAD OF Trigger
11:00
Using Triggers within an Application
08:54
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
What Is a System Event Trigger
05:25
Defining Scope
03:43
Identifying Available System Events
12:19
Conclusion
01:38