Mastering Plsql

  1. Home
  2. Plsql
  3. Mastering Plsql

Tags: Pl/SQL

Simplified way to learn PL/SQL

Last updated 2022-01-10 | 4.4

- Basics of PL/SQL
- Variables and Constants
- Conditional
- Looping and Sequential Statements

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

* 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

Course content

7 sections • 84 lectures

Introduction 7 lectures

Introduction to PL/SQL Preview 07: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/SQL Preview 03:27

This video discusses the architecture of PL/SQL

PL/SQL Language Elements Preview 05:26

This video discusses the PL/SQL language elements like Identifiers, Literals, Operators, Comments, Expressions and comparisons and its Datatypes.

Structure of PL/SQL Block Preview 02: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) Preview 04:03

Reading Material for Section-1 Preview 03:20

Quiz based on Section-1

Variables and Constants 7 lectures

Variables in PL/SQL Preview 06: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 Statement Preview 10:22

This video discusses the usage and demonstration of Select into Statement of PL/SQL

Constants in PL/SQL Preview 01:49

This video session discusses the concept and usage of Constants in PL/SQL.

Variable Attributes Part-1 Preview 06:34

This video session discusses the concept and usage of Variable attribute %TYPE.

Variable Attributes Part-2 Preview 08: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 Constants Preview 08:25

Multiple Choice Questions of Variables and Constants

Conditional, Looping and Sequential Statements. 8 lectures

Conditional Statements of PL/SQL Preview 09:16

This video session discusses the conditional statements of PL/SQL with its demonstration.

Simple Loop Statement of PL/SQL Preview 07:04

This video session discusses the Simple Loop Statements of PL/SQL with examples and its demonstration.

While Loop Statement of PL/SQL Preview 07: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/SQL Preview 09: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/SQL Preview 09: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 Statements Preview 08:38

Multiple Choice Questions Loops and Controls

Assignment Based on For Loop

This is assignment check the understanding of For Loop Concept

Exception Handling 13 lectures

Concept of Exception Handling and Types of Exceptions Preview 06:26

This video session discusses the concept of Exception Handling and Its Types.

Implicit Exceptions: Trapping of Predefined Oracle Server Errors Preview 12:16

This video session discusses the Implicit Exceptions: Trapping of Predefined Oracle Server Errors with lots of examples.

Demonstration of Predefined Oracle Server Errors Preview 14:53

This video session covers the Demonstration of Predefined Oracle Server Errors by using Oracle Live.

Demonstration of Trapping of Non-Predefined Oracle Server Errors Preview 08:20

This video session discusses the Demonstration of Trapping of Non-Predefined Oracle Server Errors with examples.

Explicit or User Defined Exceptions Preview 09:41

This video session discusses the concept of User-Defined Exceptions with examples.

Demonstration of Explicit or User Defined Exceptions Preview 07:04

This video session demonstrates the use of Explicit or User Defined Exceptions with example codes.

Error Trapping Functions Preview 10:47

Handing of Errors Raised in Declare Section and Propagation of Exceptions Preview 09: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 Exceptions Preview 04: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 Handling Preview 02:50

This video session discusses the problem statement for Assignment on Exception Handling.

Solution of Assignment on Exception Handling Preview 07: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 Handling Preview 12:05

Multiple Choice Questions of Exception Handling

Cursor Handling 15 lectures

Concept of Cursor Preview 03:15

Concept of Implicit Cursor Preview 07:22

This video discusses the concept of Implicit Cursor with examples in a simplified manner.

Demonstration of Implicit Cursor Preview 11:31

This video session demonstrate the usage of Implicit Cursor with example codes.

Concept of Explicit Cursor Preview 06:14

This video session discusses the concept of Explicit or User Defined Cursors.

Need and Usage of Explicit Cursor Preview 08:19

This video session discusses the need and usage of explicit cursors with example code.

Demonstration of Explicit Cursor Preview 07:04

This video session demonstrates the use of Explicit Cursors with example codes.

Cursor For Loop: Concept and Demonstration Preview 10:48

This video session discusses the concept and demonstration of Cursor For Loop with example codes.

Cursor with Parameters Preview 08: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 Parameters Preview 06:04

This video session demonstrates the usage of Cursor with Parameters with example code.

Cursor Assignment-1 Preview 01:39

Solution of Cursor Assignment-1 Preview 11:55

Cursor Assignment-2 Preview 03:52

This video session discusses the problem statements for Cursor Assignment-2.

Solution of Cursor Assignment-2 Preview 13: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 Handling Preview 09:14

Multiple Choice Questions of Cursor Handling

Sub Programs 16 lectures

Sub Programs and and Its Types Preview 06:22

This video session discusses the concept and need of Sub Programs. This video session also discusses its types.

Local Function: Concept and Usage Preview 12: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 Functions Preview 14:17

This video session covers the demonstration of local functions of PL/SQL with their example code.

Local Procedures Preview 04:15

This video session discusses the concept and syntax of Local Procedures of PL/SQL.

Stored Functions Preview 07:15

This video session discusses the concept of Stored Functions of PL/SQL and its Syntax.

Demonstration of Stored Functions Preview 14:50

This video session covers the demonstration of stored functions of PL/SQL with their example code.

Demonstration of Local Procedures Preview 11:25

Stored Procedures Preview 05:11

This video session discusses the concept, syntax, and usage of Stored Procedure of PL/SQL.

Demonstration of Stored Procedures Preview 14:50

This video session covers the Demonstration of Local Procedures of PL/SQL with example codes.

Sub Program Assignment-1 Preview 03:03

This video session discusses the problem statements for Sub Program Assignment-1.

Solution of Sub Program Assignment-1 Preview 12:51

This video session discusses the Solution of Sub Program Assignment-1 with example code and its demonstration.

Sub Program Assignment-2 Preview 04:19

This video session discusses the problem statements for Sub Program Assignment-2.

Solution Sub Program Assignment-2 Question-1 Preview 11: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-2 Preview 07: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 Procedures Preview 10:49

Multiple Choice Questions of Sub Program

Trigger 18 lectures

Concept of Trigger Preview 05:32

This video session discusses the concept and needs of the trigger.

Uses and Applications of Database Trigger Preview 13:33

This video session discusses the Uses and Applications of Database Trigger.

Types of Trigger Preview 04:09

This video session discusses 12 Types of Trigger in a simplified manner.

Before Statement Level and Row Level Trigger Preview 11:13

This video session discusses the Before Statement Level and Row Level Trigger with examples.

After Statement Level and Row Level Trigger Preview 09:29

This video session discusses the After Statement Level and Row Level Trigger with examples.

Syntax of Trigger Preview 10:59

Concept of Old and New Keywords Preview 11:47

Trigger Demonstartion Session-1 Preview 12:49

Trigger Demonstartion Session-2 Preview 10:00

Trigger Demosnatration Session-3 Preview 12:16

Raising Application Errors with Triggers Preview 10:15

Demonstartion of Raising Application Errors Preview 07:41

Trigger Assignment-1 Preview 02:48

Solution of Trigger Assignment-1 Preview 13:41

Trigger Assignment-2 Preview 03:41

Solution of Trigger Assignment-2 Preview 10:41

Reading Material for Trigger Preview 09:45

Multiple Choice Question of Trigger