Professional Institute

SQL/PLSQL TRAINING PROGRAM in Guindy, Chennai

0 / 5

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

 

Payment Option

Scholarship, Cash, Installment, Online Payment

Education level

Beginner, Intermediate, Professional

Education Subject

Engineering, IT

Duration

50hr

Education Type

Online Training, Classroom, Corporate, Distance Education

Study Material

Yes - Provided by Institute, Not Available

  • Person Raja
  • Address GENWISH INFO TECH
    33/26, Jawaharlal Nehru Road, Ekkattuthangal, Chennai-32.
    Land Mark: Opp. To Hyundai Show Room
    Near Ambal Nagar Bus Stop
    Above KVB ATM
    Phone: 044 48520848
    Mobile: +91-8300895622
    http://itraininglive.in/

Post New Review

Your email address will not be published. Required fields are marked *

Looking for more enquiries & visibility for your courses?