Microsoft SQL Server Database Design and Optimization: Microsoft Certified IT Professional - Exam 70-443 & Exam 70-450 [Paperback]

Microsoft Official Academic Course (Author)

Book Description

ISBN-10: 0470183748 | ISBN-13: 978-0470183748 | Publication Date: December 21, 2009 | Edition: 1

This book is for students preparing to become certified for the 70-443 and 70-450 Microsoft SQL Server 2005/2008 Database Design and Optimization, Database Administration exam.  The Microsoft Official Academic Course (MOAC) lessons correlate and are mapped to the Microsoft Certified Information Technology Professional (MCITP) 70-443 and 70-450 certification exam.  This text covers installing and configuring  the Microsoft SQL Server, managing and maintaining databases or multidimensional databases, user accounts, database availability, recovery, and reporting.   This book also guides you through designing and implementation of security and server automation.    The MOAC IT Professional series is the Official from Microsoft, turn-key Workforce training program that leads to professional certification and was authored for college instructors and college students. 

MOAC  gets instructors ready to teach and students ready for work by delivering essential resources in 5 key areas:  Instructor readiness, student software, student assessment, instruction resources, and learning validation.   With the Microsoft Official Academic course program, you are getting instructional support from Microsoft; materials that are accurate and make course delivery easy. 

Product Details

• Paperback: 320 pages
• Publisher: Wiley; 1 edition (December 21, 2009)
• Language: English
• ISBN-10: 0470183748
• ISBN-13: 978-0470183748
• Product Dimensions: 10.8 x 8.4 x 0.7 inches
• Shipping Weight: 1.9 pounds (View shipping rates and policies)
• Average Customer Review: 3.0 out of 5 stars  See all reviews (2 customer reviews)
• Amazon Best Sellers Rank: #479,757 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

5 of 5 people found the following review helpful:

2.0 out of 5 stars 70-450 prep materials missing significant content, April 29, 2011

By 

jpseattle - See all my reviews

Amazon Verified Purchase

This review is from: Microsoft SQL Server Database Design and Optimization: Microsoft Certified IT Professional - Exam 70-443 & Exam 70-450 (Paperback)

The book is well laid out, but unfortunately tries to do too much. Summary of my feedback:

- Most of the content is focused on SQL 2005 with 2008 added like what feels like an afterthought.
- Content layout should reflect published 70-450 learning objectives of which there are 6
- Exam contains several questions on software NUMA that is not addressed at all
- Exam contains questions on performance management of threads like lazywriter and checkpoint which are not in the book
- Hardware sizing is a large part of the exam and is not covered well

Unfortunately there is no good alternative as there is no MS Press book available like there is for 70-432. My suggestion would be to look closely at the exam objectives for 70-450 from the Microsoft certification site, determine the delta between this book and what is being examined, and use Technet/MSDN to address the gaps in your studies.

5 of 6 people found the following review helpful:

4.0 out of 5 stars good book but meant for college learning, October 15, 2010

By 

zak - See all my reviews

Amazon Verified Purchase

This review is from: Microsoft SQL Server Database Design and Optimization: Microsoft Certified IT Professional - Exam 70-443 & Exam 70-450 (Paperback)

This book is good, but it is meant for college/instructor led learning. The answers to the knowledge test are available for instructors only. Security (certificates, roles, groups etc) and disaster recovery are covered very well in this book and I did not need to reference other sources. I had to use MSDN or other resources for certain topics like configuring Soft-NUMA, AWE, Maximum Degree of Parallelism, MAXDOP etc.