PL_SQL Training

Course Detail
PL_SQL Training
(500 Review)

ABOUT THE COURSE

  • After completion of training program on PL_SQL , students and professionals will get the most and the best from their accounting skills.
  • PL_SQL training from JAGJIT INSTITUTE Delhi is cost-competitive.
  • Course Completion Certificate to every student and carries global recognition.
  • PL_SQL Training can be customized after analyzing the company-specific requirements
  • Industry Specific specially tailored PL_SQL training modules.
  • Highly qualified and certified trainers on PL_SQL with expertise in our instruction methods.
  • At no extra cost, the needy students can repeat the classes with prior permission.
  • For the students to get maximum benefit from the training, One-on-One attention is given to each student.
  • Well maintained Smart Labs with latest equipment where individual can flourish their practical knowledge with hands on practice.
  • To make students become well aware of the complex working scenarios in the work field, we establish strong practices in enhancing their technical skills and concepts on the subject.
  • PG Facilities available in the nearby vicinity for students coming from other states for PL_SQL Training in Delhi.
  • Our PL_SQL Course content is structured to cover all the modules within PL_SQL. From basic to advance, we give PL_SQL training in Delhi in a manner that is easy to understand.

Below is the detailed course content for PL_SQL

Introduction to PL/SQL
PL/SQL Variables 
  • Lecture 1:
    Variable Memory structure
    30 Minute
  • Lecture 2:
    Scalar datatypes
    30 Minute
  • Lecture 3:
    Scope of a variable
    30 Minute
  • Lecture 4:
    Declaring PL/SQL Variables
    30 Minute
  • Lecture 5:
    Use of Variables
    30 Minute
  • Lecture 6:
    Variable Nomenclature
    30 Minute
  • Lecture 7:
    Handling Variables in PL/SQL
    30 Minute
  • Lecture 8:
    Types of Variables
    30 Minute
  • Lecture 9:
    Guidelines for Declaring and Initializing PL/SQL Variables
    30 Minute
  • Lecture 10:
    Scalar Data Types
    30 Minute
  • Lecture 11:
    Declaring Scalar Variables
    30 Minute
  • Lecture 12:
    %TYPE Attribute
    30 Minute
  • Lecture 13:
    Boolean Variables
    30 Minute
Basic PLSQL architecture
  • Lecture 1:
    Introduction to PL/SQL
    30 Minute
  • Lecture 2:
    What is PL/SQL?
    30 Minute
  • Lecture 3:
    PL/SQL Features
    30 Minute
  • Lecture 4:
    PL/SQL Environment
    30 Minute
  • Lecture 5:
    Benefits of PL/SQL
    30 Minute
Anonymous Blocks
  • Lecture 1:
    PL/SQL Block Structure
    30 Minute
  • Lecture 2:
    PL/SQL Block Types
    30 Minute
  • Lecture 3:
    Anonymous Block
    30 Minute
  • Lecture 4:
    Sub blocks
    30 Minute
  • Lecture 5:
    Writing adhoc Programs
    30 Minute
  • Lecture 6:
    PL/SQL Block Syntax and Guidelines
    30 Minute
  • Lecture 7:
    SQL Functions in PL/SQL
    30 Minute
  • Lecture 8:
    Variable Scope and Visibility
    30 Minute
  • Lecture 9:
    Identify the Operators in PL/SQL
    30 Minute
Integrating SQL with PLSQL
  • Lecture 1:
    Integrating SQL with PLSQL & Implicit Cursors
    30 Minute
  • Lecture 2:
    SQL Statements in PL/SQL
    30 Minute
  • Lecture 3:
    SELECT Statements in PL/SQL
    30 Minute
  • Lecture 4:
    Using PL/SQL to Manipulate Data
    30 Minute
  • Lecture 5:
    Inserting, Updating and Deleting Data in PL/SQL
    30 Minute
Implicit Cursors
  • Lecture 1:
    SQL Cursor – Implicit cursor
    30 Minute
  • Lecture 2:
    Cursor Attributes for Implicit Cursors
    30 Minute
Control Structures in PLSQL
  • Lecture 1:
    Control Structures in PLSQL
    30 Minute
  • Lecture 2:
    Controlling Flow of Execution
    30 Minute
  • Lecture 3:
    IF Statement – 1st, 2nd and 3rd Form
    30 Minute
  • Lecture 4:
    CASE Statement in PL/SQL
    30 Minute
  • Lecture 5:
    Iterative Control: LOOP Statements
    30 Minute
  • Lecture 6:
    Basic Loops, WHILE Loops, FOR Loops
    30 Minute
  • Lecture 7:
    PL/SQL CONTINUE Statement
    30 Minute
Collections & Records
  • Lecture 1:
    Collections & Records
    30 Minute
  • Lecture 2:
    Records in PL/SQL
    30 Minute
  • Lecture 3:
    ROWTYPE Attribute
    30 Minute
  • Lecture 4:
    DMLs using ROWTYPE – INSERT
    30 Minute
  • Lecture 5:
    DMLs using ROWTYPE - UPDATE
    30 Minute
  • Lecture 6:
    Collections in PL/SQL
    30 Minute
  • Lecture 7:
    INDEX BY Tables or Associative Arrays
    30 Minute
  • Lecture 8:
    Nested Tables & VARRAYs
    30 Minute
  • Lecture 9:
    Methods used by Collections
    30 Minute
