Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 - Certification - Everything you need to Know
Goto page 1, 2  Next
 
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
skqwee

New User


Joined: 24 Mar 2005
Posts: 2

PostPosted: Thu Apr 21, 2005 1:39 pm    Post subject: DB2 - Certification - Everything you need to Know
Reply with quote

Hello,

Could someone tell me the process of taking the IBM DB2 certification
Back to top
View user's profile Send private message

mcmillan

Site Admin


Joined: 18 May 2003
Posts: 1202
Location: India

PostPosted: Fri Apr 22, 2005 9:59 pm    Post subject:
Reply with quote

IBM Available Certifications:
http://www-03.ibm.com/certify/certs/dm_index.shtml

IBM Test Information:
http://www-03.ibm.com/certify/tests/test_index.shtml

Popular DB2 Tests

Quote:
512 - DB2 UDB V7.1 Family Fundamentals
514 - DB2 UDB V7.1 Family Application Development
516 - DB2 UDB V7.1 for OS/390 Database Administration

700 - DB2 UDB V8.1 Family Fundamentals
701 DB2 UDB V8.1for Linux, UNIX and Windows Database Administration
702 DB2 UDB V8.1 for z/OS Database Administration
703 DB2 UDB V8.1 Family Application Development
705 DB2 Business Intelligence Solutions V8.1
706 DB2 UDB V8.1 for Linux, UNIX and Windows Database Administration Upgrade exam
442 DB2 Content Manager V8


Exam 512 & 514 Guidelines:
Code:
http://www-03.ibm.com/certify/certs/dbseudd7.shtml
http://www-03.ibm.com/certify/tests/obj512.shtml
http://www-1.ibm.com/certify/tests/sam512.shtml
http://www-03.ibm.com/certify/tests/obj514.shtml



Exam 700 Guidelines:

Code:
http://www-03.ibm.com/certify/tests/obj700.shtml
http://www-03.ibm.com/certify/tests/edu700.shtml
http://www-106.ibm.com/developerworks/db2/library/tutorials/db2cert/db2cert_tut.html
http://www-128.ibm.com/developerworks/db2/library/tutorials/db2cert/db2cert_V8_tut.html
http://www-306.ibm.com/software/data/education/pdfs/exam-700.pdf


Exam 701 Guidelines:
http://www-128.ibm.com/developerworks/db2/library/tutorials/db2cert/701_prep.html


Exam 702 Guidelines:

Code:
http://www-03.ibm.com/certify/tests/obj702.shtml
http://www-03.ibm.com/certify/tests/edu702.shtml

Exam 703 :
http://www-128.ibm.com/developerworks/offers/lp/db2cert/


Certification Tutorials:

http://www-106.ibm.com/developerworks/db2/library/tutorials/db2cert/db2cert_tut.html

http://www-106.ibm.com/developerworks/db2/library/tutorials/db2cert/db2cert_V8_tut.html

http://www-306.ibm.com/software/data/education/pdfs/exam-700.pdf


Recommended Books:


http://btobsearch.barnesandnoble.com/booksearch/isbninquiry.asp?ISBN=0131424653&pdf=y&userid=2VO7FE16Q1&sourceid=0039356948&btob=Y

http://btobsearch.barnesandnoble.com/booksearch/isbninquiry.asp?userid=2VO7FE16Q1&sourceid=0039356948&btob=Y&pwb=1&ean=9780672325823


http://btobsearch.barnesandnoble.com/booksearch/isbninquiry.asp?userid=2VO7FE16Q1&sourceid=0039356948&btob=Y&pwb=1&ean=9780130463913

http://btobsearch.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=P21KuxKBJt&sourceid=0039356948&btob=Y&isbn=0072133759&itm=5

http://www.murach.com/books/db1r/index.htm

http://www.murach.com/books/db2r/index.htm

More Info

http://ibmmainframes.com/viewtopic.php?t=2214&highlight=db2+certification

http://ibmmainframes.com/viewtopic.php?t=2207&highlight=db2+exam+certification

http://ibmmainframes.com/viewtopic.php?t=129&highlight=db2+exam+certification

http://ibmmainframes.com/viewtopic.php?t=391&highlight=db2+exam+certification

