MCITP Administrator: MicrosoftSQL Server2005 Database Server Infrastructure Design Study Guide (Exam 70-443) [Paperback]

J. Steven Jones (Author), David W. Tschanz (Author)

Book Description

Publication Date: September 19, 2006 | ISBN-10: 0470047445 | ISBN-13: 978-0470047446

• This comprehensive book guides readers through Microsoft's brand-new SQL 2005 administrator exam: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 (Exam 70443)
• Addresses the database tasks that the MCITP exam focuses on such as design, development, deployment, optimization, maintenance, and support
• Reviews key topics, including defining high availability solutions, automating administrative tasks, defining security solutions, monitoring and troubleshooting the database server, and much more
• The CD-ROM features leading-edge exam prep software with test engine plus hundreds of practice questions and electronic flashcards

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Editorial Reviews

From the Back Cover

An essential guide for Microsoft's new SQL Server 2005 certification track

With the release of SQL Server 2005, Microsoft is introducing a new multi-exam certification program. This comprehensive book prepares you for Microsoft's all-new exam 70-443, Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005, one of two required Professional Administrator exams in the MCITP: Database Administrator certification path. Inside, find the practical and in-depth instruction you need, including:

• Full coverage of all exam objectives in a systematic approach, so you can be confident you're getting the instruction you need for the exam
• Practical hands-on exercises to reinforce critical skills
• Real-world scenarios that put what you've learned in the context of actual job roles
• Challenging review questions in each chapter to prepare you for exam day
• Exam Essentials, a key feature at the end of each chapter that identifies critical areas you must become proficient in before taking exam 70-443
• A handy fold-out that maps every official exam objective to the corresponding chapter in the book, so you can track your exam prep objective by objective

Look inside for complete coverage of all exam objectives for exam 70-443.

Featured on the CD

SYBEX TEST ENGINE:
Test your knowledge with advanced testing software. Includes all chapter review questions and bonus case study exam questions.

ELECTRONIC FLASHCARDS:
Reinforce your understanding with flashcards that can run on your PC, Pocket PC, or Palm handheld.

Also on the CD is the entire book in searchable and printable PDF. Study anywhere, any time, and approach the exam with confidence.

www.sybex.com

About the Author

Steve Jones has been working with SQL Server for more than a decade, starting with v4.2 on OS/2 and enjoying the new features and capabilities of every version since. After working as a DBA and developer for a variety of companies, Steve founded SQLServerCentral.com along with Brian Knight and Andy Warren in 2001. SQLServerCentral.com has grown into a wonderful SQL Server community that provides daily articles and questions on all aspects of SQL Server to over 300,000 members. Starting in 2004, Steve became the full-time editor of the community and ensures it continues to evolve into the best resource possible for SQL Server professionals.
Over the last decade, Steve has written more than 200 articles about SQL Server for SQLServerCentral.com, the SQL Server Standard magazine, SQL Server Magazine, and Database Journal. teve has spoken at the PASS Summits where SQLServerCentral.com  sponsors an opening reception every year as well as written a prior book for Sybex on SQL Server 2000.

David W. Tschanz is the coauthor of the recent Sybex book Mastering SQL Server 2005. He has been working with and managing large datasets for four decades. His work has included analysis of population dynamics, voting behavior, and epidemiological data. He has been writing on computer topics for the past several years, including 4 books and about 100 articles in the area. e is also a regular contributor to Redmond magazine.
Dave currently lives outside the United States, where his eclectic nature allows him to pursue projects involving databases, IT infrastructure, web development, archaeology, the ancient Nabataean capital of Petra, medical history, military science, and demography. He can be reached by e-mail at [e-mail], or look for him in Connecticut, Saudi Arabia, or Tasmania, his three favorite haunts.

Product Details

• Paperback: 457 pages
• Publisher: Sybex (September 19, 2006)
• Language: English
• ISBN-10: 0470047445
• ISBN-13: 978-0470047446
• Product Dimensions: 9.2 x 7.4 x 1.2 inches
• Shipping Weight: 5.6 ounces (View shipping rates and policies)
• Average Customer Review: 4.7 out of 5 stars  See all reviews (3 customer reviews)
• Amazon Best Sellers Rank: #1,766,794 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

1 of 1 people found the following review helpful:

5.0 out of 5 stars An excellent exam preparation resource, September 6, 2007

By 

Matthew Bryde (Australia) - See all my reviews

Amazon Verified Purchase

This review is from: MCITP Administrator: MicrosoftSQL Server2005 Database Server Infrastructure Design Study Guide (Exam 70-443) (Paperback)

Having recently studied and sat the prerequisite 070-431 exam, using the 070-431 study guide put out by this same publisher, this book for exam 070-443 is much closer to the Microsoft exam content and format than the 070-431 book. Whereas I gave the 070-431 book 3 stars, due to how closely (or not) the contents matched what was examined, this books in comparison gets 5 stars.

It is NOT a rehash of SQL 2000 material and it is present to the reader in the same style as the 070-443 exam.

Each chapter covers the material to be examined on and then presents a case study with 10 or so questions based on that case study - just as per the exam.

The content is relevant and the style helps the reader become familiar with how the exam is presented. That alone is enough to deserve the 5 stars.

As with any exam preparation, if you are planning on sitting the exam I would still recommend supplementing the material in this book with other sources - I am currently reading the equivalent 070-443 MS Press exam book.

Personally, for this exam, I have found this Sybex title the better suited study guide.

4.0 out of 5 stars Good but not great, January 28, 2008

By 

Scott Moon (Corona, CA United States) - See all my reviews
(REAL NAME)   

This review is from: MCITP Administrator: MicrosoftSQL Server2005 Database Server Infrastructure Design Study Guide (Exam 70-443) (Paperback)

I just finished my test and I was somewhat surprised that a lot of the content in this book was not tested on. I know Microsoft changes the test but I expected that the book would be very close to the exam not in exact questions but in overview. Most of the question on encryption I couldn't find a mention in the book.

I would still use this book but I would caution you to add other books, notes to better emcompass the technology.

2 of 12 people found the following review helpful:

5.0 out of 5 stars More than just a study guide, October 25, 2006

By 

John Matlock "Gunny" (Winnemucca, NV) - See all my reviews
(REAL NAME)   

This review is from: MCITP Administrator: MicrosoftSQL Server2005 Database Server Infrastructure Design Study Guide (Exam 70-443) (Paperback)

Microsoft clearly owns the desktop marketplace, and they are clearly lacking such penetration into the world of big IT systems. For the past few years Microsoft has been orienting their company and their software products towards the enterprise level. With the latest version of SQL Server (2005) Microsoft is increasing their focus towards the larger end of the market. Part of this effort is the creation of the Microsoft Certified IT Professional. This certification is much higher end than the earlier certifications in areas like Word or Excel.

A person with MCITP certification has evidence that he knows how to set up and operate a truly big database. This means multiple databases, running on multiple servers, perhaps in different countries, backed up against disasters, running the latest software upgrades, protected against intruders, operating efficiently with maximum availability and convenience to users.

This book is in part a preparation for the 70-443 examination, but is also a book written by two authors who have been there and done that so that they can speak with personal experience about things that can go wrong.