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

J.C. Mackin (Author), Mike Hotek (Author)

Book Description

Series: Pro Certification | Publication Date: December 6, 2006

EXAM PREP GUIDE

Ace your preparation for the skills measured by MCITP Exam 70-443—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what you’ve learned by applying your knowledge to real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.

Maximize your performance on the exam by learning to:

• Install, consolidate, and configure multiple database instances
• Design tables, file groups, and indexes for a physical database
• Develop and implement security policies at the server, database, and object levels
• Design, implement, and configure clustering, log shipping, database mirroring, and replication
• Create plans for data archiving, data backups, and disaster recovery

PRACTICE TESTS:

Assess your skills with practice tests on CD. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers—including a customized learning path that describes how and where to focus your studies.

Your training kit includes:

• 15% exam discount from Microsoft. Offer expires 12/31/11. Details inside.
• Official self-paced study guide.
• Practice tests with multiple, customizable testing options and a learning plan based on your results.
• 375+ practice and review questions.
• Case scenarios, practice exercises, and best practices.
• 180-day evaluation version of Microsoft SQL Server 2005 Enterprise Edition.
• 20 Webcasts with 25+ additional hours of instruction.
• Fully searchable eBook of this guide.

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to [e-mail].

Editorial Reviews

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

About the Author

J.C. Mackin, MCITP, MCSE, MCT, has 10+ years’ experience with Microsoft networks and is an IT consultant, trainer, and author.

Product Details

• Hardcover: 752 pages
• Publisher: Microsoft Press (December 6, 2006)
• Language: English
• ISBN-10: 073562173X
• ISBN-13: 978-0735621732
• Product Dimensions: 9.3 x 7.4 x 2.1 inches
• Shipping Weight: 3.7 pounds (View shipping rates and policies)
• Average Customer Review: 3.9 out of 5 stars  See all reviews (8 customer reviews)
• Amazon Best Sellers Rank: #260,360 in Books (See Top 100 in Books)
  • #40 in Books > Computers & Technology > Databases > Relational Databases
  • #92 in Books > Computers & Technology > Microsoft > Development > SQL Server

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

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

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!

1 of 1 people found the following review helpful:

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

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

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)   

Amazon Verified Purchase

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

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!