MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases w/SQL Server 2000 Enterprise Edition [Paperback]

Thomas Moore (Author), Ed Tittel (Author)

Book Description

ISBN-10: 0789731061 | ISBN-13: 978-0789731067 | Publication Date: June 11, 2005

The MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases with SQL Server 2000 Enterprise Edition covers exactly what you need to know to pass the 70-229 exam. It is the ideal refresher that ensures readers cover the essentials and the ultimate complement guide for larger training guides, instructor-led classes or CBT training. This comprehensive reference guide also comes with the popular "Cram Sheet" tear card for your last minute cram sessions, and the accompanying CD includes a practice test engine powered by MeasureUp. You will also benefit from the community support at www.examcram2.com, which features industry news, study tips, practice exams, and discussion boards.

Editorial Reviews

From the Back Cover

The MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases with SQL Server 2000 Enterprise Edition covers exactly what you need to know to pass the 70-229 exam. It is the ideal refresher that ensures readers cover the essentials and the ultimate complement guide for larger training guides, instructor-led classes or CBT training. This comprehensive reference guide also comes with the popular "Cram Sheet" tear card for your last minute cram sessions, and the accompanying CD includes a practice test engine powered by MeasureUp. You will also benefit from the community support at www.examcram2.com, which features industry news, study tips, practice exams, and discussion boards.

About the Author

Designing and Implementing Databases with SQL Server 2000 Enterprise EditionAbout the Author

Thomas Moore (MCSE, MCSA, MCSD, MCDBA, MCT, CSE, CTT+) has been in the computer industry for more than 25 years. Thomas has a wide variety of expertise in all hardware environments and with most Microsoft Server products. "My first and lasting love," he says, "besides my wife and family, however, is programming." Thomas is comfortable in any programming language environment, achieving his MCSD and MCDBA certifications from their inception and recently completing his Microsoft CSE certification as a certified software engineer with Microsoft Business Solutions products. Over the past 18 years he has been working for various Microsoft partners and currently is an Intermediate Developer/Technical Consultant with Diamond Municipal Solutions (formerly Diamond Software) in Paris, Ontario, where he has been for the past three years. Thomas enjoys staying up-to-date, although, like most of us, he finds it a challenge to keep up with the pace of the industry.

© Copyright Pearson Education. All rights reserved.

See all Editorial Reviews

Product Details

• Paperback: 504 pages
• Publisher: Que (June 11, 2005)
• Language: English
• ISBN-10: 0789731061
• ISBN-13: 978-0789731067
• Product Dimensions: 9.1 x 6.1 x 1.2 inches
• Shipping Weight: 1.4 pounds (View shipping rates and policies)
• Average Customer Review: 3.4 out of 5 stars  See all reviews (9 customer reviews)
• Amazon Best Sellers Rank: #1,936,386 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

17 of 21 people found the following review helpful:

4.0 out of 5 stars Good For Revision, But u need to Couple it with Another Reference, April 1, 2006

By 

derazz "derazz" (Geneva, Versoix Switzerland) - See all my reviews

This review is from: MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases w/SQL Server 2000 Enterprise Edition (Paperback)

I used this book as part of my revision portfolio. i found it a comprehensive reference in my revision for Exam 70-229. it is light on a couple of stuff ie: XML , estimating the size of a database and such. but all in all after reading it, i felt like i had a clear grasp of all the areas i needed to know about & prepare for , for the exam. Having that confidence helped in moving forward to the next phase ie: tackling past questions.

what i liked about this book :
- it lists the various objectives of the exam & there is a chapter for each Exam objective.
- it is a comprehensive read at 321 pages.
- there are exam questions after every chapter, Relating to that chapter
- there is a CD with 50 questions set in an application that simulates the exam room scenario.
- on the ExamCram2 site, a section features 64-100 additional questions & answers
- Answers with explanations are provided with every question featured in the book.

However, i also coupled my preparation with the following and when it came to crunch this is what made all the difference when taking the exam: u might want to check these out

(and this is why i cant give the book alone all 5 points of credit)

(1.) SQL Server 2000 Fast Answers ISBN: 1590595920
value:( the only place i found anything on estimating the size of a database , (apart from BOL) and past question scenario explanations. besides that, this is also a very good reference for 70-229 & 70-228. -- Sack is a good SQL Server author
(2.) SQL Tips & Techniques: ISBN:1931841454
Value:(for matters SQL ie: using ROLLUP,CUBE , T-sql rules, cursors, triggers, sprocs, server security elements, the works. a magnificent reference. with plenty of examples-(very important).I cherish this author.
(3.)Portable DBA SQL Server. ISBN:0072230169
Value:(if u read this before the ExamCram2 book, you'll feel much more prepared for ExamCram2 and the past questions stage.it helped consolidate my knowledge and identify areas of weakness.

However, if you have used other study aids or big 700page type Tombs, or feel resonably confident of your understanding, or have identified your areas of weakness & really just need a bit of practise for the exam, then this is what u should do instead.
(Go on The fast track)
(a.) Get a copy of Transcender certification for Exam 70-229 answer all 132 qestions and read the expanations where u go wrong.
(b.) Get a copy of Testking Exam 70-229, anything from version 1.x up is good, answer all 107 or 238 questions on the various problem scenarios and study the explanations where u go wrong.
(c.)visit braindumps dot com and get the latest exam 70-229 brain dump. answer all 107+ questions. understand the stuff & leave no stone unturned.

schedule and sit the exam when you've finished with these various example scenario questions.u r ready.

Ace the exam.

listen, there are many other books that i referenced, but what i think is most important (after revising and knowing your stuff) is to pass the actual exam in 160minutes & 44 questions. you need to tackle question regarding problem scenarios in order to sharpen your wits about applying/selecting/choosing the right solution /tool or strategy within any given problem scenario. this is the crunch of it. do that ,and u pass.

End of.

oh, for those wondering, i took the exam just thursday last ie:(30th March 2006); scored 93% ie: 931. The pass mark is 700 ie: 70%.

Good luck.

cheers :-)

5 of 5 people found the following review helpful:

4.0 out of 5 stars Great Book, August 22, 2005

By 

Rami Jaber Sukkar "Rami Sukkar" (Beirut,Lebanon) - See all my reviews
(REAL NAME)   

This review is from: MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases w/SQL Server 2000 Enterprise Edition (Paperback)

Hi. It is a great book for the exam. Up to the point, covers all objectives. The Exam Cram Sheet that comes with the book touches on all the points that need to be known just before the exam. I even found similar questions from the practice tests at the exam. But most importantly, use this book as your sole resource ONLY if you have experience with SQL Server 2000 (I have 5 years exp.), and want to prepare for the exam. If you don't have the experience, maybe you should take the microsoft course, or if you have an experience with other database systems, just practice with the different aspects of SQL Server 2000 and make sure you know TSQL well,SQL Query Analyser and the Profiler.

Good Luck to all.

3 of 3 people found the following review helpful:

5.0 out of 5 stars Thorough topic coverage, July 26, 2005

By 

Willy (Halifax, Nova Scotia) - See all my reviews

This review is from: MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases w/SQL Server 2000 Enterprise Edition (Paperback)

The book hit on all of the exam topics and provided enough knowledge for me to be well prepared to take the exam. I had been using self studying techniques and failed the exam on my first attempt, but this put me over the top. I would rocommend it for anyone preparing for the exam.