Product Description

An integrated study system based on proven instructional methodology, this book includes special pedagogical elements such as step-by-step exercises, exam watch and on-the-job notes, and quick reference scenario and solution tables. More than 250 practice exam questions that match the actual exam questions in content and feel, while all answer options, correct and incorrect, receive detailed explanations as to why the answer is or is not the correct one. A self-test section includes knowledge- and scenario-based questions that match the actual exam questions. The CD-ROM features instructional graphical animations with audio explanations and an eBook, the electronic version of the study guide.

---

Product Details

• Amazon Sales Rank: #777007 in Books
• Published on: 2001-11-01
• Original language: English
• Number of items: 1
• Binding: Hardcover
• 608 pages

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-229 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:

-Develop a logical database design -Design for referential integrity -Manage entity relationships -Implement the physical database and ensure data integrity -Implement advanced database objects and features -Manipulate data using Transact-SQL -Tune and optimize database performance -Monitor database activity with SQL Profiler -Transfer data between systems -Design and implement database security

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

CertTrainer

-e-Training Self-paced review of key SQL Server 2000 topics, including exam tips -CertCams Instructional SQL Server 2000 video animations demonstrate key topics -In-depth Links Need more explanation? Topically relevant links provide detailed instruction -Skill Assessment Test your knowledge with more than 110 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
Anil Desai (Austin, TX), MCSE, MCSD, MCDBA, is Technical Architect at QuickArrow, Inc. He is the author of numerous computer books, among them SQL Server 7 Backup & Recovery; MCSE Windows 2000 Directory Services Administration Exam Guide; and Windows NT Network Management: Reducing Total Cost of Ownership. Jeff Bane (Sarasota, FL), MCSE, MCDBA, is a database consultant who specializes in e-commerce and SQL Server.

---

Customer Reviews

Inadequate as a preparation for the exam
This book claims to contain questions that "match the exam questions in content and feel". It doesn't...

Having failed 70-229 using this book as my main reference point I have to say I found the exam a shock, despite my familiarity with SQL server 7.0. The practice questions in the book were much easier than those in the exam, and did not bear much relationship in terms of the type of question. There were many topics that came up in the exam which were not mentioned in the book, let alone tested in the mock questions.

Subjects were covered in brief detail, only scratching the surface of what was required to pass 70-229.

On a more picky note I found several bugs and faults in the online test material supplied with the book.

The book is saved from getting 1 star as it provides a reasonable basic grounding in some areas of SQL server 2000. I will not be using it to prepare for re-sitting 70-229 and would advise other candidates to do the same. This book seriously underestimates what is needed to pass 70-229 in my opinion.

Seems to do the job quite well
I was apprehensive about getting this book as there were no reviews from anyone else, and as the book by the same publisher on exam 70-228 got such a bad write-up, but got it anyway as there didn't seem to be many good books available for exam 70-229. I have nearly finished reading it and so far have been pleasantly suprised, the content follows the Microsoft syllabus closely, with sufficient and clear detail, screen-shots etc. There are plenty of practice questions (at the end of each chapter and as a final exam simulation on the CD) and the CD accompanying the book is good too. Not only would the book be good for the exam, I would also recommend it to people who want to improve their SQL Server knowledge anyway, as it has practical real-world information too. In preparing for the exam I have also done the corresponding 5-day Microsoft course...