DB2 - Certification - Everything you need to Know
http://www-106.ibm.com/developerworks/db2/library/techarticle/0207fosdick/0207fosdick.html
Back to top
View user's profile Send private message
skqwee

New User


Joined: 24 Mar 2005
Posts: 2

PostPosted: Fri Apr 22, 2005 10:24 pm    Post subject: IBM DB2 certification course
Reply with quote

Hello there,

Thanks for the info on the exams. I am currently residing in London and I would like to know how much would I have to pay to take the test 512 and 514...Will it be possible for me to take the test on-line..or do I have to take it at a specific exam centre...If so, please give me the centres that i could go register to for these tests.

Thanks in advance
Back to top
View user's profile Send private message
mcmillan

Site Admin


Joined: 18 May 2003
Posts: 1202
Location: India

PostPosted: Sat Apr 23, 2005 7:22 am    Post subject:
Reply with quote

Sorry, No Idea about London.. But for Indians, this is the contact detail:

IBM Training Services
IBM India Limited
#12 subramanya Arcade,
Bannergatta Road.
Bangalore - 560 029
Phone: 91 - 80 - 2063000/6787202
Fax : 91 - 80 - 2063109


If you have any queries regarding the career programs or IT Awareness Courses courses, email aceinfo@in.ibm.com.

If you have any queries regarding the corporate training programs email corpedu@in.ibm.com.

But you can write the exams in IBM authorized Training Centres...

I prefer you to choose NIIT:

http://www.itpeopleindia.com/20020930/careers2.shtml

Check this link for Pearson Vue Test centres:

http://www.vue.com/ibm/centers/
Back to top
View user's profile Send private message
brganeshbabu

New User


Joined: 23 Jun 2005
Posts: 34
Location: Chennai

PostPosted: Tue Jun 28, 2005 12:49 pm    Post subject:
Reply with quote

Additionally you have to write 703 exam(along with 700) to become an IBM certified Application Developer. This is for 8.1 family. Check this link available below.
Code:
http://www-03.ibm.com/certify/certs/dbapudv81.shtml
Back to top
View user's profile Send private message
gandhire

New User


Joined: 23 Oct 2004
Posts: 5

PostPosted: Thu Jul 21, 2005 9:59 pm    Post subject: Mock tests and tutorials
Reply with quote

IBM offers a series of six free interactive online tutorials that prepare you for exam 700, downloadable from http://www7b.software.ibm.com/dmdd/trainingcertification.html, or directly from http://www7b.software.ibm.com/dmdd/library/tutorials/db2cert/db2cert_V8_tut.html. These are great background if you?re new to DB2.

It is essential that you take ?practice tests,? mock-ups of the real thing with similar questions. You need to be test-ready. IBM offers a free online test for each certification exam. Take any of them via the web from http://www7b.software.ibm.com/dmdd/trainingcertification.html or http://certify.torolab.ibm.com/ice/displayPage/en. You must have Internet Explorer 5 or above or Netscape Communicator 4.7 or above to take these practice exams. The other source for practice questions are the certification books by Roger Sanders.
Back to top
View user's profile Send private message
vijayamadhuri

Active User


Joined: 06 Apr 2005
Posts: 180

PostPosted: Thu Jul 21, 2005 10:58 pm    Post subject: Re: DB2 - Certification - Everything you need to Know
Reply with quote

This info was pasred earlier i have just copied it

Below is the information you have requested for...

IBM DB2 CERTIFICATION TEST 512

A] SOME IMPORTANT LINKS:
1. Basic test information:
[url]http://www-1.ibm.com/certify/tests/info.shtml#512 [/url]
2. Syllabus:
[url]http://www-1.ibm.com/certify/tests/obj512.shtml [/url]
3. Sample test:
[url]http://www-1.ibm.com/certify/tests/sam512.shtml [/url]

4. Free IBM tutorial:
[url]http://www7b.boulder.ibm.com/dmdd/library/tutorials/db2cert/db2cert_tut.html [/url]B] TIME REQUIRED FOR PREPARATION

As per my opinion, time required for preparation is as follows:

