locked
Sql Server 2008 Certification RRS feed

  • 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

    Exam 70-432

    Exam 70-450


    For SQL Server 2005 Database Administrator you have to pass three exams:

    MCITP: Database Administrator

    Exam 70-431

    Exam 70-443

    Exam 70-444

    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 2009

    Finalist: 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

    Exam 70-432

    Exam 70-450


    For SQL Server 2005 Database Administrator you have to pass three exams:

    MCITP: Database Administrator

    Exam 70-431

    Exam 70-443

    Exam 70-444

    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
    Wednesday, 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 2009

    Finalist: 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 Singh
    Wednesday, February 3, 2010 4:13 AM