Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Mastering PL/SQL

Name: Mastering PL/SQL
Rating: 4.3 (287 reviews)

Simplified way to learn PL/SQL

Created byParteek Bhatia

Last updated 5/2020

English

English [Auto],

What you'll learn

Basics of PL/SQL
Variables and Constants
Conditional, Looping and Sequential Statements
Exception Handling
Cursor Handling
Sub-Programs, Functions and Procedures
Triggers
DBMS:: Get chance to enroll in Simplified Approach to DBMS Course completely free after completion of this course

Course content

7 sections • 76 lectures • 10h 45m total length

Introduction to PL/SQL7:29
This video discusses the basics of PL/SQL, its need, and features. It also covers the tabular comparison of SQL and PL/SQL.
Architecture of PL/SQL3:27
This video discusses the architecture of PL/SQL
PL/SQL Language Elements5:26
This video discusses the PL/SQL language elements like Identifiers, Literals, Operators, Comments, Expressions and comparisons and its Datatypes.
Structure of PL/SQL Block2:54
This video discusses the structure of the PL/SQL block in a simplified manner.
Demonstartion of Live SQL (Software used for execution of code)4:03
Demonstrates using Oracle Live SQL, a cloud-based Oracle environment, to access a browser-based server and run SQL and PL/SQL blocks to create and query data.
Reading Material for Section-13:20
Quiz based on Section-1

Variables in PL/SQL6:01
This video session discusses the concept and usage of the variable. It highlights the different ways to assign value to variables in PL/SQL.
Select into Statement10:22
This video discusses the usage and demonstration of Select into Statement of PL/SQL
Constants in PL/SQL1:49
This video session discusses the concept and usage of Constants in PL/SQL.
Variable Attributes Part-16:34
This video session discusses the concept and usage of Variable attribute %TYPE.
Variable Attributes Part-28:33
This video session discusses the variable attribute %ROWTYPE. Its usage in the form of a demonstration has been explained in this video.
Reading Material for Variable and Constants8:25
Multiple Choice Questions of Variables and Constants

Conditional Statements of PL/SQL9:16
This video session discusses the conditional statements of PL/SQL with its demonstration.
Simple Loop Statement of PL/SQL7:04
This video session discusses the Simple Loop Statements of PL/SQL with examples and its demonstration.
While Loop Statement of PL/SQL7:20
This video session discusses the While Loop Statement of PL/SQL. It shows the demonstration of While Loop with example code.
For Loop Statement of PL/SQL9:03
This video session discusses the For Loop Statement of PL/SQL. It covers the demonstration of For Loop with examples. It also highlights the unique feature of the For Loop Statement.
Sequential Control Statements of PL/SQL9:43
This video session discusses the Sequential Control Statements of PL/SQL. This covers the GOTO statement and NULL statement of PL/SQL. This video also shows the demonstration of these statements with example code.
Reading Material for Loops and Statements8:38
Multiple Choice Questions Loops and Controls
Assignment Based on For Loop

Concept of Exception Handling and Types of Exceptions6:26
This video session discusses the concept of Exception Handling and Its Types.
Implicit Exceptions: Trapping of Predefined Oracle Server Errors12:16
This video session discusses the Implicit Exceptions: Trapping of Predefined Oracle Server Errors with lots of examples.
Demonstration of Predefined Oracle Server Errors14:53
This video session covers the Demonstration of Predefined Oracle Server Errors by using Oracle Live.
Demonstration of Trapping of Non-Predefined Oracle Server Errors8:20
This video session discusses the Demonstration of Trapping of Non-Predefined Oracle Server Errors with examples.
Explicit or User Defined Exceptions9:41
This video session discusses the concept of User-Defined Exceptions with examples.
Demonstration of Explicit or User Defined Exceptions7:04
This video session demonstrates the use of Explicit or User Defined Exceptions with example codes.
Error Trapping Functions10:47
Handing of Errors Raised in Declare Section and Propagation of Exceptions9:30
This video session discusses the Handing of Errors Raised in Declare Section and Propagation of Exceptions with example code. The demonstration of this concept has also been covered in this video session.
Re-raising of Exceptions4:41
This video session the need and concept of Re-raising of Exceptions. The demonstration of the example code for Re-raising of Exceptions is also covered in this video session.
Assignment on Exception Handling2:50
This video session discusses the problem statement for Assignment on Exception Handling.
Solution of Assignment on Exception Handling7:45
This video session discusses the Solution of Assignment on Exception Handling. The demonstration of the solution to the problem statement has been covered in this video session.
Reading Material for Exceptional Handling12:05
Multiple Choice Questions of Exception Handling

