Looking for PL/SQL Training in Ahmedabad?

Course: PL/SQL

(1) Introduction to PL/SQL (no of lecture – 0.5)

  • Introduction
  • The PL/SQL Execution Environment
  • PL/SQL

(2) More on PL/SQL (no of lecture – 0.5)

  • Oracle Transactions
  • Processing a PL/SQL Block

(3) Improving on PL/SQL (no of lecture – 0.5)

  • Concurrency Control in Oracle
  • Locks
  • Error Handling in PL/SQL
  • Oracle's Named Exception Handlers

(4) Database Objects (no of lecture – 3)

  • Stored Procedures and Functions
  • Advantages of using a procedure or function
  • Procedures versus Functions
  • Syntax for Creating Stored Procedure or Function
  • Database Triggers
  • Types of Triggers
  • Deleting a Triggers