Home # Events & Seminars  
 
 

Events and Seminars

   
 
Dronacharya Group of Institutions, Greater Noida
Department of Computer Science & Engineering
Training & Certification Program on ‘IBM CE-Basics of Information
Management with DB2’
November 3rd – November 7th ,2014
 
 

A One week training programon ‘IBM CE-Basics of Information Management with DB2’ was organized at Dronacharya Group of Institutions, Greater Noida from 3rd November to 7th November, 2014. Students from Computer Science & Engineering (CSE), Information Technology (IT) and Computer Sciences and Information Technology branches participated in the training program. Mr. Manoj Kumar Yadav, Assistant Professor, Department of Computer Science & Engineering coordinated the training program.

 

The training sessions were delivered by Mr. Yogesh Sharma, Sr. Trainer from Web Tek Labs Pvt. Ltd, IBM Education Delivery Partner. The proceedings of the day one of the training commenced with an inaugural session attended by Dr. (Prof.) M. S. Murali, Director DGI Greater Noida, Prof. B. L. Kaul, Registrar, Prof. Sachin Gupta, Head of Department, CSE , Prof. Divyanshu Sinha, Head of  Department, IT  DGI, Gr. Noida.

 

Prof. M. S. Murali, in his inaugural address appreciated the initiative and motivated the students to attend  the workshop with  learning attitude.

 

The First technical session on Day One covered the introductory part about the IBM CE Basics of Information Management with DB2. The trainer explained the installation of DB2, basics of command processing followed by a hands on lab session. The next technical session included discussions on Relational database concepts its sub-topics such as Information and Data Models, the Relational Model, Entity-Relationship diagrams, Types of Relationships, Mapping Entities to Tables, Relational Model Concepts, Relational Model Constraints and Normalization followed by another hands on lab session to practice the concepts.

 

The Second Day Sessions covered detailed explanation on “Getting started with DB2” including knowledge on DB2 server editions, Clients and Drivers, DB2 Express-C overview, The DB2 Command Line Processor, The DB2 Environment, Configuring DB2, Working With Scripts, Connecting to a DB2 server, Data movement utilities. A practice session followed the lecture session. In the post lunch session of the training, the students were taught Database objects with an introduction to SQL, The SELECT statement, The UPDATE, INSERT and DELETE statements. Apart from that  advanced concepts like working with JOINs was also discussed and that were followed by practice sessions.

 

The sessions on the Third Day delved deeper into the DB2 architecture and performance. “Data Concurrency and Locking” along with Transactions, Concurrency & Locking, Lock Wait, Deadlocks, DB2 security overview, Authentication, Authorization, Roles, The PUBLIC group, Granular access through views, Label-based access control were covered.

 

On Fourth Day the topics “DB2 backup and recovery” with sub-topics Backup and Recovery Overview, Database Logging, Backup, Recovery  were followed by lab sessions.

 

The sessions of the  Fifth Day covered Application Development with DB2 and Troubleshooting with extensive lab sessions. On the Fifth Day the training completed with a recapitulation of IBM-DB2 concepts and a mock preparatory test conducted by the trainer and four mock test conducted by workshop coordinator to give an insight to the students into the certification exam.

 

The well planned execution of the workshop resulted in a very high satisfaction level of the participants. All participants enhanced their knowledge base about DB2. The workshop equipped them not only with basic knowledge of DB2 but also advanced concepts leading to their eligibility for appearing in the Global Certification examination on DB2.

 

The Online certification exam for IBM-DB2 Academic Associate Certification was conducted by IBM on Dec 11th, 2014. The exam was proctored by Mr. Mayank Jha, Regional Manager (North and East), Career Education, IBM India Pvt. Ltd.

 

Out of 47 students 45 were successfully completed the certification exam and obtained the Global IBM DB2 Academic Associate Certification. The list of the certified students is as per below:

 

S.S.No

Name

Roll No

Branch/Sem

1

Abhijeet Kr. Pandey

8001

CSE/III

2

Akanksha Garg

8005

CSE/III

3

Akshay Rathore

8006

CSE/III

4

Anamika

8011

CSE/III

5

Ankur Sharma

8012

CSE/III

6

Aarti Kumari

8014

CSE/III

7

Aman Kr. Yadav

8017

CSE/III

8

Ansh Gulati

8018

CSE/III

9

Bittu

8019

CSE/III

10

Charu Taraghotra

8020

CSE/III

11

Devendra

8024

CSE/III

12

Devvrath Gupta

8025

CSE/III

13

Gunjit Sidhar

8026

CSE/III

14

Jai Prakash Kasyap

8028

CSE/III

 

 

15

Jaydeep

8030

CSE/III

16

Karan Handa

8033

CSE/III

17

Kritika Gupta

8034

CSE/III

18

Manish Mohan

8038

CSE/III

19

Manisha Jassal

8040

CSE/III

20

Novjot Singh

8045

CSE/III

21

Nikhil

8046

CSE/III

22

Pratibha Prakash

8050

CSE/III

23

Priya Malik

8051

CSE/III

24

Rahul Tiwari

8052

CSE/III

25

Rahul Kumar

8053

CSE/III

26

Rikankshi

8055

CSE/III

27

Ruchi Yadav

8057

CSE/III

28

Sagar

8059

CSE/III

29

Shivam Pandey

8063

CSE/III

30

Simran Ghai

8070

CSE/III

31

Susheel Tiwari

8073

CSE/III

32

Uday Kumar

8078

CSE/III

33

Vinay Kumar Yadav

8082

CSE/III

34

Vivek

8085

CSE/III

35

Bharti Kushwah

8090

CSE/III

36

Abhishek

8951

CSE/III

37

Aman Preet

8952

CSE/III

38

Bhawna

7016

CSE/V

39

Vaibhav Gupta

6070

CSE/VII

40

Neha Chawla

8141

IT/III

41

Lalit Chauhan

8713

CSIT/III

42

Rupinder Kaur

8715

CSIT/III

43

Sunny Snehi

7764

MCA/V

44

Sourabh Malhotra

7889

MAC/V

45

Suraj Kumar Singh

7891

MCA/V

 

     
       
       
       
       
     
     
     
       
       
       
       
       
       
   
 
   
 
 
 
Top of Page Click to view top of the page
 
 
XQT Logo site designed and developed by
Xentaqsys Technologies
Website optimised for Internet Explorer 5.0 above and 1024 *768 monitor resolution
© 2006-09 Dronacharya College of Engineering, All rights reserved