PL/SQL Workshop

Audience: This is an intense course that is designed to give the you hands-on exposure to PL/SQL along with a good grounding in the language.
Pre-requisites: Good knowledge of SQL 
Duration: 4 days

Course content

  • Introduction to PL/SQL
  • Declaring and using variables
  • Interacting with the Oracle Server
  • Writing Control Structures
  • Working with Composite Data Types
  • Using Explicit Cursors
  • Handling Exceptions
  • Creating Stored Procedures
  • Creating Stored Functions
  • Creating Packages
  • Creating Triggers
  • PL/SQL Tuning and Performance