SQL Server Performance

Books for MCDBA exams

Discussion in 'SQL Server 2000 Certification [Archive]' started by pcsql, May 14, 2004.

  1. pcsql New Member

    What are some of the good books to study for SQL Server 2000 exams of MCDBA track?<br /><br /><br />I have the Inside SQL Server 2000 book.<br /><br />I'm planning to get the following MS books:<br /><br />MCSE Training Kit (Exam 70-22<img src='/community/emoticons/emotion-11.gif' alt='8)' />: Microsoft® SQL Server™ 2000 System Administration<br />MCSE Training Kit (Exam 70-229): Microsoft® SQL Server™ 2000 Database Design and Implementation<br /><br />I wonder whether I should wait until SQL Server 2005 exams but I guess they probably won't be available late next year.<br /><br /><br />Thank you,<br /><br />Peter<br /><br />
  2. derrickleggett New Member

    I would look at the Amazon.com ratings if I were you. I have found the ratings and comments by users to rarely lead me wrong on technical books. There have been a couple odd exceptions to this, but it's definitely worth checking out. There are only about 3 million books for this. I think for Administration the MS Press Training Kit looks pretty good.

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
  3. Raulie New Member

  4. pcsql New Member

    Lazy_DBA,

    I already have the Kalen Delaney's book. Do you know whether the Microsoft SQL Server 2000 Resource Kit CD is included in MSDN Universal subscription? I don't think the Kit CD can be downloaded from MS.

    Thank you,

    Peter

  5. Raulie New Member

    Ooo, Im not sure, Im taking 70-228 this week. I read a lot of the articles on this site and from the link I sent you also BOL. As far as books I havn't read any specific MCDBA books (Gee I hope Im prepared).
  6. satya Moderator

    http://www.microsoft.com/learning/mcp/mcdba/requirements.asp refer to this link which gives you complete information about books and links with regard to MCDBA.

    I would say both the books are ideal to go thru about MCDBA.

    Better not to wait and you will never know what will be replaced, it will be easy if you get the certification in SQL 2K and prepare for 2K5 when MS releases the course pattern.

    Good luck.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  7. gaurav_bindlish New Member

    I had cleared the 229 exam and the book is fairly nice to give you a head start. But for some topics, I think you need ti read excerpts from BOL.

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

    The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
  8. satya Moderator

    Ofcourse keep the BOL as SQL bible, you never know what you want to know more.
    .. .and don't forget to download the latest version of BOL.
    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  9. pcsql New Member

    Satya,

    How can I tell whether I have the latest BOL? Does service pack include updated BOL?


    Thank you,

    Peter
  10. satya Moderator

    Unfortunately no such indiciation of versioning the BOL in SQL server, constantly watch MSSQL homepage for any updations.

    I've seen frequent updation to BOL since SQL 2000 is introduced and for the latest one go from herehttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=3865

    Yes, SP releases will update the BOL as SP3 & 3a did so.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  11. pcsql New Member

    Satya,

    Well, at least, the title is changed to SQL Server Books Online (Updated) and the topic What's New in SQL Server Books Online shows January 2004.

    I guess MS actually has versions for this: 8.00.02 which is shown in the webpage.

    Thanks for the link.

    Now, I just need to start reading and trying different area. BTW, any good free practice exams?


  12. satya Moderator

  13. gaurav_bindlish New Member

    Or to<a target="_blank" href=http://mcsebraindumps.com>http://mcsebraindumps.com</a> for the actual test questions. [}<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Gaurav<br /><i>Moderator<br /><font size="1">Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard</i></font id="size1"><br /><font size="1">The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.</font id="size1">
  14. pcsql New Member

    Thank you for the links. If I find other useful resources, I will post them.[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]
  15. pcsql New Member

  16. satya Moderator

    http://www.microsoft.com/mspress/books/6799.asp is a good book for 70228.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  17. smy New Member

    <font face="Comic Sans MS"><br />Hi All [<img src='/community/emoticons/emotion-1.gif' alt=':)' />],<br />I will be taking 70-229 Exam soon. Those taken this exam, can share with me your experience? What kind of reference/books/tips to share? <br /><br />Thanks [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /></font id="Comic Sans MS">
  18. smy New Member

    Had used testking. great help though <img src='/community/emoticons/emotion-1.gif' alt=':)' />
  19. balaganesh2k Member

    Where can I get sample questions for MCDBA.,
    I'm also planning to get MCDBA but I don't know the procedures what I need to do?
    Please let me know ..

    Ganesan B.
    Well defined problem is half way solved.
  20. smy New Member

    try testking. the format looks exactly the same as the one in the exam.

Share This Page