Chennai: +91 996 252 8293   +91 996 252 8294         Bangalore: +91 762 494 1772   +91 762 494 1774         info@besanttechnologies.com

DB2 Training

DB2 Training in Chennai

DB2 Training in Chennai

DB2 Training in Chennai which helps you to understand how the companies are using DB2. In the Year of 1983 IBM introduced relational Database model in Mainframe. If we want to work or interact with database means we need to know about DB2® subsystem. Our DB2 Training in Chennai is very much mixed both practical and interview point of questions.

DB2 Course Syllabus

Introduction to DB2

  • What is database and its basic types
  • Database models
    • Hierarchical
    • Network
    • RDBMS
    • Object Oriented
  • Discuss about storage group and volumes table spaces
  • Index spaces
  • Basic Information About
    • Table
    • Row
    • Column
    • Queries
    • View
    • Trigger
    • Synonyms
    • Alias
  • Discuss Physical Storage of DB2
    • DB2 objects
    • Buffer pools
  • Features of Database design and its types
  • Discuss the advantages of DB2 over VSAM
  • Discuss the features of data integrity and referential integrity

Interaction with DB2

  • Interaction with DB2 using TSO with SPUFI tool and QMF tool
  • Introduction to SQL for interacting with DB2
  • Introduction to COBOL-DB2 application program
    • Using run JCL we can pass the queries
    • With execute immediate
    • Using prepare and execute technique
    • Using dynamic SQL for running the queries
  • Discussing the compilation of COBOL-DB2 program
  • Facility of Error handling in DB2
    • Using DSNTIAR procedure approach
    • Using SQL codes
  • Discussing commit and rollback features
  • Introduction to CURSOR concept
  • Handling Null values in DB2
  • HANDLING VARCHARS
  • Locks facility
  • Error Handling
  • Error Handling – Introduction
  • SQLCA
  • DSNTIAR
  • WHENEVER
  • COMMIT
  • Rollback

DB2 Utilities

  • Data Consistency Utilities
  • CHECK Utility
  • REPAIR Utility
  • REPORT Utility
  • DIAGNOSE Utility
  • Backup and Recovery Utilities
  • COPY Utility
  • MERGECOPY Utility
  • QUIESCE Utility
  • RECOVER Utility
  • REBUILD Utility
  • REPORT RECOVERY
  • Data Organization Utilities
  • LOAD Utility
  • REORG Utility
  • Catalog Manipulation Utilities
  • CATMAINT Utility
  • MODIFY Utility
  • RUNSTATS Utility
  • STOSPACE Utility

Miscellaneous

  • DB2 Commands
  • Dynamic SQL – Introduction
  • Dynamic SQL – Types
  • When to use Dynamic SQL
  • Execute Immediate SQL
  • Non-select dynamic SQL
  • Parameter marker
  • Fixed-list select
  • Varying-list select SQL

Stored Procedure

  • Stored Procedure – Development
  • Creating Stored Procedures
  • Managing Stored Procedures
  • Executing a Stored Procedures

Besant Technologies Velachery

No.8, 11th Main road,
Vijaya nagar,
Velachery, Chennai - 600 042
Tamil Nadu, India
Landmark - Reliance Digital Showroom Opposite Street

+91-996 252 8293 / 996 252 8294

Besant Technologies BTM Layout

No. 2, Ground Floor,
29th Main Road, Kuvempu Nagar,
BTM Layout 2nd Stage, Bangalore - 560 076
Karnataka, India
Landmark - Next to OI Play School

+91-762 494 1772 / 762 494 1774

Besant Technologies Tambaram

No. 31 / 11, Govindarajan Street,
West Tambaram,
Chennai - 600 045
Tamil Nadu, India
Landmark - Behind National Theatre

+91-996 250 4283

Besant Technologies Marathahalli

No. 43/2, 2nd Floor, VMR Arcade,
Varthur Main Road, Silver Springs Layout,
Munnekollal, Marathahalli, Bengaluru - 560037
Karnataka, India
Landmark - Near Kundalahalli Gate Signal

+91-910 812 6341 / 910 812 6342

Besant Technologies OMR

No. 5/318, 2nd Floor, Sri Sowdeswari Nagar,
OMR, Okkiyam Thoraipakkam, Chennai - 600 097
Tamil Nadu, India
Landmark - Behind Okkiyampet Bus Stop, Above IBACO Ice Cream

+91-887 038 4333

Besant Technologies Rajaji Nagar

No. 309/43, JRS Ecstasy, First Floor,
59th Cross, 3rd Block, Bashyam Circle,
Rajaji Nagar, Bangalore - 560 010
Karnataka, India
Landmark - Near Bashyam Circle

+91-734 915 0004 / 734 916 0004

Besant Technologies Jaya Nagar

No. 2nd Floor,1575,11th Main Road , 4th T-Block , Pattabhirama Nagar,
Jaya Nagar,Bangalore-560041
karnataka, India
Land Mark :opposite to Shanthi Nursing Home

+91-7337837626

Quick Enquiry