1. First reading of reference book ? 15 days.
2. Clearing free voucher test ? 2-3 days
3. Practice and revision ? 7 days

C] VOUCHER TEST / SAMPLE TEST:

1. A sample test is available on IBM site for preparation of IBM DB2 certification (refer link A3). This test is conducted on internet.

2. There is a free voucher scheme available for this certification. This means that if you score more than 75% marks in the sample test, you can appear for the IBM certification test free of cost.

3. You can appear for this sample test as many times as you wish. Once you score 75% + marks, IBM will send you a voucher number through email.

4. When you register for main certification exam, you have to give this voucher number.

5. For taking this sample test you have to register on the IBM site. Link no A3 mentioned above will lead to registration page.

6. The sample test is very easy as compared to main exam and most of the times you can score 75% easily. Thus it is advisable to appear for sample test first and then for main exam as in that case you won?t have to pay any money for main exam.

D] BOOKS AND RESOURCES USED:

1. For preliminary preparation I used following book:
?DB2 Universal Database V7.1 for UNIX, Linux, Windows and OS/2 DBA Certification? -by Baklarz and Wong

Quote:
Above book contain 16 chapters out of which only first 8 chapters are applicable for IBM test 512. Rests of the chapters are for test 513. Total number of pages to be read is about 400.


This book discusses all theoretical aspects in detail and gives practical examples. Many conceptual questions in IBM exam are discussed in this book.

My experience is that 15 days are sufficient to read this book thoroughly.

2. For a last day revision, I used free IBM tutorial (link 4 mentioned above) which was very useful. But it does not have any practical examples and for first round of study, it should not be used.

3. Other than these 2 resources, some other books are also available on AMAZON for DB2 test 512 preparation. I did not use them.

4. There is a CBT available on IBM site. But I feel that it is of very basic nature and does not help in preparing for the test.

E] ABOUT MAIN IBM TEST

1. IBM test is conducted in IBM authorized centers only. There is one IBM center at Nigadi.
2. You have to register for the exam at least 2 days in advance.
3. There are 55 questions and you have 75 minutes to answer them.
4. Passing score is 55%.
5. You can change the answers at any point of time during the exam.
6. Main IBM test covers questions from all topics and equal weightage is given to theory questions and practical problems.
7. Some of the important topics which had high weightage when I appeared for the test are as follows:

Locking and Isolation levels ? 8 questions
Commit and Rollback concepts ? 5 questions
SQL ? 10 questions
Creation of databases ? 7-8 questions

Hope this helps


Regards

Mayuresh Tendulkar
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Wed Dec 07, 2005 3:17 pm    Post subject: Certification.
Reply with quote

Hi shilpa palasam,

The certification that u had completed is a good thing in mainframe.. and now the next step is to get specialization in one area.. Eg: in Database.. so DB2 certification is worth.. search for more about that in this forum and get benefited...
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Wed Dec 07, 2005 3:19 pm    Post subject: DB2
Reply with quote

Hi venky5436 & Tara,

Plz Search some previous forum regarding the Certification.. Go in DB2 Area and search for ur need. hope helpful..
Back to top
View user's profile Send private message
shilpa palasam

New User


Joined: 06 Dec 2005
Posts: 1
Location: hyderabad

PostPosted: Thu Dec 08, 2005 1:48 pm    Post subject: Re: DB2 - Certification - Everything you need to Know
Reply with quote

hi khamarutheen,

thanx for ur help. i have gone thr' the site.i found that i should give 3-4 certifications to complete the certification.means i found it as in the first step ,i need to pass one certfn.in the step there are three exams.

is it required to complete all the 3 steps of certifications for the certification in db2.

shilpa.
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Thu Dec 08, 2005 2:27 pm    Post subject: DB2
Reply with quote

Hi frnd,
First U need to get trhu the Exam 700.. then according to ur specialization u can select the next level of the exam. it's up to u. but the first is basic and fundamentals..All the best.. prepare it well and do a sample test and then go for the final one..
Back to top
View user's profile Send private message
tomrsan

New User


Joined: 15 Oct 2005
Posts: 13
Location: chennai

PostPosted: Thu Dec 08, 2005 4:46 pm    Post subject: abit db2 ex
Reply with quote

