About Trainer

  • 8 years of Oracle DBA experience
  • Oracle Database Certified
  • Working as a Senior Core DBA
  • Sound Technical skills
  • Teaching from 4+ years

About PL/SQL Programming

 
 
 
 
ONLINE TRAINING IN PL/SQL Programming BY OUR REALTIME/CERTIFIED PROFESSIONALS

Course Pre-requisites:

Lab setup:

  • RHEL 32/64 bit
  • Oracle 32/64 bit

Training Material:

  • Class PPT’s (Soft Copy)
  • Class recordings (optional)

PL/SQL Programming ONLINE TRAINING Course Content:

CHOOSING A SQL & PL/SQL INTERFACE

  • USING SQL DEVELOPER
  • USING SQL*PLUS
  • USING APPLICATION EXPRESS
  • USING JDEVELOPER STUDIO

LANGUAGE FEATURES

  • UNDERSTANDING PL/SQL
  • STRUCTURE OF A PL/SQL PROGRAM BLOCK
  • USING PL/SQL FROM SQL*PLUS

DECLARE CLAUSE

  • ABOUT THE DECLARE CLAUSE
  • DECLARE SIMPLE TYPES
  • DECLARE COMPLEX TYPES
  • TYPE ... TABLE
  • TYPE ... RECORD

BEGIN CLAUSE

  • ABOUT THE BEGIN CLAUSE
  • PERFORMING DATA MANIPULATION
  • LOGIC CONTROL & BRANCHING
  • LOOP
  • IF-THEN-ELSE
  • CASE

EXCEPTION CLAUSE

  • ABOUT THE EXCEPTION CLAUSE
  • ISOLATING THE SPECIFIC EXCEPTION
  • PRAGMA EXCEPTION_INIT
  • SQL%ROWCOUNT & SELECT...INTO

EXPLICIT CURSORS

  • ABOUT EXPLICIT CURSORS
  • ADVANCED CURSOR TECHNIQUES

ADVANCED PROGRAMMING: DECLARED SUBPROGRAMS

INTRODUCING DATABASE PROGRAM UNITS

  • ABOUT DATABASE PROGRAM UNITS
  • TYPES OF PL/SQL PROGRAM UNITS
  • TYPES OF STORED PROGRAM UNITS
  • ADVANTAGES OF USING STORED PROGRAM UNITS

CREATING STORED PROCEDURES & FUNCTIONS

  • ABOUT STORED PROCEDURES & FUNCTIONS
  • CREATING PROCEDURES & FUNCTIONS
  • EXECUTING PROCEDURES & FUNCTIONS

MAINTAINING STORED PROCEDURES & FUNCTIONS

  • RECOMPILING & DROPPING PROGRAMS
  • DATA DICTIONARY STORAGE
  • MANAGING DEPENDENCIES

CREATING & MAINTAINING PACKAGES

  • ABOUT PACKAGES
  • CREATING PACKAGES
  • ADVANCED PROGRAMMING TECHNIQUES
  • MAINTAINING PACKAGES

ADVANCED CURSOR TECHNIQUES

  • USING CURSOR VARIABLES
  • USING CURSOR EXPRESSIONS

USING SYSTEM-SUPPLIED PACKAGES

  • DBMS_OUTPUT()
  • UTL_FILE()

CREATING DATABASE TRIGGERS

  • ABOUT DATABASE TRIGGERS
  • STATEMENT-LEVEL TRIGGERS
  • ROW-LEVEL TRIGGERS
  • EXAMPLES OF TRIGGERS
  • INSTEAD OF TRIGGERS
  • EMPLOYING TRIGGERS WITHIN AN APPLICATION

MAINTAINING DATABASE TRIGGERS

  • CALL SYNTAX
  • TRIGGER MAINTENANCE TASKS
  • SHOW ERRORS TRIGGER
  • DROP TRIGGER
  • ALTER TRIGGER
  • HANDLING MULTIPLE TRIGGERS FOR A TABLE
  • HANDLING MUTATING TABLE ISSUES

IMPLEMENTING SYSTEM EVENT TRIGGERS

  • WHAT ARE SYSTEM EVENT TRIGGERS?
  • DEFINING THE SCOPE
  • AVAILABLE SYSTEM EVENTS
  • SYSTEM EVENT ATTRIBUTES

 
 
 
 

Testimonials

  • The fact that they have a set format of teaching, which creates a schedule for a student, and a step-by-step process that covers the entire Netezza syllabus. I can surely assure eTraining provides a great help for Netezza curriculum.
    - Shannon D.

  • The BEST I liked about the tutors in eTraining is the amount of practical knowledge these guys have and the way they bring in the same to students perspective while Teaching. Glad I took DB2 course from eTraining.
    - Rubeena Khan

  • I found classes very helpful. What you Teach is AWESOME
    - Gopal