PL/SQL by Example - Beginner to Advanced PL/SQL
4.4 (268 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.
2,862 students enrolled
Wishlisted Wishlist

Please confirm that you want to add PL/SQL by Example - Beginner to Advanced PL/SQL to your Wishlist.

Add to Wishlist

PL/SQL by Example - Beginner to Advanced PL/SQL

Learn how to combine the efficiency of SQL and Procedural Language(PL) to build a powerful Application.
4.4 (268 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.
2,862 students enrolled
Created by Amarnath Reddy
Last updated 12/2016
English
Current price: $10 Original price: $200 Discount: 95% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5 hours on-demand video
  • 14 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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)
View Curriculum
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 is the target audience?
  • 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 103 Lectures Collapse All 103 Lectures 05:42:17
+
Welcome...
2 Lectures 03:15

How to make best use of the Program...
1 page
+
Software Installation
5 Lectures 12:00
Installing Oracle
04:07

Installing Java SDK
02:20

Installing SQL Developer
03:21

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


Inserting data into database
03:09

Exercise #2
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
6 More Sections
About the Instructor
Amarnath Reddy
4.6 Average rating
1,916 Reviews
15,488 Students
8 Courses
Oracle Architect

Amarnath has a Masters Degree in computer science with around 15 years of experience in the IT industry. He has successfully designed and implemented projects for clients in South Africa, India and USA. Currently his main focus is on Datawarehouse Architecture.

Amarnath is currently working for a fortune 500 company in USA and has pioneered the data architecture discipline. His Innovative and simple architectural designs have won accolades in the company.

Today, he brings leadership and technical expertise to enable customers to optimize and modernize their IT environments leveraging Business Intelligence tools, Big Data, social, mobile, and the Internet of Things.