IBM CE-BASICS

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: