MCITP SQL Server 2005 Database Developer All-in-One Exam Guide (Exams 70-431, 70-441 & 70-442)

All-in-One is All You Need

Get complete coverage of all three Microsoft Certified IT Professional database developer exams for SQL Server 2005 in this comprehensive volume. Written by a SQL Server expert and MCITP, this definitive exam guide features learning objectives at the beginning of each chapter, exam tips, practice questions, and in-depth explanations. Detailed and authoritative, the book serves as both a complete certification study guide and an essential on-the-job reference.

Get full details on all exam topics including how to:

Install and configure SQL Server 2005
Manage database design
Use Transact-SQL and XML
Work with functions, triggers, and CLR integration
Optimize, monitor, and secure databases
Create stored procedures
Handle disaster recovery
Work with Service Broker, Web Services, and MARS
Use SQL Server Reporting Services and Notification Services
Manage locks, deadlocks, and cursors
Transfer data using Replication and SQL Server Integration Services

The CD-ROM features:

Six full practice exams-two for each exam: 70-431, 70-441, & 70-442
Scripts from the step-by-step exercises in the book
Video training clips from the author
Complete electronic book

Customer Reviews:

Passed all 3 exams

By Mike - April 14, 2008

For the 431 exam, I used the (Tom) Carpenter book as my primary study guide and this book as a side reference. My main reason for purchasing this book is for the next two exams (441,442). After taking the 431 test and looking up some questions I guessed at in this book, I regret not using this book as my primary study guide. This book seems to point out the exact information needed to get through the test. I look forward to using it for the next two exams. Note that the author of this book is the technical editor for the Carpenter book.

Update to previous review:
I just passed both exams (441 & 442) without difficulty and with plenty of time remaining (each exam took about 2 hours). This is definitely the book to use for these exams. The topics and sample questions are on target with the actual test. Be sure to review the topic list for each exam in the front of the book before taking the test. The 'what you need to know' section at the end of each chapter is not... read more

All you need to pass the MCITP Database Developer

By T. Rodgers - June 21, 2008

Well written and in depth, this book should cover everything necessary to pass these tests.

I have two complaints:

1) The book is laid out functionally for SQL Server, not for each test. So, for example, when you are studying for the 70-442, it may involve a portion of chapter 3, 4, 5, and 8, but all of 12 and 13. All this information is entwined with the stuff for the other tests.

2) You choose to only take one of the tests on the CD. For example - you couldn't say just test for the 70-441 test. I found the CD questions less useful than books dedicated to one test because of this.

These are minor complaints though, and I'm not really sure the issues can be avoided to begin with. Don't let them stop you from using this as your resource to pass these three tests.

excellent guide for exam and reference book

By J. Bluestein "jb" - March 10, 2010

I'm prepping for my first Microsoft exam 70-431. Should I not get laid off, I'll use the book for the other Microsoft DataBase Developer exams as well.

The book is well written, thorough and the chapter review questions are challenging. This is an excellent book to learn a demanding subject. I'll be back to re-review my review and perhaps add that 5th star after the exam.

I have 30 years experience in informatoin technology this is one of the best reference books I own.