Four days Certification Workshop on IBM DB2 Fundamentals (302A), Date: 24^th to 27^th August 2013

Shrimad Rajchandra Institute of Management and Computer Application had organized 4 days DB2 - 9 Fundamentals (302A) Certification Workshop during 24-27 August 2013. The objective of the certification workshop was to provide an exposure to current trends in IT Industry, through IBM Academic Initiative. As part of IBM Academic Initiative, total 96 Students and 8 faculties benefited through this training program.

The objective behind the training is to polish student's skill before they become part of the industry. During the four days, participants got in-depth knowledge of IBM's flagship Relational Database Product DB2.

Day 1 (24^th August 2013)

Mr. Amish Patel explained the various levels of DB2 Certification Examination and its importance. Initial discussion had spread awareness about various industry certifications among students. He started with the first topic "The Relational Model", Comparison of various models and in-depth discussion on relational model was carried out in first session. In the second session he explained various DB2 fundamentals and Data Studio. In the third session he explained working with databases and various database objects. In the last session Mr. Amish Patel introduced Structured Query Language. On first day students performed hands on labs on IBM Data Studio and working with databases and various database objects.

Day 2 (25^th August 2013)

On second day Ms. Jikitsha Sheth started with revision of topics covered on first day. First session was conducted on Introduction to SQL and Database Objects, and gave some query based Exercises on tables to the students on concepts like constraints, join, group by, having clause, etc. Second session was conducted on database transactions and concurrency; she explained basic concepts and importance of transaction, various locks and isolation levels supported by DB2. On second day students completed hands on labs of concurrency, queries, etc.

Day 3 (26^th August 2013)

On 3rd day Ms. Priti Prajapati started with revision of topics covered on second day. In the first session she explained DB2 backup and recovery functionality. On second day students completed hands on labs of backup and recovery. In the second session Ms. Chetna Tailor has discussed about Troubleshooting. In third session Ms. Jikitsha Sheth discussed about DB2 programming fundamentals. She explained overall approach of DB2 programming and how to work with embedded SQL.

Day 4(27^th August 2013)

On forth day Mr. Dharmendra Bhatti had explained how to implement security in DB2, he talked about authentication and authorization. Further he also explained how to authorize using concepts of authorities and privileges. In second session Mr. Dharmendra Bhatti explained DB2 PureXML, he discussed what is XML, its importance, well-formed verses valid XML documents, XPATH, XQuery, SQL/XML, etc. On the last day students had performed hands on lab of DB2 pure XML and programming fundamental and DB2 Security.

During the four days training session all the students enjoyed the lectures and lab sessions very much. Student got the conceptual and practical knowledge with great enthusiasm. Participants got knowledge in depth and simultaneously shaped up for certification examination.

Four days Certification Workshop on IBM Rational Team Concert V3.0, Date: 24^th to 27^th August 2013

Shrimad Rajchandra Institute of Management and Computer Application had organized 4 days IBM Rational Team Concert V3.0 Certification Workshop from 24th August, 2013 to 27th August, 2013. The 4 days certification workshop was conducted by Mr. Vinod Patidar and Mr. Yogesh Sharma. Total 75 students and 9 faculty members attended this certification workshop.

Day 1 (24^th August 2013)

Mr. Vinod Patidar explained IBM RTC Certification Examination and its importance. He started by explaining the meaning of "Rational" as well as importance of "Team work". He explained Software Development Life Cycle (SDLC) phases such as Planning, Project Initiation, Feasibility study and Requirement analysis, Design, Coding, Testing, Deployment and Maintenance. He provided detailed explanation on various SDLC models such as Waterfall, Iteration, Rational Unified Process (RUP) and Agile. Also discuss in which situation which model is suitable. He provided introduction of Jazz as well as practically shown Jazz server installation. In this session students performed hands on Jazz server installation in lab.

Day 2 (25^th August 2013)

On second day Mr. Vinod Patidar started with summary of topics covered on first day. He started the session with discussion on how the traditional software development process is different from agile methodology. He told students that Rational Team Concert supports both traditional and agile planning methodologies. He discussed the meaning of project related terminology such as artifacts, deliverable, phase, iteration, planning, and project lifecycle. Also gave an importance of stakeholders in project. He explained best practices for project planning. Gave detailed explanation on project planning methodologies in which he has discussed traditional approach, iterative approach and agile approach as well as how these approaches are differ. In traditional approach, he explained phases such as Requirements, Design, Implementation, Verification and Maintenance. In iterative approach, he explained phases such as Inception, Elaboration, Construction and Transition. In this session students completed hands on project creation and planning in lab.

Day 3 (26^th August 2013)

On third day Mr. Vinod Patidar started with revision of topics covered on second day. He explained in detail of agile approach and fundamental of Scrum as the agile process. He gave clarity about the concept of story points, prioritized requirements, initial scheduling and scrum process. He provided a detailed explanation on process templates with iteration structure, roles, permissions, work item types and queries. He explained types of process templates such as formal project management process template and scrum template.

Day 4 (27^th August 2013)

Mr. Vinod Patidar covered project area related basic terminologies such as repository, project area, team area, work item category, timeline, iteration etc. He provided a detailed explanation on project area elements such as identity of the project area, access control, process and project area configuration, roles for project and team members, project members and administrators, team area and team members, work item categories, releases, project timeline and iterations. In this session students completed hands on setting up a project area in lab. At last he has given some exercises to the students and solved whatever problems raised by students. Also discusses few sample questions with students to prepare for certification examination.

