PL SQL (Advance)

Scope of PL SQL (Data Modelling + Dashboard)

PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Oracle Database included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces.

What will it cover in PL SQL?

Introduction to PL/SQL
Benefits of PL/SQL
Structure of Block
Types of PL/SQL Blocks
  • Named Block
  • Unnamed or Anonymous block

Writing Control structures
  • Conditional Controls
  • Iterative Controls

Variable and Constant
  • Scalar data types
  • Variable (%row, %row type)

  • Explicit Cursor
  • Implicit Cursor
  • Cursor Attributes
  • Cursor and loop

  • Types of Exception
    • Pre-defined
    • Non-Predefined
    • User Defined

Error Trapping Functions
  • Sqlcode
  • Sql Errm

  • Creating Procedures
  • Procedure Parameter
  • Procedure Mode
  • Testing Procedure from anonymous block

  • Creating Function
  • Difference ways of calling a function

  • Defining and Using Packages
  • Package Specification
  • Package Body
  • Support polymorphism and Improve Performance

  • Trigger Types
  • Trigger Event
  • Trigger Syntax
  • Compilation of Database Triggers
  • Alter Trigger enable/disable
  • Drop trigger

Advance PL/SQL
  • Working with Mutating Error

Additional features

  • We will provide you all kind of study material related to this Programme
  • You will also get video of the class which you attended; you can grab that in you Pan Drive or any storage device. So the content of the class remain with you for life time.
  • You can Attend your class by staying anywhere in the world through video conferencing.
  • Life time support / Assistance from our side
  • There will be provision of demo class as well.
  • Assistance in searching the Job.
  • Small size batches.

query button