MCDBA SQL Server 2000 All-in-One Exam Guide (Book/CD Set) [Hardcover]

Dave Perkovich (Author)

Book Description

Publication Date: August 22, 2001 | ISBN-10: 0072131586 | ISBN-13: 978-0072131581

This "All-in-One" is all you need! This authoritative reference offers complete coverage of all material on the two core MCDBA SQL Server 2000 exams. You'll find exam objectives at the beginning of each chapter, helpful exam tips, end-of-chapter practice questions, and photographs and illustrations. The bonus CD-ROM contains practice tests, hundreds of questions, and LearnKey([trademark]) video clips. This comprehensive guide will not only help you pass the MCDBA SQL Server 2000 certification exams, but will also serve as an invaluable on-the-job reference.

Editorial Reviews

From the Back Cover

Now you can prepare for the two required MCDBA exams --Installing, Configuring, and Administering (#70-228) and Designing and Implementing Databases (#70-229) -- using this comprehensive reference. You'll also get an overview of the various editions of SQL Server, including which operating systems each edition supports, as well as full details on some of the advanced features of SQL Server 2000. Learn how to perform both local and remote installations, administer both Windows 2000 Server as well as SQL Server 2000, manage and maintain data, and much more. Each chapter contains detailed exam objectives, practice questions, and test-taking tips from a Microsoft-certified trainer, making this a premier study tool. Filled with practical advice, as well as case studies to help illustrate concepts and techniques you've just read about, this book is highly useful as both an exam preparation guide and an on-the-job resource.

Get complete details on exam topics including how to:

Install, configure, and upgrade to SQL Server 2000 Plan for a SQL Server database implementation Create a user-defined database using both SQL Server Enterprise Manager and Transact-SQL Monitor security functions--set database permissions, manage user accounts and logon information Modify, optimize, and troubleshoot a SQL Server 2000 database Develop the logical data model and physical design of a SQL database

About the Author

Dave Perkovich (Mesa, AZ) is a Microsoft Certified Solution Developer as well as a Microsoft Certified Trainer. His company, Training Associates, has written more than twenty Microsoft "official" courses and books covering topics such as Visual Basic 5 and 6, Office 2000 Administration, and Windows 2000 MCSE certification materials. Dave is also involved in Training Associates online training business. Co-developer of the edCenter online learning system, Dave works closely with other Microsoft training centers to help them enter into the world of online training.

Product Details

• Hardcover: 1200 pages
• Publisher: McGraw-Hill Companies (August 22, 2001)
• Language: English
• ISBN-10: 0072131586
• ISBN-13: 978-0072131581
• Product Dimensions: 9.6 x 7.4 x 1.9 inches
• Shipping Weight: 3.2 pounds
• Average Customer Review: 1.3 out of 5 stars  See all reviews (16 customer reviews)
• Amazon Best Sellers Rank: #3,478,744 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

11 of 11 people found the following review helpful:

1.0 out of 5 stars DBA Not, March 4, 2002

By A Customer

This review is from: MCDBA SQL Server 2000 All-in-One Exam Guide (Book/CD Set) (Hardcover)

Dave Perkovich is not a MSSQL DBA and he doesn't have a clue. The book is full of errors. For example: The book states several times that the timestamp field is a datetime field. This is not true. I started marking the errors in the book. More than a third of the pages are marked. The test software is full of bugs. Don't buy this book. If you bought this book, try to get your money back.

7 of 7 people found the following review helpful:

3.0 out of 5 stars It isn't that bad!, August 20, 2002

By 

Danny Creagan (Bellevue, NE USA) - See all my reviews
(REAL NAME)   

This review is from: MCDBA SQL Server 2000 All-in-One Exam Guide (Book/CD Set) (Hardcover)

I bought this book because I couldn't find any others in my local bookstores. When I 'browsed' it, it seemed clear enough so I took a chance. Now that I've read all but the last few chapters (and done all the exercises, etc), I feel I would buy it again and, indeed, recommend it with a small qualification or two.

Positives:

First, it is not the bottom of the heap - far from it. I've read much poorer quality technical books before. I rated it at 3 stars but, if it hadn't claimed to be a test prep book, I would have rated it at 4 stars.

Second, it is great for new people. So what if it misses a few of the finer points (even necessary ones?) Within two days of starting with it I was using DTS and replication and getting XML responses back through IIS. I found it very clear to get these services going.

Third, I don't mind pictures and this book has quite a few. Nothing like a picture to show you what screen you *should* be looking at.

Fourth, other than minor typos, the author is literate. Better than many other books out there.

Negatives:

First, this is *not* a test prep book. I've taken a number of cert tests (dozens) and I don't feel like I'm even close to ready for testing. However, I do feel a lot more confident about understanding the questions. A lot more.

Second, there are some awful mistakes in some of the exercises. All of them are correctable and you have to correct them but it makes you suspicious whenever you start an exercise. For me, that isn't a bad thing. For a complete newbie, it could be a bit distressing.

Third, the test banks don't work well. This doesn't make it a '1' in my opinion. I've not seen a test bank in a book that is representative of the real test. However, it does degrade my overall score for the book a little. Like I said when I started, if the book hadn't advertised it was a test prep book, I would have given it a '4'.

7 of 7 people found the following review helpful:

2.0 out of 5 stars CD-ROM Test Software Useless, March 4, 2002

By 

Robert "Rob Bratton" (Monroeville, PA, United States) - See all my reviews
(REAL NAME)   

This review is from: MCDBA SQL Server 2000 All-in-One Exam Guide (Book/CD Set) (Hardcover)

The content is reasonable. There are a large number of step-by-step processess with screen shots, which I consider filler.

The self-test software on the CD is unusable. It has blank questions. There are also multiple-choice questions that should use checkboxes, but use radio buttons, resulting in only being able to choose one answer. If you happen to choose the first right answer, the answer is scored as correct even though you didn't answer the others.

I'd like to get my money back for this book and buy a better one.

I hope this review prevents others from falling into the same trap as me.

Good luck with your certifications!