Mr. Yogesh Sharma has played a vital role during training session. He was always with attendees to solve their hands on lab related problems.

During the 4 days certification workshop, all attendees got conceptual and practical knowledge with great enthusiasm.

100% Result in IBM Certified Associate System Administrator Lotus Notes and Domino 8 (LOT-847) Certification Examination, Date: 01^st April 2011

SRIMCA has organized four Days Certification Training Program on IBM Certified Associate System Administrator Lotus Notes and Domino 8 Certification (LOT-847) from 11-14 March 2011.

The certification examination was conducted on 01st April 2011. Mr. Sami Shaikh from IBM has acted as proctor of this examination. Total 57 Students and 3 faculty members appeared in the examination and secured 100% result. Faculties/Students who have achieved this IBM certificate are:

Faculty members

1. Mr. DHARMENDRA G. BHATTI
2. Dr. LALBIHARI BARIK
3. Ms. CHETANA TAILOR

MCA 4th Semester Students

MCA 2nd Semester Students

AGRAWAL MADANMOHAN HARIVALLABH BARAD VAIBHAVIKUNVARBA KANAKSI BHAVSAR MAYUR MUKESHBHAI CHAUDHARI DIPIKA NAVINBHAI DESAI AMI KALPESHBHAI DHIMMAR PANNA HASMUKHBHAI JOLIYA CHANDUBHAI BHAKABHAI MAHAJAN NISHTHA ARVINDKUMAR MAHIDA ARTIBEN KAMLESHSINH MAROLIA MAYURKUMAR HARENDRAKUM NAIK PANKITABAHEN BHARATBHAI PANCHAL NIKITABEN KANTIBHAI PRAJAPATI DARSHAN KISHORKUMAR PAREKH AMITKUMAR KISHORBHAI PARMAR KRUNALKUMAR KANTIBHAI PATEL BHAVESHKUMAR BALDEVBHAI PATEL BHUMI BALVANTBHAI PATEL HIRENKUMAR HASMUKHBHAI PATEL KAMINIBEN PRAKASHBHAI PATEL KAUSHIK KUMAR PRAVINLAL PATEL KHUSHBU VINODBHAI PATEL KHUSHBUBEN YOGESHBHAI PATEL NEELAMBAHEN SUMANBHAI PATEL MITUL RAJENDRAKUMAR PATEL ROMABEN ASHOKBHAI PATEL RUTU NARESHBHAI PATEL SONAM VINODBHAI PATEL TANUJKUMAR BHAVANBHAI PATELVRUNDA DILIPBHAI PRAJAPATI BHAVIN MAHENDRABHAI PRAJAPATI HIRALKUMARI DIPAKBHA RUPAVATIYA BIPIN LALJIBHAI SHAH MEGHAL JANAKKUMAR SHARMA PUJABAHEN RAMCHARITAR SHARMA SONAL VINODBHAI SHEKH MUBASHSHIRAHBANU MOHAMME SMART VAIDEHI KEYUR SHETA PRADIPKUMAR GORDHANBHAI DIVYA NANUBHAI SIYODIA GODHWANI POONAM BHAGWANDAS THAKOR HETVI JAYESHBHAI PATEL KSHITI BANKIMCHANDRA

AHIR BHAVINI PRAVINBHAI CHOKHAWALA NEEV VIJAYKUMAR DESAI NIRAV JASAVANTRAI HIRPARA KAJALBEN JAGDISHBHAI PANCHAL PARESHKUMAR DASHARATHBHAI PANDYA MANISHKUMAR DHANESHWARBHAI PATEL HEMANSKUMAR PRADIPBHAI PATEL VARUN KIRITBHAI PATEL MANOJKUMAR BHARATBHAI PATEL RIKESH KISHORBHAI SANGHANI MITALBEN PARESHBHAI SHAH SURBHI NAVRATANMAL TALAVIYA DIPAKKUMAR NANJIBHAI TAMBAKHE PRACHI ANILBHAI VANI RUSALI MURLIDHAR

Three days Certification Workshop on IBM DB2 Fundamentals (302), Date: 22^nd to 24^th March 2011

Shrimad Rajchandra Institute of Management and Computer Application has organized 3 days DB2 - 9 Fundamentals (302) Certification Workshop during 22-24 March 2011. The objective of the certification workshop is to provide an exposure to current trends in IT Industry, through IBM Academic Initiative. The 3 days certification workshop was conducted by Mr. Dharmendra Bhatti, Associate Professor, SRIMCA. As part of IBM Academic Initiative, total 59 Students benefited through this training program.

The certification workshop was an effort to make students industry ready. During the three days, participants got in-depth knowledge of IBM's flagship Relational Database Product DB2.

Day 1 (22nd March 2011)

Mr. Dharmendra Bhatti has explained the various levels of DB2 Certification Examination and its importance. Initial discussion has spread awareness about various industry certifications among students. He has started with the first topic "The Relational Model". Comparison of various models and in-depth discussion on relational model was carried out in first session. In the second session Mr. Dharmendra has explain various DB2 fundamentals and Data Studio. In the third session trainer has explain working with databases and various database objects. In the last session Mr. Dharmendra has introduced Structured Query Language. On first day students performed hands on labs on IBM Data Studio and working with databases and various database objects.

