PL/SQL by Example - Beginner to Advanced PL/SQL
4.4 (2,441 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.
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
4.4 (2,441 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.
12,263 students enrolled
Created by Amarnath Reddy
Last updated 12/2018
English
English [Auto-generated]
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
Course content
Expand all 103 lectures 05:41:26
+ Welcome...
2 lectures 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
+ 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
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