Answered by:
Sql Server 2008 Certification

Question
-
Hello
I would like to get a Certificate in SQL server Database administration. Can you please suggest me whether i will go for sql sever 2005 or 2008 certification because right now i am workign with sql server 2005 and not too much compnay till now moved to sql 2008 and please tell me the paper that i have to cleared for sql 2005 or 2008 dba.
Monday, January 25, 2010 7:54 AM
Answers
-
Hi,
SQL 2005
For MCITP: Database Administrator you need:
Exam 70-431 (This is also the MCTS exam for SQL 2005)
Exam 70-443
Exam 70-444
SQL 2008
For MCITP: Database Administrator 2008 you need:
Exam 70-432 (This is also the MCTS exam for SQL 2008)
Exam 70-450
You could also go for both certifications, there is a upgrade exam available:
Exam 70-453
If you want to do only one cert I would go for the SQL 2008 track, a lot of the knowledge you learn for
that certification also applies to SQL 2005, otherwise consider to take also the upgrade exam after the
SQL 2005 track, its only one more exam. Other thing to consider is that the 70-431 exam is a combined dba/developer exam and contains
T-SQL developer questions.
For valuable resources and more information also see the SQL server Training Portal
Rob.- Proposed as answer by rhagman Monday, January 25, 2010 8:39 AM
- Marked as answer by Rubel Khan Tuesday, February 2, 2010 3:03 PM
Monday, January 25, 2010 8:38 AM -
HI Amit,
Better you can go for SQL Server 2008 instead of SQL Server 2005. After one year SQL Server 2008 demands will be very high. so, my suggestion go for 2008.
For SQL Server 2008 Database Administrator you have to pass two exams
MCITP: Database Administrator 2008
For SQL Server 2005 Database Administrator you have to pass three exams:
MCITP: Database Administrator
For your more conformation please check this link.
http://www.microsoft.com/learning/en/us/certification/mcitp.aspx#tab2
http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx#tab3
http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx#tab2
Thank You- Proposed as answer by TapanPattanaik Monday, January 25, 2010 8:42 AM
- Marked as answer by Rubel Khan Tuesday, February 2, 2010 3:03 PM
Monday, January 25, 2010 8:42 AM -
Dear Sir
Can you tell me where can i get the good training in delhi.
Amit Kr Singh
You can try NIIT. They have many locations in India.
http://www.niit.com/services/ITEducationforIndividuals/HWandNetworkingCourses/Pages/HWandNetworkingCourses.aspx
NIIT was one of the finalists for Microsoft Learning solutions Innovative Partner of this year and they have many location in India.
Learning Solutions, Innovative Partner of the Year 2009Finalist: Netcampus, South Africa
Finalist: Benchmark/New Horizons Learning, United States
Finalist: NIIT, India
Hope this is helpful. Good luck finding the right training institute.
Rubel Khan - MY BLOG!
If your question was truly answered, please mark it as Answered and Vote as helpful. Thank you in advance.- Marked as answer by Rubel Khan Tuesday, February 2, 2010 3:03 PM
Friday, January 29, 2010 2:44 AM -
Hi Amit,
As Ruble mention above, you can go for NIIT. I also agree with him. As per my point of view or I have seen their courses are according to the exams.
Thank You- Proposed as answer by TapanPattanaik Saturday, January 30, 2010 7:44 PM
- Marked as answer by Rubel Khan Tuesday, February 2, 2010 3:04 PM
Saturday, January 30, 2010 7:44 PM
All replies
-
Hi,
SQL 2005
For MCITP: Database Administrator you need:
Exam 70-431 (This is also the MCTS exam for SQL 2005)
Exam 70-443
Exam 70-444
SQL 2008
For MCITP: Database Administrator 2008 you need:
Exam 70-432 (This is also the MCTS exam for SQL 2008)
Exam 70-450
You could also go for both certifications, there is a upgrade exam available:
Exam 70-453
If you want to do only one cert I would go for the SQL 2008 track, a lot of the knowledge you learn for
that certification also applies to SQL 2005, otherwise consider to take also the upgrade exam after the
SQL 2005 track, its only one more exam. Other thing to consider is that the 70-431 exam is a combined dba/developer exam and contains
T-SQL developer questions.
For valuable resources and more information also see the SQL server Training Portal
Rob.- Proposed as answer by rhagman Monday, January 25, 2010 8:39 AM
- Marked as answer by Rubel Khan Tuesday, February 2, 2010 3:03 PM
Monday, January 25, 2010 8:38 AM -
HI Amit,
Better you can go for SQL Server 2008 instead of SQL Server 2005. After one year SQL Server 2008 demands will be very high. so, my suggestion go for 2008.
For SQL Server 2008 Database Administrator you have to pass two exams
MCITP: Database Administrator 2008
For SQL Server 2005 Database Administrator you have to pass three exams:
MCITP: Database Administrator
For your more conformation please check this link.
http://www.microsoft.com/learning/en/us/certification/mcitp.aspx#tab2
http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx#tab3
http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx#tab2
Thank You- Proposed as answer by TapanPattanaik Monday, January 25, 2010 8:42 AM
- Marked as answer by Rubel Khan Tuesday, February 2, 2010 3:03 PM
Monday, January 25, 2010 8:42 AM -
Dear Sir
Can you tell me where can i get the good training in delhi.
Amit Kr SinghWednesday, January 27, 2010 7:20 AM -
Dear Sir
Can you tell me where can i get the good training in delhi.
Amit Kr Singh
You can try NIIT. They have many locations in India.
http://www.niit.com/services/ITEducationforIndividuals/HWandNetworkingCourses/Pages/HWandNetworkingCourses.aspx
NIIT was one of the finalists for Microsoft Learning solutions Innovative Partner of this year and they have many location in India.
Learning Solutions, Innovative Partner of the Year 2009Finalist: Netcampus, South Africa
Finalist: Benchmark/New Horizons Learning, United States
Finalist: NIIT, India
Hope this is helpful. Good luck finding the right training institute.
Rubel Khan - MY BLOG!
If your question was truly answered, please mark it as Answered and Vote as helpful. Thank you in advance.- Marked as answer by Rubel Khan Tuesday, February 2, 2010 3:03 PM
Friday, January 29, 2010 2:44 AM -
Hi Amit,
As Ruble mention above, you can go for NIIT. I also agree with him. As per my point of view or I have seen their courses are according to the exams.
Thank You- Proposed as answer by TapanPattanaik Saturday, January 30, 2010 7:44 PM
- Marked as answer by Rubel Khan Tuesday, February 2, 2010 3:04 PM
Saturday, January 30, 2010 7:44 PM -
Dear Rubel
I did GNIIT from NIIT i konw that they do not have good faculty.
I agree with you that their study material is very good but i doubt about their faculty.
Can you tell me any other institue or any individual .
It will be very helpful to me.
Amit Kr SinghWednesday, February 3, 2010 4:13 AM