PL/SQL:

Duration: 30-35 classes Regular

Batch: Monday to Friday(1hr per day)

Fast-track Batch: as per student requirements

Advantage of PL/SQL

Generic PL/SQL block

PL/SQL variables

Control Structures

CURSORS

Introduction to Cursors

Types of Cursors - Implicit Cursors, Explicit Cursors

Cursor Attributes Cursor For Loops

Parameterised cursors

LOCKS

Types of locks

Levels of locks

Explicit Locking

Select for update statement

Using lock table statement

Releasing locks

EXCEPTION HANDLING

Introduction to Exceptions

Types of Exceptions

Oracle Predefined Exceptions

User- Defined Exceptions

Using Raise_ Application_Error

DATABASE SUBPROGRAMS

Procedures, Functions, Packages

Declaration Parameters

In

Out

Inout

Executing subprograms

DATABASE TRIGGERS

Introduction to Triggers

Trigger Structure

Types of Triggers

Developing Triggers

Instead of Triggers

 

COURSE CATALOG

DATABASES
DATA WAREHOUSING
SAP
MS DYNAMICS
JAVA
OPERATING SYSTEMS
WEB DEVELOPMENT
HYPERION
DATABASE ADMINISTRATION
SAS
.NET

COURSE ENQUIRY FORM