Depple PLSQL

PLSQL Training : Step By Step For Beginners

Coming Soon

PLSQL Training Curriculum

1) Introduction of SQL

What is PL/SQL?
Advantages of Using PL/SQL
SQL vs PL/SQL
Environment Setup
Basic Syntax of PL/SQL
Hello World in PL/SQL

2) DataTypes & Variable

DataTypes in PL/SQL
Variable in PL/SQL
Variable Scope in PL/SQL

3) Constant& Comment

Constants in PL/SQL
Comments in PL/SQL

4) Conditional Statement

IF Statement
IF ELSE Statement
IF-THEN-ELSIF Statement
Case Statement

5) Looping Structure

Simple Loop
While Loop
For Loop
Nested Loop

6) Attribute in PL/SQL

Fetch Data From Table
%TYPE Attribute
%ROWTYPE Attribute

7) Cursors in PL/SQL

What is Cursor?
Implicit Cursors
Explicit Cursors
Cursor Attributes
Cursor FOR Loops
Parameterized Cursors

8) Procedure in PL/SQL

What is Stored Procedure?
Passing Parameters to Procedure
How to Declare Procedure?
How to Execute Procedure?
Drop Procedure

9) Function in PL/SQL

What is Function?
Procedure vs Function
How to Declare Function?
How to Declare Function?
Drop Function

10) Packages in PL/SQL

What is Packages?
Syntax Of Package Specification
Syntax Of Package Body
How to access the package elements?

11) Exception Handling

What is Exception ?
System-defined Exceptions
User-defined Exceptions

12) Triggers in PL/SQL

What is Trigger?
Row level Trigger
Statement level Trigger

...

Related Courses

Quick Inquiry

SUBMIT

Demo Lectures

Our Review

Average Ratings

4.9

JustDial 110 Reviews

Google 210 Reviews