Day 2 (23rd March 2011)

On second day Mr. Dharmendra has started with revision of topics covered on first day. First session was conducted on database transactions and concurrency. He has explained basic concepts and importance of transaction, various locks and isolation levels supported by DB2. In discussion of deadlock trainer has invited two students on the stage and demonstrated how deadlock occurs and its consequences. In the second session Mr. Dharmendra has explain how to implement security in DB2. He has talked about authentication and authorization. Further he also explained how to authorize using concepts of authorities and privileges. In the last session trainer has explained DB2 backup and recovery functionality. On second day students completed hands on labs of concurrency, security, backup and recovery.

Day 3 (24th March 2011)

On last day Mr. Dharmendra has started with revision of topics covered on second day. In the first session he explained DB2 PureXML. He discussed what is XML, its importance, welformed verses valid XML documents, XPATH, XQuery, SQL/XML etc. In the second session Mr. Dharmendra has discusses about DB2 programming fundamentals. He explained overall approach of DB2 programming and how to work with embedded SQL. In the third session trainer has discussed about certification process. All the participants have completed registration on http://ibt.prometric.com/ibm. Students were very curious about certification examination. Trainer has satisfied their all queries related to examination. On the last day students have performed hands on lab of DB2 pure XML and programming fundamentals.

During the three days training session all the students enjoyed the lectures and lab sessions very much. Student got the conceptual and practical knowledge with great enthusiasm. Participants got knowledge in depth and simultaneously shaped up for certification examination.

Four days Training Program on IBM Lotus Notes Domino 8 System Admin Operating Fundamentals(LOT-847), Date: 11^{th to 14th} March 2011

Shrimad Rajchandra Institute of Management and Computer Application has organized 4 days IBM Lotus Notes Domino 8 System Admin Operating Fundamentals (LOT-847) training program during 11-14 March 2011. The objective of the training program is to provide an exposure to IBM Lotus Notes Domino System Administration through IBM Academic Initiative.

The 4 days training program was conducted by the corporate trainers Mr. Kunal Bhagat, Webtek Labs Pvt Ltd, New Delhi. As part of IBM Academic Initiative, total 65 Students and 3 faculty members benefited through this training program.

The training program has shapeup students for the role of system admin. During the four days, participants got in-depth knowledge of IBM Lotus Notes Domino System Administration.

Day 1 (11th March 2011)

Mr. Dharmendra Bhatti, co-ordinator of the training program, delivered his welcome address. He has welcome Mr. Kunal with flowers and invited to start the training. Mr. Kunal was also greeted with flowers by IBM Student Ambassador Mr. Hiren Patel. Mr. Kunal explained following points: Introduction to IBM Lotus Notes Domino, Essential Concepts, Understanding Domino Environment, and Planning Domino Infrastructure. Trainer has explained what are IBM Lotus Notes and Domino?

Day 2 (12th March 2011)

Mr. Kunal conducted the following topics on second day: Installation and Configuration, Platform Support, Demo, Lab. Trainer has demonstrated installation and configuration with step by step explanation. Followed by this students have also performed installation and configuration of Lotus Domino.

Day 3 (13th March 2011)

Mr. Kunal discussed the following points on Sunday: Lotus Domino Security, Managing and Maintaining Domino Infrastructure, Lotus Domino Mail Routing, Lotus Domino Replication, and Demo and Lab. He has discussed about Hierarchical Naming, Domino Security Model, Various Access Control Mechanism in Domino, and Database Security Levels.

Day 4 (14th March 2011)

Mr. Kunal discussed the following topics on last day: Domino and DB2 Integration, Extending Lotus Domino Environment, Monitoring and Troubleshooting. Mr. Kunal has explain how to enables Notes applications, Why Domino & DB2, two supported configurations for Domino and DB2: local or remote, etc.

During the four days training session participants enjoyed the lectures and lab sessions very much. Student got the conceptual and practical knowledge, with pleasant smiling trainer throughout all sessions. The trainer was very friendly with participants. He prefers knowledge sharing along with classroom teaching.

Three days Training Program on IBM DB2 Fundamentals (302), Date: 25^th to 27^th February 2011

Shrimad Rajchandra Institute of Management and Computer Application has organized 3 days DB2 - 9 Fundamentals (302) training program during 25-27 February 2011. The objective of the training program is to provide an exposure to current trends in IT Industry, through IBM Academic Initiative.

The 3 days training program was conducted by the corporate trainers Mr. Satish Parante, Zensoft Services Pvt Ltd, Pune. As part of IBM Academic Initiative, total 60 Students and 5 faculty members benefited through this training program.

The training program was a perfect example of making students industry ready. During the three days, participants got in-depth knowledge of IBM's flagship Relational Database Product DB2.

Day 1 (25th February 2011)

Mr. Dharmendra Bhatti, co-ordinator of the training program, delivered his welcome address. He has welcome Mr. Satish with flowers and invited to start the training. Mr. Satish explained the various levels of DB2 Certification Examination and its importance. He has shared following points:

