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

Darril Gibson (Author)

Book Description

ISBN-10: 0071546693 | ISBN-13: 978-0071546690 | Publication Date: March 18, 2008 | Edition: 1

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

Editorial Reviews

About the Author

Darril Gibson, MCT, MCDBA, MCSD, MCITP, is a professional trainer specializing in Microsoft technologies. He is the author of MCITP SQL Server 2005 Database Administration All-in-One Exam Guide.

Product Details

• Hardcover: 944 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (March 18, 2008)
• Language: English
• ISBN-10: 0071546693
• ISBN-13: 978-0071546690
• Product Dimensions: 9.2 x 7.6 x 2.2 inches
• Shipping Weight: 3.8 pounds (View shipping rates and policies)
• Average Customer Review: 4.6 out of 5 stars  See all reviews (7 customer reviews)
• Amazon Best Sellers Rank: #69,234 in Books (See Top 100 in Books)
  • #24 in Books > Computers & Technology > Microsoft > Development > SQL Server
  • #35 in Books > Computers & Technology > Certification > Microsoft

More About the Author

After a 22 year Navy career working with computers and electronics, I've turned my attention to computers, teaching and writing, especially related to IT certifications.

I've been focused on IT-related security quite a bit in the last few years, teaching, writing, and editing. I have written security related books including books on Security+, SSCP, MTA Security, Risk, and more.

Current security certifications include Security+, CASP, SSCP, and CISSP. Additionally, I've passed 37 Microsoft tests and earned 19 Microsoft certifications (maybe more by the time you read this) and a few non-Microsoft certifications. Check out my Microsoft transcript here: mcp.microsoft.com/authenticate/validatemcp.aspx.
Transcript ID: 660310
Access Code: DarrilGibson

I understand how the Microsoft testing and certification process works. As an MCT since 1999, I've helped countless students learn Microsoft products and become certified. Additionally, I've helped hundreds of students earn the Security+ certification over the years, and thousands have passed the Security+ certification using one of my books.

One of the treasured joys in my life is getting emails from past students and readers letting me know they've become certified and/or moved up in their job status. Feel free to contact me through GetCertifiedGetAhead.com.

Customer Reviews

Most Helpful Customer Reviews

13 of 14 people found the following review helpful:

5.0 out of 5 stars Passed all 3 exams, April 14, 2008

By 

Mike (New York, NY United States) - See all my reviews

Amazon Verified Purchase

This review is from: MCITP SQL Server 2005 Database Developer All-in-One Exam Guide (Exams 70-431, 70-441 & 70-442) (Hardcover)

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 always accurate. Also - the explanation of cascade deletes is incorrect in the book.

12 of 13 people found the following review helpful:

5.0 out of 5 stars Just what I needed, March 29, 2008

By 

Mike Berry (Georgia) - See all my reviews

This review is from: MCITP SQL Server 2005 Database Developer All-in-One Exam Guide (Exams 70-431, 70-441 & 70-442) (Hardcover)

The end-of-chapter exam questions were perfect for helping me know what I know and what I don't know. I already passed the 70-431 and 70-441 exams and the questions I looked at in the back of the chapters hit the knowledge needed to pass these exams.

Unfortunately I failed the 70-442 exam before this book was released. However, after reviewing the end-of-chapter exam questions, I saw exactly what I needed to brush up on. I spent several days in a marathon study session doing the exam questions in the back of each chapter for the 70-442. For anything I missed, I studied the material in the chapter. In addition to learning what I needed for the exam, I also learned a couple things I didn't know about in SQL Server 2005. I then took and passed the 70-442.

This book was just what I needed. I only wish I had it before I took the 70-442 the first time.

7 of 8 people found the following review helpful:

5.0 out of 5 stars All you need to pass the MCITP Database Developer, June 21, 2008

By 

T. Rodgers - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: MCITP SQL Server 2005 Database Developer All-in-One Exam Guide (Exams 70-431, 70-441 & 70-442) (Hardcover)

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.