Name Of The Training Institute : SRM Infotech ( srminfotech.com )

Location Of The Training Institute : Chennai

Training Offered :
Oracle 9i :
Fundamentals of Database, Overview of RDBMS, ER Model, Normalization.
Datatypes, DDL and DML Commands, Select Statements, Transactions, Constraints. Built-in Functions and User Defined Functions.

Joins and Sub queries :
Types of Joins, Multiple Subquery, Correlated Subquery.

Database Objects :
View, Sequence, Synonym, Index, Clusters Locks, Partition Tables.

PL/SQL :
PL/SQL Program Construct, PL/SQL Datatypes, VARRAYS, Nested Tables.

Cursors & Exceptions :
Implicit and Explicit Cursors, Cursor Attributes, Reference Cursors. Pre Defined, User Defined and Unhandled Exceptions.

Subprograms :
Procedures, Functions and Packages.

Managing Objects :
Managing Stored PL/SQL Objects, Debugging PL/SQL

Dynamic SQL :
Native Dynamic SQL, UTL_HTTP Package, Oracle Supplied Package.

LOBs :
Managing Internal LOBs, Securing BFILES.

Object& Collection :
Object and Collection Type, Type Inheritance, Type Hierarchy, Type Declarations, Attribute Inheritance, Method Inheritance, Multilevel Collections.

Database Triggers :
Row Level and Statement Level Triggers, Instead of Triggers.

Introduction to DBA :
Oracle Server Structure, Directory Structure, DBA Roles and Responsibilities.

Address Of The Training Institute :
SRM Infotech
#29, Dr. Nair Road,
Near Pondy Bazzar Power House Bus Stop,
T.Nagar, Chennai - 17

Website : http://www.srminfotech.com/

Email Address : training@srminfotech.com