MCITP Developer: Microsoft SQL Server 2005 Database Solutions Design [Paperback]

Victor Isakov (Author)

Book Description

ISBN-10: 0470040521 | ISBN-13: 978-0470040522 | Publication Date: September 25, 2006

• This comprehensive book guides readers through Microsoft's brand- new SQL 2005 certification: Microsoft Certified IT Professional Developer for SQL Server 2005 (Exam 70441)

   

• Topics covered include writing SQL queries, designing and implementing programming objects, database optimization, designing databases at both the conceptual and logical levels, and implementing databases at the physical level

   

• Aimed at candidates for this exam, namely professional database developers who are responsible for designing and implementing database solutions using SQL Server 2005

   

• The CD-ROM features leading-edge exam prep software with test engine plus hundreds of practice questions and electronic flashcards

For Instructors: Teaching supplements are available for this title.

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-441, PRO: Designing Database Solutions by Using Microsoft SQL Server 2005, one of two required Professional Developer exams in the MCITP: Database Developer 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-441

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-441.

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 CD, you'll find the entire book in searchable and printable PDF. Study anywhere, any time, and approach the exam with confidence.

www.sybex.com

About the Author

Victor Isakov is a database architect and Microsoft certified trainer based in Sydney, Australia. He provides consulting and training services to organizations in the public, private, and NGO sectors globally. He has authored a number of books on SQL Server and worked closely with Microsoft to develop the new generation of SQL Server 2005 Certification and Microsoft Official Curriculum for both ILT and e-Learning.

Product Details

• Paperback: 608 pages
• Publisher: Sybex (September 25, 2006)
• Language: English
• ISBN-10: 0470040521
• ISBN-13: 978-0470040522
• Product Dimensions: 9 x 7.1 x 1.4 inches
• Shipping Weight: 2 pounds (View shipping rates and policies)
• Average Customer Review: 2.3 out of 5 stars  See all reviews (3 customer reviews)
• Amazon Best Sellers Rank: #1,886,944 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

5 of 6 people found the following review helpful:

1.0 out of 5 stars Errors abound, January 19, 2007

By 

Tim D. Masters - See all my reviews
(REAL NAME)   

This review is from: MCITP Developer: Microsoft SQL Server 2005 Database Solutions Design (Paperback)

I have only read through the first chapter and the associated questions and answers and I have already found many errors. I am not talking about a "matter of opinion" error, I am talking about hard errors.

As an example, question 20 of chapter one lists several answers, A-F. The correct answer is E, create a field as a persisted computed column. However in the answers section, it gives the correct answer as D, and goes on to explain that answer D is correct because it creates a persisted computed column. That is incorrect. Answer D only includes creating a computed column, not a persisted one.

I hope it gets much better as I go along. Unless this test is MUCH easier than other Microsoft tests, the questions in this book are far too easy.

4 of 5 people found the following review helpful:

5.0 out of 5 stars Passed the exam!, January 16, 2007

By 

Linda Duncan (Smithville, TN United States) - See all my reviews

This review is from: MCITP Developer: Microsoft SQL Server 2005 Database Solutions Design (Paperback)

I'm not sure what the other reviewer was expecting, but studying for and passing the 70-441 Exam was my focus. The book covered the material well and I passed the exam. The Case Studies were very helpful as the entire exam was the exact same format. There are 10 additional case studies on the CD. I found only 2 minor technical errors (they all have some errors) and a couple of mistakes in the question answers - they were easy to identify. Yes, it would have been nice to copy the code out of the PDF file. All in all, I'm very satisfied.

1 of 1 people found the following review helpful:

1.0 out of 5 stars Poorly Written; Frustrating to Read, October 24, 2007

By 

Brian McCullough (Southern NJ United States) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: MCITP Developer: Microsoft SQL Server 2005 Database Solutions Design (Paperback)

This book is very poorly written. The amount of grammatical and spelling errors are driving me insane!! Not to mention I am finding some of the same technical errors mention in other reviews about this book. Did it even go through a review process (both technical and grammatical)???

The one benefit of this book is the Sample Case Studies. I have used some other study materials and the wording and types of questions from this book appear to be inline with some of the other materials I have used.

I am taking the test this weekend (10/27/2007). The majority of my study efforts have been with this book (reading it cover to cover), so I hope this has enough information to get me through the exam, but I am currently having doubts.