MCITP Self-Paced Training Kit (Exam 70-443): Designing a Database Server Infrastructure Using Microsoft® SQL Server(TM) 2005 (Pro Certification) (Hardcover)

by J.C. Mackin (Author), Mike Hotek (Author)
Key Phrases: database master key, tempdh database, witness server, Quick Check, Active Directory, Coho Vineyard (more...)

Editorial Reviews

Product Description
Announcing an all-new Microsoft Certified IT Professional (MCITP) Training Kit designed to help maximize your performance on Exam 70-443, an exam for the new MCITP: Database Administrator certification. This kit packs the tools and features exam candidates want most—including in-depth, self-paced training based on final exam content; rigorous, objective-by-objective review; exam tips from expert, exam-certified authors; and a robust testing suite. It also provides real-world scenarios, case study examples, and troubleshooting labs for skills and expertise that you can apply to the job.

Focusing on SQL Server 2005, this official study guide covers topics such as designing a database server infrastructure, designing security for a database server solution, designing a physical database, designing a database solution for high availability, specifying data recovery technologies based on business requirements, and designing a strategy for data archiving.

Ace your exam preparation and ramp up quickly on SQL Server 2005 database administration by working at your own pace through the lessons, hands-on exercises, and practice tests. The CD features 425 practice questions and a flexible test engine with pre-assessment and post-assessment capabilities. Choose timed or untimed testing mode, generate random tests, or focus on discrete objectives or chapters, and get detailed explanations for right and wrong answers—including pointers back to the book for further study. You also get a 180-day evaluation version of SQL Server 2005 Enterprise Edition and a 15 percent exam discount voucher—making this kit an exceptional value and a great career investment

From the Publisher
Key Book Benefits:

-Comprehensive study guide written by exam-certified authors -Deeper, more focused coverage of exam objectives and sub-objectives-plus instructive case studies and troubleshooting scenarios to enhance your performance on the job -425 practice questions on CD -Test engine that enables customized testing, pre-assessment and post-assessment, and automated scoring and feedback -Complete objective-by-objective review section, plus a tear-out exam-mapping grid -Exam tips based on real-world test experience -180-day evaluation version of SQL Server 2005 Enterprise Edition -15 percent exam discount voucher from a leading authorized testing center (limited time offer) -Microsoft Encyclopedia of Networking, Second Edition, eBook -Practice files on CD -Entire study guide in searchable eBook format

See all Editorial Reviews

Product Details

• Hardcover: 752 pages
• Publisher: Microsoft Press (December 27, 2006)
• Language: English
• ISBN-10: 073562173X
• ISBN-13: 978-0735621732
• Product Dimensions: 9.1 x 7.4 x 2.1 inches
• Shipping Weight: 3.7 pounds
• Average Customer Review: 4.0 out of 5 stars See all reviews (7 customer reviews)
• Amazon.com Sales Rank: #283,246 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #23 in	Books > Computers & Internet > Certification Central > MS SQL Server
  #61 in	Books > Computers & Internet > Certification Central > Publisher > Microsoft Press
  #72 in	Books > Computers & Internet > Certification Central > Exams > MCSE

Customer Reviews

Most Helpful Customer Reviews

4 of 5 people found the following review helpful:

5.0 out of 5 stars A well written exam guide, and a good reference as well, October 13, 2008

By	Justin (San Antonio, TX) - See all my reviews

I'm just about finished my MCITP: DBA Certification on SQL 2005. So far I've done 70-431, and 70-443. I've been working with SQL Server for a number of years now, and I've recently switched over to a full time DBA position.

I read this book in about 2 weeks, and did the exam on the third week. I managed to get 910 on the exam, out of 1000. As 700 is the passing grade, I'm more than satisfied with anything over 900. Along with some kind of practice testing, this book is adequate study material. I suggest you have a lab in place so you can do the practices and test out the software for yourself. Besides just being a study guide for a certification exam, I've found myself referring back to this book several times, and it has a permanent spot on my book shelf at work. With that said, I can safely say I recommend this book to those looking to take the 70-443 exam.

Good luck!

4.0 out of 5 stars Good prep choice, March 25, 2009

By	Brent Oliver (Mancos, CO United States) - See all my reviews (REAL NAME)

This book did a good job in preparing me to pass the 70-443 exam. Out of the three exams for the MCITP - Database Administrator I found this one the hardest and would recommend that you take the 70-444 exam first as the study you do for that test will also help you on this one. While I did find that a couple of questions on my exam were not covered by any prep book for all three tests, there was more than enough to pass by a comfortable margin.

Make sure and take advantage of the prep tests included with the book, and pay special attention to the scenario based questions as the entire test is scenario based,, no simple what does this definition match up to questions on this test!

1 of 2 people found the following review helpful:

3.0 out of 5 stars The book covers the material, but ..., March 6, 2009

By	Eric Kassan (Las Vegas, NV USA) - See all my reviews (REAL NAME)

This book covers the exam material, but so does the book for exam 70-431 - SQL 2005 Implementation and Maintenance. I did not read this book carefully, so I can't comment too much on its quality, but if your goal is the MCITP-Database Admin certification, since 70-431 is required, you should be able to reuse that book (and knowledge). This exam deals a little with applying the knowledge, but if you understand the pros and cons of various RAID options, security options, fault-tolerance options, and backup options (all covered in 70-431), then you should have no problem identifying which apply to which situations. Having passed the exam, I must conclude I didn't miss much. At least the 15% off your exam coupon reimburses some of the cost of the book.