Description

db2 dba training in Chennai | best db2 dba training in Chennai | Training center in adyar


 


====Friendly Contact====Mr.N.Parthiban MCA, MS===9840496320/9940516384====


 


DB2 DBA is Leading Professional Training, Consulting & Development company involves in Various Level of IBM Mainframe Training Programm. This is fully managed by the Real Time Industry Professionals and classes conducted by MNCs Experienced Professionals. They provide the training in the flavour of Company Requirements and Interview oriented sessions.


 


Highlights in DB2 DBA Training:


 


  • Training handled by DBA Certified Professionals

  • Hands on Experience in Server Practicals on Z/OS

  • Hands on experinece in Live Mainframe Server

  • Work on the Real Time S/390 server with DB2 Applications

  • Training on Maintenance , Support , Enhancement Stages in Projects

  • Guidance from the Working Professionals from us and Outside MNC clients

  • Dedicated HR Team for Resume preparation,Softskills preparation, Interview Tips, Mock Interview

  • Continuous Placement Records for past 7 years

  • having more than 56 companies relationship for Placement

After Completion of Curriculum Projects and Graduation we will provide the 100 % Placement opportunities in our  Software Development Team & our MNC Clients.


 


1. DB2 Overview


 


        Introduction to DB2 for z/OS 


        An Overview of DB2 and Information management 


        DB2 Address Spaces 


                System Services Address Space


                Database Services Address Space


        2. DB2 Concepts


        DB2 data Structures 


                DB2 Tables


                DB2 indexes


                DB2 keys


                DB2 views


                DB2 schemas and schema qualifiers


                                 


           


3. Normalization to avoid redundancy 


        First normal form


        Second normal form


        Third normal form


        Fourth normal form


4. Sytem Privileges and Database privileges


 


        DB2 administrative authorities


                SYSADM            


 


 5. DB2 commands       


        DB2 and related commands like


            -START DATABASE (DB2)


            -STOP DATABASE (DB2)


            -DISPLAY DATABASE (DB2)


            -ACCESS DATABASE (DB2)


 


 6. Catalog and Directory Tables like


             Catlog Tables: 


            SYSIBM.SYSTABLES


            SYSIBM.SYSCOLUMNS


            SYSIBM.SYSDATABASE


            SYSIBM.SYSSTOGROUP


            SYSIBM.SYSTABLESPACE


                        7. DB2 Utilities


        Introduction to the DB2 utilities


        DB2 online utilities like 


            CHECK DATA


            CHECK INDEX


            COPY


            COPYTOCOPY


                      REPARI , REPORT ect .... All the Utilities ....


              8. Perofrmance Tuning


             Planning your performance strategy  


            Designing your system for performance         


                      Tuning your queries Programming for concurrency            


            Working with PLAN_TABLE using EXPLAIN statement


  9.  SQL statements


  10. Tools


            (1) BMC Suite of products 


           (2) Platinum suite of products 


           (3) IBM suite of products 


           (4) Omegamon for performance tuning 


           (5) JOB schedulers - CA-7, CONTROL-M


 


Best Regard’s


Greens Technologies


Mylapore,Adyar,Guindy  Chennai,


Contact :-


N.Parthiban


9840496320 / 9940516384,braim db2 dba chennai


db2 dba course chennai


 


 


 


 


 

More Details

Total Views:4
Reference Id:#158851
Phone Number:9840496320
Website URL:Click To Visit
Current Rating: /5 0 Vote
Copyright © 2018 |   All Rights Reserved |   tuffclassified.com |   24x7 support |   Email us : info[at]tuffclassified.com