1. The Relational Model
2. DB2 Fundamentals and Data Studio
3. IBM Data Studio Lab (Hands On)
4. Working with Databases and Database Objects
5. Working with Databases and Database Objects Lab (Hands On)

Day 2 (26th February 2011)

Mr. Satish conducted the following topics on second day.

1. Introduction to SQL
2. Understanding SQL Lab (Hands On)
3. Data Concurrency
4. Data Concurrency Lab (Hands On)
5. Database Security in DB2
6. DB2 Security Lab (Hands On)
7. DB2 Backup and Recovery
8. DB2 Backup and Recovery Lab (Hands On)

Day 3 (27th February 2011)

Mr. Satish discussed the following points on Sunday.

1. DB2 Pure XML
2. DB2 Pure XML, Storing XML Data Made Easy Lab (Hands On)
3. DB2 Programming Fundamentals
4. Accessing DB2 Database from Applications Lab (Hands On)
5. Course Review
6. IBM Certified Academic Associate DB2 9.7 Database and Application Fundamentals

During the three days training session participants enjoyed the lectures and lab sessions very much. Student got the conceptual and practical knowledge with great enthusiasm.

IBM Tivoli Directory Server V6.1 [000-928] Examination Result, Date: 07^th September 2010

The certification examination on IBM Tivoli Directory Server V6.1 (000928) was conducted on 7th September 2010. Mr. ParmantapaDasgupta from IBM has acted as proctor of this examination. Total 75 Students and 5 faculty members appeared in the examination and all of them have successfully cleared it. This is one more excellent result SRIMCA has achieved as IBM CoE. Faculties/Students who have achieved this IBM certificate are:

Faculty members

1. DHARMENDRA BHATTI
2. PRITI PRAJAPATI
3. JIGNASA PRAJAPATI
4. AMISH PATEL
5. CHETANA TAILOR

Student

1.	PATEL YOGESHKUMAR KALYANBHAI	41.	JARIWALA MEKYUSH PRAVINCHANDRA
2.	BARI PRIYANKA ISHWARBHAI	42.	RAVINDRABHAI NIMBABHAI SAIDANE
3.	CHAVDA PRIYANKA ARJUNSINGH	43.	SHUKLA PARTHUIVKUMAR ASHVINKUM
4.	DESAI HETVI JITENDRA	44.	BHAVSAR MAYUR MUKESHBHAI
5.	DESAI HIMA PRAKASHBHAI	45.	DHIMMAR PANNA HASMUKHBHAI
6.	GANATRA PRAJESHKUMAR PRAFULBHA	46.	MAHAJAN NISHTHA ARVINDKUMAR
7.	GANDHI JIMI DHANSUKHBHAI	47.	47MAHIDA ARTIBEN KAMLESHSINH
8.	GOHIL PRANAY JAYANTILAL	48.	MAROLIA MAYURKUMAR HARENDRAKUM
9.	DESAI HIMANSHU HAKUMATRAI	49.	MULLA AFROZBANU MOHMEDHANIF
10.	KAPADIA ANAND PANKAJKUMAR	50.	NAIK PANKITABAHEN BHARATBHAI
11.	KHAN NAHID YAQUB	51.	PANCHAL NIKITABEN KANTIBHAI
12.	MAGDALLAWALA SAMARATH NATWARBH	52.	PRAJAPATI DARSHAN KISHORKUMAR
13.	MAURYA PREMILABEN RAJENDRAPRAS	53.	PAREKH AMITKUMAR KISHORBHAI
14.	MORI CHIRAG ASHOKKUMAR	54.	PATEL BHUMI BALVANTBHAI
15.	PARMAR KRUNAL KUMAR GUNVANTSIN	55.	PATEL HIRENKUMAR HASMUKHBHAI
16.	PARAMAR KRUPALI PRABHUDAS	56.	PATEL KHUSHBU VINODBHAI
17.	PARMAR VIJAYKUMAR RAMJIBHAI	57.	PATEL KHUSHBUBEN YOGESHBHAI
18.	PATEL ANKURKUMAR PRAVINBHAI	58.	PATEL NEELAMBAHEN SUMANBHAI
19.	PATEL BHOOMIKA AMRUTLAL	59.	PATEL MITUL RAJENDRAKUMAR
20.	PATEL DARSHANKUMAR GHELABHAI	60.	PATEL ROMABEN ASHOKBHAI
21.	PATEL HARDIK BHIKHUBHAI	61.	PATELVRUNDA DILIPBHAI
22.	PATEL HIRAL PARKASHBHAI	62.	PRAJAPATI BHAVIN MAHENDRABHAI
23.	PATHAN NADIAKHATUN FIROZKHAN	63.	PRAJAPATI HIRALKUMARI DIPAKBHA
24.	PRAJAPATI NILESHBHAI MOHANBHAI	64.	SHAH MEGHAL JANAKKUMAR
25.	RESHAMWALA HIREN JYOTINDRA	65.	SHARMA PUJABAHEN RAMCHARITAR
26.	RINI ELIZABETH CHERIAN	66.	SHARMA SONAL VINODBHAI
27.	SAIDANE NILESHKUMAR DEVIDAS	67.	SHEKH MUBASHSHIRAHBANU MOHAMME
28.	SALUKE ARVIND SHANTARAM	68.	SISODIYA VIKRAMSINH RAJBAHADUR
29.	SHAH ALOK BHUPENDRABHAI	69.	SMART VAIDEHI KEYUR
30.	SHAH HARDIK MUKESHBHAI	70.	SHUKLA BHARGAVI DIVYAKANTBHAI
31.	SHAH NEELAM SANJAYKUMAR	71.	REENA VASHARAMBHAI ANGHAN
32.	SINGALA VIVEK NARENDRABHAI	72.	DIVYA NANUBHAI SIYODIA
33.	SIDDHPURIYA NIKHILKUMAR YOGEND	73.	GODHWANIPOONAMBHAGWANDAS
34.	SHAH MANISHKUMAR HASTIMAL	74.	THAKORHETVIJAYESHBHAI
35.	TAILOR HITESH SHASHIKANTBHAI	75.	PATEL KSHITI BANKIMCHANDRA
36.	TAILOR SHIVAM JITENDRABHAI
37.	PATEL ANIKET JASHWANTBHAI
38.	PATEL SUNIL GANESHBHAI
39.	LAD AMITKUMAR DALPATBHAI
40.	JAIN MEENA GOKULCHAND

