SQL/PLSQL TRAINING PROGRAM in Guindy, Chennai

SQL/PLSQL TRAINING PROGRAM and Development with Placement Assured in Guindy in Chennai

GENWISH Infotech Offers SQL/PLSQL Training in Chennai by Experienced SQL/PLSQL Professionals.

Duration: 80 Hrs

Training Mode: Class Room - Online – Fast Track

Training Strategy: Live Hands on Training comprise with Theory and Case Studies

Training Schedule:

Regular Class - Monday to Friday with 2 Hrs/Day

Week End Class- Saturday and Sunday with 4 Hrs/Day

Genwish Infotech Features:                                                                                                                          

Trainers from Corporate

Valid Materials [Soft/Hard Copy]

7 AM to 10 PM Lab Facility

Pleasing Environment

Pre Process to Join:                       

Initial Discussion

Free Demo Class

Training approval

Registration Process

Topics Covered

Oracle 11g : SQL                                                                               Duration : 40 Hrs.

Introduction

Writing Basic SQL SELECT Statements

Restricting and Sorting Data

Single- Row Functions

Displaying Data from Multiple Tables

Aggregating Data Using GroupFunctions

Subqueries

Producing Readable Output with iSQL *Plus

Manipulating Data

Creating and Managing Tables

Including Constraints

Creating Views

Other Database Objects

Controlling User Access

SQL Workshop

Using SET Operators

Oracle 9i Datetime Functions

Enhancements to the GROUP BY Clause

Advanced Subqueries

Hierarchical Retrival

Oracle 10g Extensions to DML and DDL Statements

Oracle 10g : Program with PL/SQL                                                          Duration : 40 Hrs.

Prerequisite : Oracle 10g SQL

Introduction to PL/SQL

Declaring Variables Writing Executable Statements

Interacting with Oracle Server

Writing Control Structures

Working with Composite Data Types

Writing Explicit Cursors

Advanced Explicit Cursor Concepts

Handling Exceptions

Creating Procedures

Creating Functions

Managing Subprograms

Creating Packages

More Package Concepts

Oracle Supplied Packages

Manipulating Large Objects

Creating Database Triggers

More Trigger Concepts

Managing Dependencies

Post Process for Placement:

Discussion about the Current Industry Expectations

Fine Tuning the Concepts thru Internal Interview

Resume Preparation

Mock Interview from External Expert

Interview Arrangement