PL/SQL by Example - Beginner to Advanced PL/SQL
12,263 students enrolled
PL/SQL by Example - Beginner to Advanced PL/SQL
Using PL/SQL learn how to combine the efficiency of SQL & Procedural Language(PL) to build a powerful PL/SQL Application
12,263 students enrolled
Current price: $139.99
Original price: $199.99
Discount:
30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
- 5 hours on-demand video
- 18 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
- Declare PL/SQL Variables
- Conditionally control code flow (loops, control structures)
- Use some of the Oracle supplied PL/SQL packages to generate screen output
- Create anonymous PL/SQL blocks, functions and procedures
- Use PL/SQL packages to group and contain related constructs
- Catch run time errors using Exceptions
- Perform Data processing using Records and Cursors
- Manage data using Collections
- Create triggers to solve business challenges
- Peform Bulk Processing to improve performance
- Execute SQL using Dynamic SQL
- Pipelining the data as it is processed
- Working with Large Objects (LOB's)
Requirements
- SQL Knowledge is needed and is a must!!!
Description
Learn to become a PL/SQL developer in just four weeks.
This fast, easy and effective course will take you from zero PL/SQL writing skills to being able to write efficient programs to process data.
PL/SQL is the Oracle Procedural Language extension of SQL. A PL/SQL program can have both SQL statements and procedural statements. In the PL/SQL program, the SQL statements are used to access sets of data stored in a database, while the procedural statements are used to process individual piece of data and control the program flow.
In this course participants will learn
- Describe the features and syntax of PL/SQL
- Design PL/SQL anonymous blocks that execute efficiently
- Use the Oracle supplied PL/SQL packages to generate screen output
- Create and debug Stored Procedures and Functions
- Design PL/SQL packages to group related constructs
- Use PL/SQL programming constructs and conditionally control code flow
- Create overloaded package subprograms for more flexibility
- Handle runtime errors using Exceptions
- Writing manageable code using Records
- Storing and processing data using Collections
- Processing data using Implicit and Explicit Cursors
Softwares used
- Oracle Database 11g
- SQL Developer
Who this course is for:
- This PL/SQL course is meant for students who want to learn Procedure Language to control SQL Statements.
- This course is not for you if you're looking to learn more advanced concepts of PL/SQL
Featured review
Kyle Bashy
(
187 courses,
26 reviews
)
a year ago
Very good course. I wish I could have the slides to print and study on my own. Also, I wish there are transcripts of the live system demo so I am able to copy and pass instead of writing them from the screen to run them myself.
Overall a very good course and by far the best I had so far.
Course content
Expand all
103 lectures
05:41:26
+
–
Welcome...
2 lectures
03:15
Preview
03:15
How to make best use of the Program...
1 page
+
–
Software Installation
5 lectures
11:10
Installing Oracle
03:08
Installing Java SDK
02:00
Installing SQL Developer
03:50
Running scripts necessary for the course
02:12
Scripts for our Lab Exercises
4 pages
+
–
PL/SQL Basics
12 lectures
29:00
What is PL/SQL
02:59
PL/SQL Advantages
02:34
PL/SQL Structure
01:51
First Example
01:22
Declaring Variables
05:03
Comments in PL/SQL
01:44
Scope of Variables
01:54
IF then ELSE statement
05:16
CASE Statemet
01:58
WHILE Loop
02:10
FOR Loop
02:09
Exercise #1
3 pages
+
–
Processing Data via PL/SQL
4 lectures
09:39
+
–
PL/SQL Blocks
9 lectures
22:58
Anonymous Blocks
02:46
What are Procedures?
03:07
Creating a Procedure
02:35
Calling a Procedure
03:16
Procedure with OUT Mode
02:54
Procedure with IN OUT Mode
02:17
What are Functions?
03:32
Calling a Function
02:31
Exercise #3
4 pages
+
–
Exceptions
5 lectures
14:24
Preview
02:46
Exceptions Example
08:26
User Defined Exceptions
03:12
System Defined Exceptions list
2 pages
Exercise #4
5 pages
+
–
Packages
5 lectures
13:22
What are Packages
04:01
Package Specification
04:11
Package Body
03:36
Executing sub programs present in Packages
01:34
Exercise #5
4 pages
+
–
Working with Records
9 lectures
20:18
What are Records?
02:27
Records Example
03:44
Working with Record data
03:51
Passing Records as parameters
01:59
Inserting data using Records
02:05
Updating data using Records
02:19
User defined Record Types
01:25
User defined Record Example
02:28
Exercise #6
5 pages
+
–
Cursors
10 lectures
26:51
What are Cursors?
01:50
Implicit Cursor
04:37
Explicit Cursor
01:21
Retrieving 1 row using Explicit Cursor
03:11
Retrieving more than 1 row using Explicit Cursor
02:39
Using Records in Cursors
02:42
Cursor FOR Loop
03:42
Cursor Variable and Reference Cursor
05:48
Exceptions for Cursors
01:01
Exercise #7
4 pages
+
–
Collections
9 lectures
24:26
What are Collections
01:55
Collection Terminology
01:34
Associative Arrays
04:21
Nested Tables
05:17
What are VARRAYS
02:48
Collection Methods
02:34
MULTISET Operators
04:06
Collections Summary
01:51
Exercise #8
4 pages