Concept of Cursor3:15
Explore the concept of cursor in SQL, examining how Oracle uses an internal memory area to execute and store results of SQL statements, and differentiate implicit and explicit cursors.
Concept of Implicit Cursor7:22
This video discusses the concept of Implicit Cursor with examples in a simplified manner.
Demonstration of Implicit Cursor11:31
This video session demonstrate the usage of Implicit Cursor with example codes.
Concept of Explicit Cursor6:14
This video session discusses the concept of Explicit or User Defined Cursors.
Need and Usage of Explicit Cursor8:19
This video session discusses the need and usage of explicit cursors with example code.
Demonstration of Explicit Cursor7:04
This video session demonstrates the use of Explicit Cursors with example codes.
Cursor For Loop: Concept and Demonstration10:48
This video session discusses the concept and demonstration of Cursor For Loop with example codes.
Cursor with Parameters8:37
This video session discusses the concept and Usage of Cursor with Parameters for simple explicit cursor and Cursor For Loop with examples.
Demonstration of Cursor with Parameters6:04
This video session demonstrates the usage of Cursor with Parameters with example code.
Cursor Assignment-11:39
Solution of Cursor Assignment-111:55
Cursor Assignment-23:52
This video session discusses the problem statements for Cursor Assignment-2.
Solution of Cursor Assignment-213:02
This video session discusses the PL/SQL code for Cursor Assignment-2. The demonstration of this code is given in this video session.
Reading Material for Cursor Handling9:14
Multiple Choice Questions of Cursor Handling

Sub Programs and and Its Types6:22
This video session discusses the concept and need of Sub Programs. This video session also discusses its types.
Local Function: Concept and Usage12:45
This video discusses the concept and usage of local functions with examples. This video session also demonstrates the use of the local function.
Demonstration of Local Functions14:17
This video session covers the demonstration of local functions of PL/SQL with their example code.
Local Procedures4:15
This video session discusses the concept and syntax of Local Procedures of PL/SQL.
Stored Functions7:15
This video session discusses the concept of Stored Functions of PL/SQL and its Syntax.
Demonstration of Stored Functions14:50
This video session covers the demonstration of stored functions of PL/SQL with their example code.
Demonstration of Local Procedures11:25
Demonstrate pl/sql local procedures by computing addition, subtraction, multiplication, and division on two numbers, and update employee salaries with a second procedure.
Stored Procedures5:11
This video session discusses the concept, syntax, and usage of Stored Procedure of PL/SQL.
Demonstration of Stored Procedures14:50
This video session covers the Demonstration of Local Procedures of PL/SQL with example codes.
Sub Program Assignment-13:03
This video session discusses the problem statements for Sub Program Assignment-1.
Solution of Sub Program Assignment-112:51
This video session discusses the Solution of Sub Program Assignment-1 with example code and its demonstration.
Sub Program Assignment-24:19
This video session discusses the problem statements for Sub Program Assignment-2.
Solution Sub Program Assignment-2 Question-111:11
This video session discusses the solution for Sub Program Assignment-2 Question-1. It also demonstrates its code.
Solution of Sub Program Assignment-2 Question-27:45
This video session discusses the Solution Sub Program Assignment-2 Question 2. It also shows the demonstration of code.
Reading Material for Sub Programs, Functions and Procedures10:49
Multiple Choice Questions of Sub Program

Concept of Trigger5:32
This video session discusses the concept and needs of the trigger.
Uses and Applications of Database Trigger13:33
This video session discusses the Uses and Applications of Database Trigger.
Types of Trigger4:09
This video session discusses 12 Types of Trigger in a simplified manner.
Before Statement Level and Row Level Trigger11:13
This video session discusses the Before Statement Level and Row Level Trigger with examples.
After Statement Level and Row Level Trigger9:29
This video session discusses the After Statement Level and Row Level Trigger with examples.
Syntax of Trigger10:59
Learn the syntax of PL/SQL triggers, including create or replace trigger, before/after timing, insert/update/delete events, row-level versus statement-level, and referencing old and new values.
Concept of Old and New Keywords11:47
Explore how triggers access old and new column values using old and new keywords, and reference them as previous and latest in update, insert, and delete operations.
Trigger Demonstartion Session-112:49
Demonstrates a before insert or update trigger on the implied table to convert e_name to uppercase for each row using new.e_name and the upper function.
Trigger Demonstartion Session-210:00
Trigger Demosnatration Session-312:16
Create a row-level after trigger on the table to record each insert, update, or delete in the audit table, capturing the e number, operation name, and date of operation.
Raising Application Errors with Triggers10:15
Learn how to raise application errors with a before trigger that blocks inserts, updates, or deletes on Sunday using raise_application_error with a negative error number.
Demonstartion of Raising Application Errors7:41
Trigger Assignment-12:48
Solution of Trigger Assignment-113:41
Enforce primary key constraint on m table e_number by implementing a before insert or update trigger that ensures non-null and unique values using new.e_number and raise_application_error when violated.
Trigger Assignment-23:41
Solution of Trigger Assignment-210:41
Reading Material for Trigger9:45
Multiple Choice Question of Trigger

