Home # Events & Seminars  
 
 

Events and Seminars

   
 
Dronacharya Group of Institutions, Greater Noida
Training & Certification Program
IBM CE - Basics of Information Management with DB2
April 5th - 16th, 2014
 
 

A Two week training program on IBM CE-Basics of Information Management with DB2 was organized at Dronacharya Group of Institutions, Greater Noida during April 5th - 16th, 2014. 113 participants including 108 Students and 5 faculty members participated in this training program. Participants included students from Computer Science & Engineering (CSE), Information Technology (IT) and Electronics and Communication Engineering (ECE) branches. Mr. Manoj Kumar Yadav, Assistant Professor, Department of Computer Science & Engineering coordinated the event.

 

The training sessions were delivered by Mr. Vinod Patidar, 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, Prof. B. L. Kaul, Registrar, Prof. Ashwani Kumar, Academic Administrator, Head of Department of CSE , IT and ECE, DGI, Gr. Noida. Dr. M. S. Murali, in his inaugural address urged the students to complete the workshop with sincerity and dedication.

 

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.

 

On the Third day of the training, the students were taught Database objects with an introduction to SQL, The SELECT statement, The UPDATE, INSERT and DELETE statements. Advanced concepts like working with JOINs was also discussed followed by practice sessions.

 

The sessions on the fourth and fifth 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 day four and “DB2 backup and recovery” with sub-topics Backup and recovery overview, Database logging, Backup, Recovery followed by lab sessions were covered on the fifth day.

 

The sessions in the next three days covered application development with DB2 and troubleshooting with extensive lab sessions. The training completed on the ninth day of the workshop with a recapitulation of IBM-DB2 concepts and a mock preparatory test conducted by the trainer 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 May 1st, 2014. The exam was proctored by Mr. Mayank Jha, Regional Manager (North and East), Career Education, IBM India Pvt. Ltd.

 

61 students and 5 faculty members successfully completed the certification exam and obtained the Global IBM DB2 Academic Associate Certification. The list of the certified staff members and the students is as per below:

 

S.NO

FACULTY NAME

DEPARTMENT

1

Mr. Afzal Hussain Shahid

IT

2

Ms. Bhanu Bhardwaj

CSE

3

Mr. Manoj Kumar Yadav

CSE

4

Ms. Nidhi Gaur

ECE

5

Ms. Shalini Sharma

IT

 

 

S.NO

STUDENT NAME

DEPARTMENT

1

Aarti Tiwari

CSE

2

Aatmika Shree

CSE

3

Abhinaw Vikash

ECE

4

Abhishek Kumar

CSE

5

Nilesh  Kumar

ECE

6

Abhisht Saxena

ECE

7

Aditya Ranjan

ECE

8

Akanksha Tiwari

CSE

9

Amandeep

CSE

10

Amit Kumar Rawat

CSE

11

Anjali Aggarwal

CSE

12

Ashish Kumar Singh

CSE

 

 

S.NO

STUDENT NAME

DEPARTMENT

13

Avnish Shrey

ECE

14

Ayush Jha

CSE

15

Ayushi Sharma

IT

16

Bhavyatta Bhardwaj

IT

17

Deepakshi Sharma

CSE

18

Dhruv Sherawat

ECE

19

Gaurav Rathi

CSE

20

Himanshu Sharma

CSE

21

Juhi Malhotra

IT

22

Kapil Goel

CSE

23

Keshav Sharma

CSE

24

Kushal Bhardwaj

IT

25

Lalit Rawat

CSE

26

Litty Thomas

CSE

27

Madhvi Bhatnagar

CSE

28

Manish Kumar

ECE

29

Md. Samir Ansari

IT

30

Mohit Anand

IT

31

Nandini Kaushal

CSE

32

Naveen

IT

33

Naveen Pundir

IT

34

Neha Chauhan

ECE

35

Neha Pandit

CSE

36

Nishit Priya

IT

37

Prabhakar Kumar Gupta

ECE

38

Praveen

IT

39

Priyanka Aswal

IT

40

Priyanka Gusain

ECE

41

Puja Kumari

ECE

42

Rachna Sharma

CSE

43

Raushan Kumar

ECE

44

Ravi Bhushan Bhagat

ECE

45

Renu Pandit

CSE

46

Sadaf Noor

IT

47

Sanyam Wadhwa

IT

48

Saurabh Sharma

CSE

49

Shailendra Gupta

ECE

50

Simran

ECE

51

Sujeet Kumar

CSE

52

Sukhvinder

ECE

53

Sumit Verma

ECE

54

Suraj Yadav

CSE

55

Surbhi Bhasin

CSE

56

Suyash Gupta

IT

57

Tejender Singh Chand

CSE

58

Vishal

ECE

59

Vishal Rana

ECE

60

Vivek Raghav

CSE

61

Priyanka Bindal

CSE

 

     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
       
       
       
       
       
       
   
 
   
 
 
 
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