hi kam

where i have to approach for the exam , where i have to apply 4 this,where i can get the detailed and date of the exam
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Thu Dec 08, 2005 6:11 pm    Post subject: DB2
Reply with quote

Hi santhosh,
Use this following link

Code:
http://www-128.ibm.com/developerworks/db2/library/tutorials/db2cert/db2cert_V8_tut.html


Code:
http://www-03.ibm.com/certify/tests/sam700.shtml


Hope helpfull..
Back to top
View user's profile Send private message
venky5436

New User


Joined: 06 Dec 2005
Posts: 12

PostPosted: Sat Dec 10, 2005 1:30 am    Post subject: DB2 UDB 701 Certification Sample Tests
Reply with quote

Hi Khamarutheen,

Thanx for your response. I have seen those previous posts and came across the Q&A which Priya has provided on the site itportal.org.Thanx a lot to PRIYA as I was looking for this for a long time.I wanted to know is this the only material available for the DB2 UDB 701 Certification.I was looking for some Sample tests which will help me prepare for the 701 Certification.I would be very greatful to you as this will help many who are looking to take the certification.IBM and Selftestsoftware have stopped providing them.IBM provides them but they charge $10 for each test even if it is the same test you have bought before .So it is risky to buy.

Thanx again.

Venky
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Wed Dec 14, 2005 12:10 pm    Post subject: DB2
Reply with quote

Hi jeyaraj,,

Plz search in the below link and get the details...
Code:

http://www-03.ibm.com/certify/tests/test_index.shtml

And search the previous post in the forum priya has posted an attachment regarding that... check it..
Back to top
View user's profile Send private message
jonna

New User


Joined: 18 Apr 2005
Posts: 9

PostPosted: Fri Sep 15, 2006 10:29 am    Post subject: Re: DB2 - Certification - Everything you need to Know
Reply with quote

Hi all,
Is it possible to write 703 DB2 certification with out 700 DB2 certification or preliminary exams?
Thanks in advance..
Back to top
View user's profile Send private message
subhasis_50

Moderator


Joined: 09 Mar 2005
Posts: 363
Location: Earth

PostPosted: Tue Sep 19, 2006 5:01 pm    Post subject: Re: DB2 - Certification - Everything you need to Know
Reply with quote

Hi,
I have one study materials for DB2 700 exams. If anybody wants it, pm your mail id. This book is sufficient for taking the exam.
Back to top
View user's profile Send private message
babu_hi

New User


Joined: 11 Apr 2006
Posts: 93

PostPosted: Mon Nov 13, 2006 12:44 pm    Post subject:
Reply with quote

Hi to all,

The Price for 700 - DB2 UDB V8.1 Family Fundamentals certification is
30 USD($) or around 1410 INR(Rupees).
Back to top
View user's profile Send private message
Ramanarayanan
Warnings : 1

New User


Joined: 05 Jan 2007
Posts: 1
Location: Chennai

PostPosted: Wed Jan 31, 2007 3:08 pm    Post subject:
Reply with quote

Hi to all,
Where can we take the exam and where to register?
Back to top
View user's profile Send private message
Bharti P Manglani

New User


Joined: 13 Mar 2007
Posts: 16
Location: Pune

PostPosted: Thu Jul 19, 2007 1:40 pm    Post subject: Re: DB2 - Certification - Everything you need to Know
Reply with quote

Hi,

I would like to ask whether I would be requiring to install DB2 on my machine to prepare for the test?

If so from where can I install it icon_question.gif

Thanks in advance.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Goto page 1, 2  Next
Page 1 of 2

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DB2 fundamentals certification Lipi.Prasannan DB2 5 Wed Oct 14, 2015 10:52 pm
No new posts DB2 certification karthi_ind DB2 3 Mon Jul 07, 2014 7:02 pm
No new posts MQ Solution Designer Certification Appu IBM Tools 0 Mon Jul 07, 2014 11:25 am
No new posts What is DB2 certification for 5 years... venkat.bmw DB2 3 Thu Oct 25, 2012 10:09 am
No new posts Syncsort Certification Gabriel Araujo Alves JCL & VSAM 1 Mon Apr 09, 2012 11:45 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us