Requirements

Zero prior technical experience is required! All you need is a passion to learn and experiement new things.

Description

Do words like Cursor, Function, Procedure and Trigger sound confusing to you? Have you been looking for a course that teaches you all the basics of PL/SQL in a fun relaxed manner? If so then you are going to find this course absolutely perfect for you.

This course has been selected in the list of Top 2% courses by CourseMarks

There is a growing demand for database experts all over the world. And this course is intended to fill this gap. This course on PL/SQL has been specially designed to better equip the learners for their academic and professional career.

This course is aimed at beginners, and it will guide you on a wonderful journey to transform you from naïve to expert of PL/SQL. In this course, you'll learn the PL/SQL using Oracle, i.e., the most widely used Database Software in the world.

In this course you will learn how to use PL/SQL statements to implement business logic with the use of Cursors, Procedures, Functions and Triggers. All these concepts are covered through lot of examples to make the learning fun and exciting. The main strength of the course is explanation with the practical examples so that learners can grasp the contents easily.

Overview of Course Contents:

Section-1: Basics of PL/SQL

· Introduction to PL/SQL

· Architecture of PL/SQL

· PL/SQL Language Elements

· Structure of PL/SQL Block

Section-2: Variables and Constants

· Variables in PL/SQL

· Select into Statement of PL/SQL

· Constants in PL/SQL

· Variable Attributes

Section-3: Conditional, Looping and Sequential Statements

· Conditional Statements

· Simple Loop

· While Loop

· For Loop

· Sequential Control

· Assignments and Its Solution

Section-4: Exception Handling

· Major strengths of this course is as follows:

· Types of Exceptions

· Handling of Predefined and Non-Predefined Oracle Server Errors

· Explicit Exceptions

· Error Trapping Functions

· Exceptions raised in Declare Section

· Propagation of Exceptions

· Re-raising of Exceptions

· Demonstrations

· Assignment and Its Solution

Section-5: Cursor Handling

· Concept of Cursor

· Implicit Cursor

· Explicit Cursor

· Demonstrations

· Cursor For Loop

· Cursor with Parameters

· Cursor Assignments and Its Solutions

Section-6: Sub-Programs, Functions and Procedures

· Sub Programs & Its Types

· Local Functions

· Stored Functions

· Demonstrations

· Local Procedures

· Stored Procedures

· Assignments & Its Solutions

Section 7: Trigger

· Concept of Trigger

· Uses and Applications of Trigger

· Types of Trigger

· Before Statement & Row Level Trigger

· After Statement & Row Level Trigger

· Syntax of Trigger

· Old and New Keywords

· Raising Application Errors

· Assignments & Its Solutions

Strengths of Course

· More than 9 Hours of Video Contents

· More than 70 Video Sessions

· Enough Reading Material to Brain Map the Concepts

· Quizzes after each section to check your progress

· Every Section has Assignments to have learning by doing pedagogy

· Excellent course to prepare for DBMS

· Excellent way to become expert of PL/SQL before placement and Interviews

Who this course is for:

Anyone who is interested in learning more about PL/SQL.
Students taking DBMS Course
Professionals working in the area of databases
Students preparing for placements & Interviews
Students preparing for competitive exams

Mastering PL/SQL

What you'll learn

Explore related topics

Course content

Introduction6 lectures • 27min

Variables and Constants6 lectures • 42min

Conditional, Looping and Sequential Statements.6 lectures • 51min

Exception Handling12 lectures • 1hr 46min

Cursor Handling14 lectures • 1hr 49min

Sub Programs15 lectures • 2hr 21min

Trigger17 lectures • 2hr 40min

Requirements

Description

Who this course is for: