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

~ (Author), (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: 3.9 out of 5 stars  See all reviews (8 customer reviews)
• Amazon.com Sales Rank: #47,085 in Books (See Bestsellers in Books)

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

  #6 in	Books > Computers & Internet > Certification Central > MS SQL Server
  #12 in	Books > Computers & Internet > Programming > Software Design, Testing & Engineering > Structured Design
  #12 in	Books > Computers & Internet > Databases > Relational Databases

Customer Reviews

Most Helpful Customer Reviews

5 of 6 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!

3.0 out of 5 stars Hard test, mediocre book, September 24, 2009

By	David Martin "lifetime learner" (South Florida, USA) - See all my reviews (REAL NAME)

Amazon Verified Purchase

I have passed all 3 exams using only these Study guides. This exam is the most difficult due to the format, not the material. The exam makes you read 8 pages of case study and then asks you 10 questions. The questions all conform to MS Best Practices, which is what this book is all about. Damned boring to read though, after the 70-431 title. I did this test last. Do not try to do it first. If you cannot pass the 70-431's simulation, you'd rather not waste time and expense on any other exam.

One note about the exam: each Case Study has it's own timer. I freaked myself half-way through and thought I was out of time. Raced through the case study and then promptly got another one with a reset timer. Frayed my nerves so bad I could not absorb the text. I had to sit back for 5 minutes and force myself to think about non-SQL stuff.

Concentrate on the last 2 sections of the study (Business Requirements, Technical Requirements) ... the rest is detractor.

Do not buy this book unless you plan to sit the exam. Force yourself to read it in a weekend and then just go through the cd practices.

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!