Explicit Cursors & Types or Cursors
  • Lecture 1:
    Controlling Explicit Cursors in PL/SQL block
    30 Minute
  • Lecture 2:
    Explicit cursor – Declaration, Open, Fetch, close
    30 Minute
  • Lecture 3:
    Explicit Cursor Attributes
    30 Minute
  • Lecture 4:
    Cursor FOR Loops
    30 Minute
  • Lecture 5:
    Parameterized Cursors
    30 Minute
Exception Handling in PLSQL
  • Lecture 1:
    Exception Handling in PLSQL
    30 Minute
  • Lecture 2:
    Understand Exceptions
    30 Minute
  • Lecture 3:
    Exception Raise
    30 Minute
  • Lecture 4:
    Exception Handling
    30 Minute
  • Lecture 5:
    Trapping Exceptions
    30 Minute
  • Lecture 6:
    Trapping Predefined Oracle Server Errors – Explicit
    30 Minute
  • Lecture 7:
    Common Oracle server Exceptions
    30 Minute
  • Lecture 8:
    Trapping Non-Predefined Oracle Server Errors
    30 Minute
  • Lecture 9:
    PRAGMA EXCEPTION_INIT
    30 Minute
  • Lecture 10:
    Functions for Trapping Exceptions
    30 Minute
  • Lecture 11:
    Trapping User-Defined Exceptions
    30 Minute
  • Lecture 12:
    Propagating Exceptions
    30 Minute
  • Lecture 13:
    RAISE_APPLICATION_ERROR
    30 Minute
Stored Procedures
  • Lecture 1:
    Writing Stored Procedures
    30 Minute
  • Lecture 2:
    PL/SQL Subprograms
    30 Minute
  • Lecture 3:
    What Are Procedures?
    30 Minute
  • Lecture 4:
    Creating Procedures
    30 Minute
  • Lecture 5:
    Parameters and Parameter Modes
    30 Minute
  • Lecture 6:
    Comparing the Parameter Modes – IN, OUT, IN OUT
    30 Minute
  • Lecture 7:
    Removing Procedures: DROP command
    30 Minute
  • Lecture 8:
    Viewing Procedure in the Data Dictionary
    30 Minute
Stored Functions
  • Lecture 1:
    Writing Stored Functions
    30 Minute
  • Lecture 2:
    Creating Functions
    30 Minute
  • Lecture 3:
    Procedures vs Functions
    30 Minute
  • Lecture 4:
    Invoking a Stored Function in PL/SQL
    30 Minute
  • Lecture 5:
    Using a Function in a SQL Expression
    30 Minute
  • Lecture 6:
    Restrictions When Calling Functions from SQL Expressions
    30 Minute
  • Lecture 7:
    Removing Functions: DROP command
    30 Minute
  • Lecture 8:
    Functions Using Data Dictionary Views
    30 Minute
Packages
  • Lecture 1:
    Writing Packages
    30 Minute
  • Lecture 2:
    Advantages of Packages
    30 Minute
  • Lecture 3:
    Components of PL/SQL Package
    30 Minute
  • Lecture 4:
    Visibility of Package component
    30 Minute
  • Lecture 5:
    Calling the Package Subprograms
    30 Minute
  • Lecture 6:
    Creating Packages without Body
    30 Minute
  • Lecture 7:
    Dropping Packages: DROP Statement
    30 Minute
  • Lecture 8:
    Viewing Packages Using the Data Dictionary
    30 Minute
Triggers
  • Lecture 1:
    Writing Triggers
    30 Minute
  • Lecture 2:
    Describe Triggers
    30 Minute
  • Lecture 3:
    Trigger Types
    30 Minute
  • Lecture 4:
    Creating Triggers
    30 Minute
  • Lecture 5:
    DML Trigger Timing and Event
    30 Minute
  • Lecture 6:
    Statement-Level Triggers vs. Row-Level Triggers
    30 Minute
  • Lecture 7:
    Trigger-Firing Sequence : Multi row Manipulation
    30 Minute
  • Lecture 8:
    Creating a DML Statement Trigger
    30 Minute
  • Lecture 9:
    Creating a DML Row Trigger
    30 Minute
  • Lecture 10:
    Using OLD and NEW Qualifiers
    30 Minute
  • Lecture 11:
    Trigger management: Enable, Disable, Drop
    30 Minute
  • Lecture 12:
    Data Dictionary Views for Trigger
    30 Minute
Dynamic SQL
  • Lecture 1:
    Native Dynamic SQL
    30 Minute
  • Lecture 2:
    Working With Dynamic SQL
    30 Minute
  • Lecture 3:
    Native Dynamic SQL (NDS)
    30 Minute
  • Lecture 4:
    EXECUTE IMMEDIATE
    30 Minute
  • Lecture 5:
    Methods for Using NDS – INTO and USING Clause
    30 Minute
  • Lecture 6:
    Dynamic SQL with DDL Statements
    30 Minute
  • Lecture 7:
    Dynamic SQL with DML Statements
    30 Minute