In the year 2010 SRIMCA has organized 4 IBM certification workshops.

Certification	Workshop Dates	Certified Students	Certified Faculties	Result
IBM Rational Application Developer [255]	15-18 February 2010	41	10	76.12 %
IBM DB2 Fundamentals [730]	11-13 March 2010	72	1	76.84 %
IBM Rational Functional Tester [842]	8-11 July 2010	62	7	100 %
IBM Tivoli Directory Server [928]	25-28 August 2010	75	5	100 %
Total		250	23	87.78%

Four days certification workshop on IBM Tivoli Directory Server 6.1 (000928), Date: 25^th to 28^th August 2010.

ShrimadRajchandra Institute of Management and Computer Application has organized 4 days Tivoli Directory Server 6.1 (000928) certification workshop during 25-28 August 2010. The objective of the workshop was to provide an exposure to an untouched domain - Identity Management, through IBM Academic Initiative.

The 4daysworkshop was conducted by the corporate trainers Mr.MayurSomwanshi, Zensoft Services Pvt. Ltd., Pune. As part of IBM Academic Initiative, total 78 Students and 5 faculty membersbenefited through this training program.

The workshophas opened a new career window for MCA students. During the four days, participants got in-depth knowledge of IBM Tivoli Directory Server.

Day 1 (25thAugust 2010)

Mr. DharmendraBhatti, coordinator of the workshop, delivered his welcome address. Dr. Bankim Patel, Director, SRIMCA, has welcome Mr. Mayur with flowers and motivated participants. Class representative Mr. Vijay (MCA 5th Semester) and Mr. Hiren (MCA 3rd semester) welcomed Mr. Mayur with flowers.Mr. Mayurhas begun by giving overview of IBM Tivoli product suite and its importance. He has shared following points:

• Introduction to IT Service Management and Industry standards,
• Information Technology Infrastructure Library (ITILv3) Framework,
• Overview of IBM Service Management (ISM) Framework,
• Introduction to Tivoli Software and Tivoli Security Management Portfolio,
• Understanding the LDAP Protocol, LDAP Architecture

Day 2 (26thAugust 2010)

Mr. Mayur explainedfollowing topics on second day:

• Concept of virtual machine, VMware client,
• Prerequisite for TDS, Setting up a working Tivoli Directory server,
• Understanding TDS schema, We Administration Tool, Command Line.

Day 3 (27thAugust 2010)

Mr. Mayurdiscussedfollowing points on third day:

• Replication: Master-slave, peer-to-peer, advantages, how to install,
• Access Control List: authentication, authorization, subject, object, group membership

Day 4 (28thAugust 2010)

Mr. Mayur discussed following points on fouth day:

• Security Management in TDS,
• Distributed Directory,
• Logging Utilities in TDS.

On last day trainer has discussed few sample questions with students. This has given a good idea about how to prepare for certification examination.

During the four days training session participants enjoyed the lectures and lab sessions very much. Student got the conceptual and practical knowledge from Tivoli guru and excellent trainer Mr. Mayur.Trainer has also discussed about industry requirement and how students can grab the opportunities.

IBM DB2 Fundamentals (730) Examination Result, Date: 03^rd August 2010

SRIMCA has organized four Days Certification Training Program on IBM Rational Function Tester (842) from 11-13 March 2010.

The certification examination was conducted on 03rd August 2010. Mr. Sami Shaikh from IBM has acted as proctor of this examination. Total 51 Students appeared in the examination and 78% have successfully cleared it. Students who have achieved this IBM certificate are:

MCA 3rd Semester Student

