PL/SQL Training
Cost of training: INR 20,000
Duration: 40 Hrs

PL-SQL (Procedure Language – SQL) :

  • Introduction to PL/SQL

  • The Advantages of PL/SQL

  • PL/SQL Architecture

  • PL/SQL Data types

  • Variable and Constants

  • Using Built_in Functions

  • Conditional and Unconditional Statements

  • Simple if, if… else, nested if..else, if..else Ladder

  • Selection Case, Simple Case, GOTO Label and EXIT

  • Iterations in PL/SQL

Advanced PL/SQL

  • Procedures in PL/SQL :

    • STORED PROCEDURES

    • PROCEDURE with Parameters (IN,OUT and IN OUT)

    • POSITIONAL Notation and NAMED Notation

    • Procedure with Cursors

    • Dropping a Procedure

  • Functions in PL/SQL :

    • Difference between Procedures and Functions

    • User Defined Functions

    • Nested Functions

    • Using stored function in SQL statements

  • Packages in PL/SQL :

    • Creating PACKAGE Specification and PACKAGE Body

    • Private and Public Objects in PACKAGE

  • EXCEPTIONS in PL/SQL

  • Database Triggers in PL/SQL

  • File Input/Output

  • Implementing Object Technology

  • DBA CONCEPTS

2015-2016 www.oracle-tutor.com, All Rights Reserved

A part of the NS2 Group