MCDBA Administering SQL Server 2000 Study Guide (Exam 70-228) (Certification Press) Hardcover – 1 Jul 2001
There is a newer edition of this item:
Enter your mobile number below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
Getting the download link through email is temporarily not available. Please check back later.
To get the free app, enter your mobile phone number.
From the Publisher
100% complete coverage of exam objectives
Chapter components are designed to provide critical information in easy-to-digest forms
Special, updated 'How to Take a Microsoft Exam' section
Q&A scenarios lay out problems and solutions in a quick-read form.
Updated Personal Testing Center with 300 questions, including both short answers, and in-depth answers.
New exam simulator on CD-ROM with 2 full exams.
Entire book on CD-ROM, including detailed table of contents and glossary
Audio that covers the key exam objectives on CD-ROM.
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 enginemore than 300 questions on CD
-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
-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
E-book Electronic, searchable version of the Study GuideSee all Product Description
Top Customer Reviews
The exam had question after question that referred to things not touched on in the text, specifically on complex transact SQL statements, something which is greatly lacking in the text. Time after time, the exam made me think that the book I'd been reading was the "Playschool book of SQL", not one to prepare me for an MCP exam.
The book's cover boasts 100% coverage, it falls way short of that. Please save your money and choose something else. If I could give it less than one star, I would.
other than that it's perfect.
passed my 70-229 exam at 753, hard exam and complemented it with trandumper tests, but i passed it.
personally for me it's the hardest exam i've ever taken, and unlike they say, the exam will focus on XML and Replication so watch out!.
Most Helpful Customer Reviews on Amazon.com (beta)
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.
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.