Here's the book you need to prepare for Exam 70-228, Installing, Configuring, and Administering Microsoft SQL Server 2000. This Study Guide provides: In-depth coverage of every official exam objective Practical information on installing, configuring, and administering SQL Server 2000 Real-world insights, advice, and recommendations Hundreds of challenging practice questions, in the book and on the CD Leading-edge exam preparation software, including a test engine and electronic flashcards Authoritative coverage of all exam objectives, including: Installing and configuring SQL Server 2000 Creating SQL Server 2000 databases Managing, monitoring, and troubleshooting SQL Server 2000 databases Extracting and transforming data with SQL Server 2000 Managing and monitoring SQL Server 2000 security Managing, monitoring, and troubleshooting SQL Server 2000 Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Coming from Oracle background I am currently using this book to prepare for my MCDBA certification. I would not rate myself as beginner because I have dealt with MS SQL Server on many occasions but not heavily. I am pacing myself with one chapter a day. So far I read about 5 chapters and I would admit that the content is good. Like any other technical book, this one also has some mistakes. In my case I started seeing the mistake on pages 145 and 146. On those pages the authors stated that to see the file id you need to run in the SQL Analyzer the stored procedure sp_helpdb. That is not true at all it should be sp_helpfile. I caught that mistake quickly because I really understood the previous information given and related to file, and I also tested the stored procedures listed in the book. I did check the errata on sybex website nothing is listed concerning that mistake but there are some other corrected mistakes though on the website. As I always do I don't rely on one source for my certification exams. I have got another book and I am planning to get a third one too. I will go through all of them before I go take the exam end of May. I will try to post another review after I took exam. My overall impression on this book is the book is well-written and easy to follow. So far I am getting useful information out of the book. And that helps me understand the objectives on the exam. I am doing pretty good with the review questions at the end of the chapters. After going through half of the book I think I like what I see and I would recommend this book but not as the only source to study for the exam.
ThriftBooks sells millions of used books at the lowest everyday prices. We personally assess every book's quality and offer rare, out-of-print treasures. We deliver the joy of reading in recyclable packaging with free standard shipping on US orders over $15. ThriftBooks.com. Read more. Spend less.