1.BHAVSAR MAYUR MUKESHBHAI	2.DESAI MIKEN VIRATBHAI
3.DHIMMAR PANNA HASMUKHBHAI	4.MAHAJAN NISHTHA ARVINDKUMAR
5.MAHIDA ARTIBEN KAMLESHSINH	6.MAROLIA MAYURKUMAR HARENDRAKUM
7.MULLA AFROZBANU MOHMEDHANIF	8.NAIK PANKITABAHEN BHARATBHAI
9.PANCHAL NIKITABEN KANTIBHAI	10.PAREKH AMITKUMAR KISHORBHAI
11.PATEL BHUMI BALVANTBHAI	12.PATEL HIRENKUMAR HASMUKHBHAI
13.PATEL KHUSHBU VINODBHAI	14.PATEL KHUSHBUBEN YOGESHBHAI
15.PATEL NEELAMBAHEN SUMANBHAI	16.PATEL MITUL RAJENDRAKUMAR
17.PATEL ROMABEN ASHOKBHAI	18.PATELVRUNDA DILIPBHAI
19.PRAJAPATI BHAVIN MAHENDRABHAI	20.PRAJAPATI HIRALKUMARI DIPAKBHA
21.SHAH MEGHAL JANAKKUMAR	22.SHARMA PUJABAHEN RAMCHARITAR
23.SHARMA SONAL VINODBHAI	24.SHEKH MUBASHSHIRAHBANU MOHAMME
25.SISODIYA VIKRAMSINH RAJBAHADUR	26.SMART VAIDEHI KEYUR
27.SHUKLA BHARGAVI DIVYAKANTBHAI	28.SHETA PRADIPKUMAR GORDHANBHAI
29. REENA VASHARAMBHAI ANGHAN	30.DIVYA NANUBHAI SIYODIA
31.GODHWANI POONAM BHAGWANDAS	32.THAKOR HETVI JAYESHBHAI
33.PATEL KSHITI BANKIMCHANDRA

MCA 5th Semester Student

1.PATEL ANKURKUMAR PRAVINBHAI	2.PATEL BHOOMIKA AMRUTLAL
3.SALUKE ARVIND SHANTARAM	4.SIDDHPURIYA NIKHILKUMAR YOGEND
5.TAILOR SHIVAM JITENDRABHAI	6.PATEL ANIKET JASHWANTBHAI
7.SHUKLA PARTHUIVKUMAR ASHVINKUM

Three days Training Program on IBM DB2 Fundamentals (730), Date: 11^th to 13^th March 2010

Shrimad Rajchandra Institute of Management and Computer Application and SRIMCA IT club has organized 3 days DB2 - 9 Fundamentals (730) training program during 11-13 March 2010. The objective of the training program was to provide an exposure to current trends in IT Industry, through IBM Academic Initiative.

The 3 days training program was conducted by the corporate trainers Mr. Rajib Mondal, Vinsys IT Services, Pune. As part of IBM Academic Initiative, total 102 Students benefited through this training program.

The training program was a perfect example of fun while you learn. During the three days, participants got in-depth knowledge of IBM's flagship Relational Database Product DB2.

Day 1 (11th March 2010)

Mr. Dharmendra Bhatti, co-ordinator of the training program, delivered his welcome address. Participant students have welcome Mr. Rajib with flowers and invite to start the training. Mr. Rajib explained the various levels of DB2 Certification Examination and its importance. He has shared following points:

Section 1 - Working with Databases and Database Objects

• Ability to identify and connect to DB2 servers and databases
• Ability to identify DB2 objects
• Knowledge of basic characteristics and properties of DB2 objects
• Given a DDL SQL statement, knowledge to identify results (ability to create objects)

Section 2 - Planning

• Knowledge of restricting data access
• Knowledge of the features or functions available in DB2 tools (just tools that come with product - distributed space - i.e., control center, configuration advisor, configuraiton assistant, command line processor)
• Knowledge database workloads (OLTP vs warehousing)
• Knowledge of non-relational data concepts (extenders)
• Knowledge of XML data implications (non-shreading)

Day 2 (12th March 2010)

Mr. Rajib conducted the following topics on second day.

Section 3 - Working with DB2 Data using SQL

• Given a DML SQL statement, knowledge to identify results
• Ability to use SQL to SELECT data from tables
• Ability to use SQL to SORT or GROUP data
• Ability to use SQL to UPDATE, DELETE, or INSERT data
• Knowledge of transactions (i.e., commit/rollback and transaction boundaries)
• Ability to call a procedure or invoke a user defined function
• Given an XQuery statement, knowledge to identify results

Section 4 - Security

• Knowledge of DB2 products (client, server, etc.)
• Knowledge of different privileges and authorities
• Knowledge of encryption options (data and network)
• Given a DDL SQL statement, knowledge to identify results (grant/revoke/connect statements)

Day 3 (13th March 2010)

Mr. Rajib discussed the following points on third day.

Section 5 - Working with DB2 Tables, Views and Indexes

• Ability to demonstrate usage of DB2 data types
• Given a situation, ability to create table
• Knowledge to identify when referential integrity should be used
• Knowledge to identify methods of data constraint
• Knowledge to identify characteristics of a table, view or index
• Knowledge to identify when triggers should be used
• Knowledge of schemas
• Knowledge of data type options for storing XML data

Section 6 - Data Concurrency

• Knowledge to identify factors that influence locking
• Ability to list objects on which locks can be obtained
• Knowledge to identify characteristics of DB2 locks
• Given a situation, knowledge to identify the isolation levels that should be used

Section 7 - Lab

• Practical Lab - Product Installation
• DB2 Detective Game

During the three days training session participants enjoyed the lectures and lab sessions very much. Student got the conceptual and practical knowledge, with pleasant smiling trainer throughout all sessions.

Four days IBM Rational Application Developer Certification Workshop, Date: 15^th to 18^th February 2010

Shrimad Rajchandra Institute of Management and Computer Application and SRIMCA IT club has organized four days IBM RAD Certification Workshop during 15-18 February 2010. The objective of the training program was to provide an exposure to current trends in IT Industry, through IBM Academic Initiative. This workshop has prepared participants for IBM Certified Associate Developer (Test - 255).

The four days workshop was conducted by the corporate trainer Mr. Kapil Kulkarni from System Consultants, Pune. Mr. Kapil Kulkarni is an IBM Certified for WebSphere 6.1 and Rational Application Developer 6.0 has an experience of more than 8 years into various sectors of IT industries like development, consultancy, and training. He has conducted corporate training and consultancy for renowed IT houses like IBM, Wipro, TechM, Amdocs, Cognizant, Satyam, L&T.

The training program was an excellent blend of conceptual knowledge and practical implementation. During the four days, participants of the program got in-depth knowledge of IBM's Rational Application Developer. 57 Students and 10 faculty members of SRIMCA attended the workshop.

Day 1 (15th February 2010)

Mr. Dharmendra Bhatti, co-ordinator of the workshop, delivered his welcome address and welcome Mr. Kapil Kulkarni with flowers. Mr. Kapil explained the various aspects of this workshop and certification. He has shared following points:

Section 1 - Workbench Basics

• Set Workbench preferences
• Work with perspectives and views
• Use the import and export wizards
• Use the Help feature to aid in development activities
• Use the Local History to compare and replace resources
• Manage workspaces
• Lab-1) Installation and workbench lab

Section 2 - Java Development

• Create Java projects packages, classes, and methods
• Manage the Java Build Path
• Use the Outline view
• Use the refactoring features
• Use the Java editor features such as content assist and code formatting
• Add and organize import declarations
• Use the Java search function
• Use the Task and Problems views
• Use the Hierarchy view
• Use the resource and project property dialogues
• Lab-2) Java development lab

Day 2 (16th February 2010)

Mr. Kapil conducted the following topics on second day.

Section 3 - Web Development - Basic

• Create dynamic and static Web projects
• Understand classpath and module dependencies
• Use Page Designer to add and modify HTML, JavaScript, and JSP content
• Configure Web project properties
• Create and configure Servlets
• Lab-3) - Web application development Part-I lab

Section 4 - Running Applications

• Use WebSphere Application Server V6 to run J2EE applications
• Create and configure data sources
• Add and remove projects from the server
• Run stand-alone Java applications
• Locate and view WebSphere application server logs
• Lab-4) - Work with Databases

Day 3 (17th February 2010)

Mr. Kapil discussed the following points on third day.

Section 5 - Web Development - Advance

• Understand the available Struts development tools
• Understand the available JSF (JavaServer Faces) development tools
• Lab-5a) Web application development Part-II lab
• Lab-5b) Web application development Part-III lab

Section 6 - Packaging and Deployment

• Create J2EE projects
• Import and export J2EE modules
• Create and locate resources in the appropriate location of the project hierarchy
• Work with Web and Application Deployment Descriptor Editors
• Lab-6) Packaging & Deployment lab

Day 4 (18th February 2010)

Mr. Kapil discussed the following points on fourth day.

Section 7a - Debugging Web Application

• Perform JSP debugging
• Use step-by-step debugging
• Lab-7a) Web Application Debugging Lab

Section 7b - Test Web Application

• Perform unit testing using JUnit
• Perform Web Application testing
• Lab-7b) Test Web Application

During the four days participants enjoyed the lectures and lab sessions very much. Apart from the conceptual and practical knowledge, the more important thing they learned was a professional attitude, industry insights and several invaluable tips to successfully penetrate the industry.

Three Days Training Program on IBM DB2 Fundamentals (730) , Date: 16^th to 18^thNovember 2009

SRIMCA organized three days Training Program on IBM DB2 Fundamentals (730) during 16th nov 2009 - 18th nov 2009 and the examination was conducted on 24th Novemeber 2009.

40 Students and 3 faculty members appeared in the examination from which following candidated have successfully cleared it

MCA Ist Students		MCA IIIrd Students		Faculty Members
Name	Score	Name	Score	Name	Score
Sonam Patel	67.19%	Neelam Shah	67.19%	Jikitsha Sheth	85.94%
Darshan Prajapati	64.06%	Darshan Patel	64.06%	Jitendra Nasriwala	68.75%
		Amit Lad	64.04%	Sharanya Nair	67.19%
		Vivek Shingala	62.50%
		Sunil Patel	59.38%

Shrimad Rajchandra Institute of Management and Computer Application and SRIMCA IT club has organized 3 days DB2 - 9 Fundamentals (730) training program during 16-18 November 2009. The objective of the training program was to provide an exposure to current trends in IT Industry, through IBM Academic Initiative.
The 3 days training program was conducted by the corporate trainers from IBM Academic Initiative, Mr. Mr. Ravi Ranjan, Delhi. 41 Students and 3 faculty members attended the training program.
The training program was an excellent blend of conceptual knowledge and practical implementation. During the three days, participants of the program got in-depth knowledge of IBM's flagship Relational Database Product DB2.

DAY 1 (16th NOV 2009)

