MCDBA Administering SQL Server 2000 Study Guide (Exam 70-228) [Hardcover]

Joyjit Mukherjee (Author)

Book Description

ISBN-10: 0072127031 | ISBN-13: 978-0072127034 | Publication Date: July 5, 2001 | Edition: 1

The only classroom-based training and self-assessment system! Osborne's MCDBA Administering SQL Server 2000 Study Guide provides 100% complete coverage of all official Microsoft exam objectives for exam 70-228. Based on 200,000+ hours of IT training experience, the book contains hundreds of practice exam questions and hands-on exercises. The CD-ROM features full CertTrainer CBT software with interactive tutorials and lab simulations, plus the new ExamSim adaptive test engine.

Editorial Reviews

From the Back Cover

The Only Certification Study System Based on 200,000+ Hours of IT Training Experience

100% Complete Coverage--All official test objectives for Exam 70-228 are covered in detail

Hands-on Exercises--Step-by-step instruction modeled after classroom labs

Exam Watch--Warnings based on thorough post-exam research identifying the most troublesome exam topics and how to answer them correctly

Three Types of Practice Questions--Knowledge, scenario, and lab-based questions, all with in-depth answers

From the Classroom--Discussions of important issues direct from the classrooms of Global Knowledge's award-winning instructors

Full coverage of the topics you need to review, including how to:

• Install and configure SQL Server 2000
• Plan for multiple instances of SQL Server
• Plan the physical placement of files
• Perform an unattended setup
• Upgrade from a previous version to SQL Server 2000
• Monitor and tune SQL Server 2000
• Optimize SQL Server performance using files and filegroups
• Manage database files
• Create and assign SQL Server roles
• Implement security using stored procedures, views, and user-defined functions
• Backup and restore data
• Transfer data and objects using DTS
• Implement multimaster replication

CD-ROM features full CertTrainer CBT software and the new ExamSim test engine­­more than 300 questions on CD

CertTrainer

• e-Training--Self-paced review of key SQL Server 2000 topics, including exam tips
• CERTCAM--Instructional SQL Server 2000 animations with expert audio explanations
• In-depth Links--Need more explanation? Topically relevant links provide detailed instruction
• Skill Assessment--Test your knowledge with more than 250 challenging practice exam questions
• Score Reports--Indicate subject areas requiring further study

ExamSim

• Complete Practice Exam--A realistic MCDBA exam with questions found only on the CD-ROM
• Review Mode--Analyze what you got wrong and why
• Detailed Answers--Explain why the correct options are right and why the incorrect options are wrong
• Score Report--Provides an overall assessment of your performance

PLUS

E-book--Electronic, searchable version of the Study Guide

About the Author

Joyjit Mukhrjee, MCSD (Atlanta, GA) is a training and courseware expert at NIIT, a global IT training services corporation. NIIT has developed over 10,000 hours of Instructor-Led Training (ILT) and over 3,000 hours of Internet Based Training and Computer Based Training. NIIT trains over 250,000 students each year and is a content development partner for Microsoft, NETg, Thomson Learning, Arthur Anderson, Sun, IBM, and HP.

Product Details

• Hardcover: 748 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (July 5, 2001)
• Language: English
• ISBN-10: 0072127031
• ISBN-13: 978-0072127034
• Product Dimensions: 9.4 x 7.7 x 2.4 inches
• Shipping Weight: 3.9 pounds
• Average Customer Review: 2.6 out of 5 stars  See all reviews (21 customer reviews)
• Amazon Best Sellers Rank: #2,589,190 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

38 of 44 people found the following review helpful:

5.0 out of 5 stars MCDBA 70-228 SQL Administering, October 19, 2001

By 

James Ortiz (Gilbert, Arizona) - See all my reviews

This review is from: MCDBA Administering SQL Server 2000 Study Guide (Exam 70-228) (Hardcover)

I used this book as a training/study guide, and passed exam 70-228. The topics are discussed logically and in a fair amount of detail. Real world situations are provided, procedure demonsrations providing actual screen shots, exam watch tips, and certification objectives. The two-minute drills at the end of each chapter are a good review, a help reinforce the material to memory.

The CD contains practice exams with full explanations which are useful for exam preparation. There are also review sessions, which are just the 'two-minute' drills from the book provided in a 'flash-card' format. The full text is also on the CD for easy electronic searching.

I would suggest the following for passing exam 70-228 (I am an MCSE, and 1 test away from MCDBA):
1.) Use this book to train and learn the content. Also Microsoft MOC or other MCT Training.
2.) Use ExamCram notes, "Cramsession.com", or "ExamNotes.net" study guides to review and commit the needed details to memory.
3.) Use "Transcender", the included "ExamSim" on the CD, or any other practice exams to learn the material and familiarize with MS exam format.

Unfortunately the Syngress book for exam 70-229 SQL 2000 Design is not yet released, so I had to buy the Sybex MCSE SQL 2000 Design Study Guide.

15 of 16 people found the following review helpful:

2.0 out of 5 stars Embarrassing, DON'T BUT THIS BOOK, December 14, 2002

By 

Aaron Engel - See all my reviews

This review is from: MCDBA Administering SQL Server 2000 Study Guide (Exam 70-228) (Hardcover)

I have read and reviewed over 25 MS certification books, and this is among the worst I've ever seen. This book was obviously rushed into print, as the spelling and grammar errors are the worst I've ever seen in any published material. There are many cases where they give example SQL text that doesn't even run b/c of inaccuracies. Many of the exam questions specify incorrect answers and/or tell you one answer is correct, then the answer explanation will explain why another answer is the correct choice.

The book is week on substance, as many of its pages are filled with screen shots rather than enlightening content. The test questions are not similar to the type of questions found on the actual exam.

If anyone actually reviewed this book before it went into production, they should be fired immediately, as it's hard to read more than a couple pages without finding errors, many of which make it difficult to determine what the author is trying to say.

If you want to learn SQL server and desire to pass the exam, spend your time with other material.

9 of 9 people found the following review helpful:

1.0 out of 5 stars I expected much more from Osborne..., August 9, 2002

By 

"bones108" (Springfield, IL USA) - See all my reviews

This review is from: MCDBA Administering SQL Server 2000 Study Guide (Exam 70-228) (Hardcover)

I chose this book because of a few good reviews on this site, coupled with my success using other certification guides from Osborne. Up until now, I would have continued purchasing Osborne books. However, this book is VERY poorly written. There are blatant grammatical errors, and many of the sentences are so poorly written that, at times, my friend (who is an MCDBA) could not understand some of the concepts that the author was attempting to illustrate. If you are looking for good books to study for 070-228, you should definitely look elsewhere!