Setup Menus in Admin Panel

Course Curriculum

Chapter 1: Introduction
What is PL/SQL? 00:00:00
PL/SQL Basic Syntax (Block) 00:00:00
Nested PL/SQL Block 00:00:00
Advantages Of PL/SQL 00:00:00
Chapter 2: PL/SQL Variables & Data Types
What are Variables? 00:00:00
Scalar Data Types 00:00:00
Reference Data Types 00:00:00
LOB Data Types 00:00:00
Constant Variables 00:00:00
Scope Of Variables 00:00:00
Chapter 3: Conditional Statements
Conditional Statements 00:00:00
ONLY IF STATEMENT 00:00:00
IF – ELSE 00:00:00
NESTED IF 00:00:00
ELSIF 00:00:00
CASE Statement Based On Variable 00:00:00
CASE Statement Based on Condition 00:00:00
Chapter 4: Iterative Statements
Iteration Control Statements (LOOP) 00:00:00
Simple Loop 00:00:00
While Loop 00:00:00
For Loop 00:00:00
Chapter 5: GoTo Statements
GOTO And LABELS 00:00:00
Restrictions for using Goto 00:00:00
Chapter 6: Cursors
Cursors 00:00:00
Implicit Cursor 00:00:00
Explicit Cursor 00:00:00
Cursor using FOR Loop 00:00:00
Parameterized Cursors 00:00:00
Chapter 7: Error Handling
What is an EXCEPTION? 00:00:00
Pre-Defined Exceptions 00:00:00
Unnamed system exceptions 00:00:00
User Defined Exceptions 00:00:00
Chapter 8: Record Types
Record Type In PL/SQL 00:00:00
Record Using %ROWTYPE 00:00:00
Record Using General Syntax 00:00:00
Chapter 9: Sub-Programs
Stored Procedure 00:00:00
PL/SQL Function 00:00:00
Parameters In Procedures And Functions 00:00:00
Subprogram Dependences 00:00:00
Chapter 10: Packages
What is a Package 00:00:00
Components Of A Package 00:00:00
Package Syntax 00:00:00
Package Example 00:00:00
Scope of various objects in a package 00:00:00
Advantages Of Packages 00:00:00
Chapter 11: Collections
What is a collection? 00:00:00
Collections Methods 00:00:00
VARRAYS 00:00:00
Nested Tables 00:00:00
Index By Tables or Associate Arrays 00:00:00
Differences Among Collections 00:00:00
Chapter 12: Triggers
What is a Trigger 00:00:00
ROW LEVEL TRIGGER 00:00:00
STATEMENT LEVEL TRIGGER 00:00:00
Trigger Execution Hierarchy 00:00:00
Mutating Triggers 00:00:00
TAKE THIS COURSE
  • FREE
  • UNLIMITED ACCESS

Advanced Course Search Widget

Recent Posts

  • Starting a Startup

    Lorem ipsum dolor sit amet, consectetur adipiscing elit. Duis vestibulum turpis...

X