MCTS SQL Server 2005 Implementation & Maintenance Study Guide (Exam 70-431) [Paperback]

Tom Carpenter (Author)

Book Description

ISBN-10: 0072263210 | ISBN-13: 978-0072263213 | Publication Date: May 30, 2007 | Edition: 3

The Best Fully Integrated Study System Available

With hundreds of practice questions and hands-on exercises, MCTS SQL Server 2005 Implementation & Maintenance Study Guide covers what you need to know--and shows you how to prepare--for this challenging exam.

• 100% complete coverage of all official objectives for Exam 70-431
• Exam Readiness Checklist at the front of the book--you're ready for the exam when all objectives on the list are checked off
• Inside the Exam sections in every chapter highlight key exam topics covered
• Simulated exam questions match the format, tone, topics, and difficulty of the real exam

Covers all the exam topics, including:

Installing and Configuring SQL Server 2005 * Creating Databases and Database Objects * SQL Server Security * Creating Views, Partitions, and Linked Servers * Transact-SQL Programming * Working with Constraints, Triggers, and Stored Procedures * Backup and Restore of SQL Server with SQL Agent Jobs * Data Redundancy and Availability * Using the Service Broker * XML Data Support * SQL Server Performance Monitoring and Tuning * Troubleshooting Server and Database Errors

CD-ROM includes:

• Complete MasterExam practice testing engine, featuring: One full practice exam; Detailed answers with explanations; Score Report performance assessment tool
• Video training clips from the author
• Electronic book for studying on the go

With free online registration:

• One-hour LearnKey video training session
• Bonus downloadable MasterExam practice test

Editorial Reviews

About the Author

Tom Carpenter, CWNA, CWSP, MCTS is the senior consultant for SYSEDCO.

Product Details

• Paperback: 606 pages
• Publisher: McGraw-Hill Osborne Media; 3 edition (May 30, 2007)
• Language: English
• ISBN-10: 0072263210
• ISBN-13: 978-0072263213
• Product Dimensions: 9.1 x 7.4 x 1.3 inches
• Shipping Weight: 2.4 pounds (View shipping rates and policies)
• Average Customer Review: 4.2 out of 5 stars  See all reviews (16 customer reviews)
• Amazon Best Sellers Rank: #1,225,580 in Books (See Top 100 in Books)

More About the Author

Tom Carpenter is the author of multiple books on Wireless and Windows Technology as well as resources covering project management, leadership and life success. He lives in Ohio with his wife and four wonderful children.

As the Senior Consultant for SYSEDCO, Tom Carpenter directs the organization and provides training and consulting to IT groups throughout the United States. His Wireless Networking Boot Camp, Windows Networking Boot Camp, and IT Project Management Boot Camp events provide the in-depth knowledge technology professionals need to get ahead.

Look for his book, Foundations of Effectiveness: Making a Success of Your IT Career in late 2009.

Customer Reviews

Most Helpful Customer Reviews

12 of 12 people found the following review helpful:

5.0 out of 5 stars EXCELLENT Prep, September 2, 2007

By 

R. Pearrow "Rick" (Montana) - See all my reviews
(REAL NAME)   

This review is from: MCTS SQL Server 2005 Implementation & Maintenance Study Guide (Exam 70-431) (Paperback)

It's nice to have a prep book that is not only easy to follow, but actually prepares you for the test. I found Tom's book very staightforward, and it's very accessable as a reference book as well. If you're planning on taking the certification test for SQL 2005, you can't go wrong with this book. It also helped prep me for teaching SQL in my workshops across the country. The book is one of the resources I carry on the road with me.

8 of 8 people found the following review helpful:

5.0 out of 5 stars Excellent Book, November 1, 2007

By 

Robert A. Cardona - See all my reviews
(REAL NAME)   

This review is from: MCTS SQL Server 2005 Implementation & Maintenance Study Guide (Exam 70-431) (Paperback)

Great book, it entails inside details for advanced DBA's and yet covers the basics for those just getting started with SQLServer. This book is well organized for quick reference, along with examples for certification that will benefit daily use, extending into professional development. You will learn more than DB skills, reading and following his examples. I recommend SQLServer 2005 Implementation and Maintenance Study Guide for all IT enthuses.

8 of 8 people found the following review helpful:

5.0 out of 5 stars More than an exam prep book, August 30, 2007

By 

Billy Forsythe "Trainer/Consultant" (Lexington, KY) - See all my reviews

This review is from: MCTS SQL Server 2005 Implementation & Maintenance Study Guide (Exam 70-431) (Paperback)

The thing I liked most about this book was the fact that I can acutally use it after the test. I have the Microsoft Press book that is also intended as a prep tool for the 70-431 exam, but it will be useless to me as a reference. This book has such a good chapter on SQL and excellent "real-world" type coverage in the other chapters that will allow me to use it as an ongoing reference.

Having used the other book (the one from Microsoft Press) and this one, I can tell you that this book gives you all the information of the Microsoft Press book and then some. I'm glad I used both books in my preparation, but this book is definitely the one that will stay on my shelf.