SQL/PLSQL TRAINING PROGRAM in Guindy, Chennai Claim

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