locked
sql certification advice RRS feed

  • Question

  • I was trying to be a web developer until I found out what a bad job market it has. Now I am trying to pursue a career in database administration. I need to take the admin sql server 2008 test but I need to learn the material before taking the test. Are there classes somewhere that I could take that would prepare me for this exam? I can do simple queries but I also need to learn the more complex queries as well as learn about the physcial server. Should I get the certification for database developer before the DBA? I"m confused as to how to proceed and the number of test I need, microsofts website is confusing.

    Thanks
    Tuesday, November 10, 2009 4:58 PM

Answers

  • Ok, the DBA role can be a mixed bag. In some companies it is self contained role where the DBA is the master of all databases and does their sysadmin role. In others its a mix between a system admin and dba and finally there is the developer DBA who because they spend so much time in the database they assume the mantel of the DBA role. The MCITP DBA and DBD certifications allow for people who specialise in one field or the other to certify without having to learn stuff outside their specialty. For DBA it focuses a lot on high availabilty, transactions, replication, log shipping, mirroring and security while the DBD is query optmisation, data and table design and implementation, keys, indexes and ensuring high speed accuracy. So the split is there for a reason If you have limited experience in database work, I would suggest staying away from certification until you can get your skills up as a lot of the work is based on indepth knowledge of the product. So... if you can only do simple queries and not complex ones involving cursors for example, it might be a bit above you. I dont know how the market is at the moment in your location for DBAs either. I would say your best option is to use the training kit along with a lot of virtual machines and build up your skillset so that you have the hands on experience to back up the book smarts
    Blog: http://www.certsandprogs.com

    70-536 Objectives List with MSDN Links
    70-505 Objectives List with MSDN Links
    70-562 Objectives List with MSDN Links
    70-433 Objectives List with MSDN Links
    • Marked as answer by Rubel Khan Wednesday, January 6, 2010 3:41 AM
    Tuesday, November 10, 2009 9:18 PM
  • I think you have to go with a networking career and perhaps specialize in SQL. Niall is exactly right that most company combine these two roles. And in the cases where they don't, you need to be pretty darn good to earn that spot. With you just now getting into this field, it's going to be a while before you can secure one of those positions.

    I realize this isn't likely the response you wanted but the reality is that you probably need a good solid networking job that allows you to migrate into a database role.


    Matt

    CompTIA A+, Net+
    MCP, MCSE 2003, MCTS
    • Marked as answer by Rubel Khan Wednesday, January 6, 2010 3:41 AM
    Wednesday, December 9, 2009 4:13 PM
  • Yeah ,DBA will have more demand than  web developer in the market,also harder.
    There is no need to get the certification for database developer before the DBA .but I think Niall's advice is useful for you to follow .
    If you want to get  MCITP :admin sql server 2008 test ,you are required to pass 70-432 and 70-450
    while MCITP database Adiministrator  ,pass 70-431  and 70-443 and 70-444 .



    however ,i should say it is  no peak that you can not reach .
    Good luck to you .


    ______________________
    Microsoft experience http://www.microsoftkit.com
    IT ceritificaton IT training http://www.my-dig.com
    Server 2008 OS blog http://www.microsoftbible.com
    • Marked as answer by Rubel Khan Wednesday, January 6, 2010 3:42 AM
    Thursday, December 10, 2009 2:08 AM

All replies

  • Ok, the DBA role can be a mixed bag. In some companies it is self contained role where the DBA is the master of all databases and does their sysadmin role. In others its a mix between a system admin and dba and finally there is the developer DBA who because they spend so much time in the database they assume the mantel of the DBA role. The MCITP DBA and DBD certifications allow for people who specialise in one field or the other to certify without having to learn stuff outside their specialty. For DBA it focuses a lot on high availabilty, transactions, replication, log shipping, mirroring and security while the DBD is query optmisation, data and table design and implementation, keys, indexes and ensuring high speed accuracy. So the split is there for a reason If you have limited experience in database work, I would suggest staying away from certification until you can get your skills up as a lot of the work is based on indepth knowledge of the product. So... if you can only do simple queries and not complex ones involving cursors for example, it might be a bit above you. I dont know how the market is at the moment in your location for DBAs either. I would say your best option is to use the training kit along with a lot of virtual machines and build up your skillset so that you have the hands on experience to back up the book smarts
    Blog: http://www.certsandprogs.com

    70-536 Objectives List with MSDN Links
    70-505 Objectives List with MSDN Links
    70-562 Objectives List with MSDN Links
    70-433 Objectives List with MSDN Links
    • Marked as answer by Rubel Khan Wednesday, January 6, 2010 3:41 AM
    Tuesday, November 10, 2009 9:18 PM
  • I think you have to go with a networking career and perhaps specialize in SQL. Niall is exactly right that most company combine these two roles. And in the cases where they don't, you need to be pretty darn good to earn that spot. With you just now getting into this field, it's going to be a while before you can secure one of those positions.

    I realize this isn't likely the response you wanted but the reality is that you probably need a good solid networking job that allows you to migrate into a database role.


    Matt

    CompTIA A+, Net+
    MCP, MCSE 2003, MCTS
    • Marked as answer by Rubel Khan Wednesday, January 6, 2010 3:41 AM
    Wednesday, December 9, 2009 4:13 PM
  • Yeah ,DBA will have more demand than  web developer in the market,also harder.
    There is no need to get the certification for database developer before the DBA .but I think Niall's advice is useful for you to follow .
    If you want to get  MCITP :admin sql server 2008 test ,you are required to pass 70-432 and 70-450
    while MCITP database Adiministrator  ,pass 70-431  and 70-443 and 70-444 .



    however ,i should say it is  no peak that you can not reach .
    Good luck to you .


    ______________________
    Microsoft experience http://www.microsoftkit.com
    IT ceritificaton IT training http://www.my-dig.com
    Server 2008 OS blog http://www.microsoftbible.com
    • Marked as answer by Rubel Khan Wednesday, January 6, 2010 3:42 AM
    Thursday, December 10, 2009 2:08 AM
  • I think you have to go with a networking career and perhaps specialize in SQL. Niall is exactly right that most company combine these two roles. And in the cases where they don't, you need to be pretty darn good to earn that spot. With you just now getting into this field, it's going to be a while before you can secure one of those positions.

    I realize this isn't likely the response you wanted but the reality is that you probably need a good solid networking job that allows you to migrate into a database role. 
    Oh yeah, Derp is singing the truth. You need to get your foot in the door. DBA level positions are more difficult to find and more demanding of skills. Start with networking and move into the SQL world.
    Thursday, December 10, 2009 6:49 PM