twg-group-chennai

ORACLE TRAINING IN CHENNAI :

SYLLABUS :


  1. Introduction to Oracle Database
  2. Retrieve Data using the SQL SELECT Statement
  3. Learn to Restrict and Sort Data
  4. Usage of Single-Row Functions to Customize Output
  5. Invoke Conversion Functions and Conditional Expressions
  6. Aggregate Data Using the Group Functions
  7. Display Data From Multiple Tables Using Joins
  8. Use Sub-queries to Solve Queries
  9. The SET Operators
  10. Data Manipulation Statements
  11. Use of DDL Statements to Create and Manage Tables
  12. Other Schema Objects
  13. Control User Access
  14. Management of Schema Objects
  15. Manage Objects with Data Dictionary Views
  16. Manipulate Large Data Sets
  17. Data Management in Different Time Zones
  18. Retrieve Data Using Sub-queries
  19. Regular Expression Support
 

Oracle PlSQL Syllabus :


  1. Introduction
  2. Introduction to PL/SQL
  3. PL/SQL Identifiers
  4. Write Executable Statements
  5. Interaction with the Oracle Server
  6. Control Structures
  7. Composite Data Types
  8. Explicit Cursors
  9. Exception Handling
  10. Stored Procedures and Functions
  11. Create Stored Procedures
  12. Create Stored Functions
  13. Create Packages
  14. Packages
  15. Implement Oracle-Supplied Packages in Application Development
  16. Dynamic SQL
  17. Design Considerations for PL/SQL Code
  18. Triggers
  19. Create Compound, DDL, and Event Database Triggers
  20. The PL/SQL Compiler
  21. Manage PL/SQL Code
  22. Manage Dependencies

 

CONTACT ADDRESS :

CHENNAI BRANCH

no.5, boopathy street, virugambakkam,
virugambakkam - bus stop opposite chennai , tamil nadu , india.
tel: 044 - 420 77677, 044 - 430 72173
cell : 093845 77677
email : twggroupchennai@gmail.com

KOCHI BRANCH

Near LULU Shopping Mall
Edappally Toll Junction,
Opposite - Metro Bridge Piller No. 387,
V.P Marakkar Building,
V.P Marakkar Road,
Via - Vanitha and Vinitha Theatre
Edappally P.O, Kochi - Kerala
Contact :073580 27788 , 093810 48884,
Email : twggroupcochin@gmail.com ,
Email : twggroupchennai@gmail.com

MUMBAI BRANCH

crescent business square" No.810, kherani road,
opposite - sj studios sakinaka metro
junction, andheri (east) mumbai - 400 059.
cell : 093810 48884, 073580 27788, 093810 77677
email : twggroupmumbai@gmail.com
email : twggroupchennai@gmail.com

TRICHY BRANCH

sri gem plaza no.3, 4th floor,
sankaran pillai street, s.r.c.college road,
chathiram bus stand, trichy - 620 002
Tamil nadu , india.
contact : jenifer : 093845 77677, 93810 77677
contact : suganya : 093825 88890
email : twggroupchennai@gmail.com

COIMBATORE BRANCH

dheepam complex no.574 to 581, 100 feet road,
near g.p.signal, landmark: kalyan jewellery,
gandhipuram, coimbatore - 641 012 tamil nadu , india.
contact : jasmine : 093810 77677, 093845 77677,
contact : sandhiya : 093825 88890
email : twggroupchennai@gmail.com

VIZAG BRANCH

twg group vizag no. 8 - 12 - 1/1,
2nd floor, gayathri nilay, gokul nagar,
karur vysya bank back side opposite - holy cross church,
old gajuwaka junction, vishakapatnam - 530 026.
Andhra pradesh , india.
contact : 073580 27788, 093810 48884, 76692 48884.
email : twggroupchennai@gmail.com

BANGALORE BRANCH

No.54, 15th Main Road ,
2nd Floor,
East of Chord Road
Vijaya Nagar,
Opposite Vijaya Nagar Metro Station,
Bangalore - 560 040.
Karnataka, India.
Contact : 073580 27788 , 093810 77677
Email : twggroupchennai@gmail.com

HYDERABAD BRANCH

twg group hyderabad contact : shopia : 076679 78887 contact : office : 093810 48884
email : twggroupchennai@gmail.com

DELHI BRANCH

twg group delhi contact : shopia : 076679 78887 contact : office : 093810 48884
email : twggroupchennai@gmail.com

PUNE BRANCH

twg group pune contact : shopia : 076679 78887 contact : office : 093810 48884
email : twggroupchennai@gmail.com

TRIVANDRUM BRANCH

twg group trivandrum contact : shopia : 076679 78887 contact : office : 093810 48884
email : twggroupchennai@gmail.com

CALICUT BRANCH

twg group calicut contact : shopia : 076679 78887 contact : office : 093810 48884
email : twggroupchennai@gmail.com

TRAINING COURSES