Mr. Dharmendra Bhatti, co-ordinator of the training program, delivered his welcome address. Participant students have welcome Mr. Ravi Ranjan with flowers and invite to start the training. Mr. Ravi explained the various levels of DB2 Certification Examination and its importance. He has shared following points:

SECTION 1 - WORKING WITH DATABASES AND DATABASE OBJECTS

1. Ability to identify and connect to DB2 servers and databases
2. Ability to identify DB2 objects
3. Knowledge of basic characteristics and properties of DB2 objects
4. Given a DDL SQL statement, knowledge to identify results (ability to create objects)

SECTION 2 - PLANNING

1. Knowledge of restricting data access
2. Knowledge of the features or functions available in DB2 tools (just tools that come with product - distributed space -    i.e., control center, configuration advisor, configuraiton assistant, command line processor)
3. Knowledge database workloads (OLTP vs warehousing)
4. Knowledge of non-relational data concepts (extenders)
5. Knowledge of XML data implications (non-shreading)

DAY 2 (17th NOV 2009)

Mr. Ravi conducted the following topics on second day.

SECTION 3 - WORKING WITH DB2 DATA USING SQL

1. Given a DML SQL statement, knowledge to identify results
2. Ability to use SQL to SELECT data from tables
3. Ability to use SQL to SORT or GROUP data
4. >Ability to use SQL to UPDATE, DELETE, or INSERT data
5. Knowledge of transactions (i.e., commit/rollback and transaction boundaries)
6. Ability to call a procedure or invoke a user defined function
7. Given an XQuery statement, knowledge to identify results

SECTION 4 - SECURITY

1. Knowledge of DB2 products (client, server, etc.)
2. Knowledge of different privileges and authorities
3. Knowledge of encryption options (data and network)
4. Given a DDL SQL statement, knowledge to identify results (grant/revoke/connect statements)

DAY 3 (18th NOV 2009)

Mr. Ravi discussed the following points on third day.

SECTION 5 - WORKING WITH DB2 TABLES, VIEWS AND INDEXES

1. Ability to demonstrate usage of DB2 data types
2. Given a situation, ability to create table
3. Knowledge to identify when referential integrity should be used
4. Knowledge to identify methods of data constraint
5. Knowledge to identify characteristics of a table, view or index
6. Knowledge to identify when triggers should be used
7. Knowledge of schemas
8. Knowledge of data type options for storing XML data

SECTION 6 - DATA CONCURRENCY

1. Knowledge to identify factors that influence locking
2. Ability to list objects on which locks can be obtained
3. Knowledge to identify characteristics of DB2 locks
4. Given a situation, knowledge to identify the isolation levels that should be used

SECTION 7 - LAB

1. Practical Lab - Product Installation
2. DB2 Detective Game

During the three days training session participants enjoyed the lectures and lab sessions very much. Apart from the conceptual and practical knowledge, the more important thing they learned was a professional attitude, industry insights and several invaluable tips to successfully penetrate the industry.

Service Oriented Architecture Certification Workshop in Association with IBM, Date: 25^th November, 2007

The SOA Certification Workshop organized by SRIMCA in association with IBM addressed on how to build and grow a successful career in Information Technology.
The objective of the workshop was to train the participants to gain good understanding of SOA concepts and how can be applied to an enterprise. It was helpful to identify business functions where SOA can improve competitiveness and productivity, understand the business case for SOA and the architecture, organizational change and infrastructure investments that are required to deliver ROI. It helped participants especially IT Professionals, Business Analysts, Service Designers, Faculties and Students of all branches of Engineering, M.C.A, B.C.A, M.Sc. (Computer Science & IT) & B.Sc. (Computer Science) to advance their career with SOA challenges.

Mr. Vikas Manoria, IT-Expert, IBM Academic Initiative who is involved with Goal Driven SOA, delivered his experience to the delegates. As the workshop was fully dedicated for the certification - IBM Certified SOA Associate, 7 delegates cleared in the Certification Program. Around 82 delegates were registered and 75 were selected for appear the Certification Exam. 2 delegates from SRIMCA, which includes Mr. Mohsin Hasim Mansur(SYMCA student) and Mr. Lal Bihari Barik, Asst. Professor has been certified as SOA Associate by IBM.

Workshop on "IBM-TSM Express", Date: 31^st August 2^nd September 2007

SRIMCA organized a 3-Day Workshop on "IBM TSM Express" during 31st Aug. - 2nd Sep., 2007 in association with IBM, Delhi.

The objective of the workshop was to train the participants according to the latest advancement that is taking place in the field of information technology such as solutions on IT Infrastructure Backup, Disaster Recovery, Monitoring, and Mailing & other Business related Information Security.

About 100 delegates were participated in the workshop. Hon. Dr. R. G. Kothari, Vice-Chancellor, Veer Narmad South Gujarat University, Mr. Devkant Aggarwal Relationship Manager - IBM Academic Initiative address the delegates how to meet the Industry challenges. Mr. Prashant Pokarna, ZenSOFT Services, described the major function of TSM Express, key concepts integral to TSM product, Installation of Backup Client/Server Software, described how the file versions/spaces are managed, Managing Media copy schedules, Restoring Data for Computer/application, Managing Libraries, Monitoring Backups and the Backups Server Security and Trouble Shooting TSM Express including hands on practical session. The workshop helped participants especially students to work directly with the IT experts during this workshop.