Books for MCDBA exams | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Books for MCDBA exams

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 />
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
[email protected] When life gives you a lemon, fire the DBA.
One of my favorites is Inside SQL Server by Kelen Delany. This site has a lot of resources on books too. Check out this link it’s the MS resource kit for FREE!http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part4/c1261.mspx
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
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).
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.
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.
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.
Satya, How can I tell whether I have the latest BOL? Does service pack include updated BOL?
Thank you, Peter
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.
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?

Oh, well thats good to know from you.
Good luck, then refer tohttp://www.2000tutor.com for free practice exams. 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.
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">
Thank you for the links. If I find other useful resources, I will post them.[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]
I have just received these 2 books: http://www.microsoft.com/mspress/books/6799.asp
http://www.microsoft.com/mspress/books/6800.asp Has anyone read these 2 books?
Thank you.

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.
<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">
Had used testking. great help though <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />
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.
try testking. the format looks exactly the same as the one in the exam.
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |