SQL Server 2005 Books

 Location:  Home > All SQL Server 2005 Books > MCTS SQL Server 2005 Implementation & Maintenance Study Guide (Exam 70-431)  

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

MCTS SQL Server 2005 Implementation & Maintenance Study Guide (Exam 70-431)Author: Tom Carpenter
Publisher: McGraw-Hill Osborne Media
Category: Book

List Price: $49.99
Buy Used: $8.20
as of 9/10/2010 18:08 CDT details
You Save: $41.79 (84%)



New (20) Used (22) from $8.20

Seller: smalltownbookshop
Rating: 4.0 out of 5 stars 16 reviews
Sales Rank: 228856

Media: Paperback
Edition: 3
Pages: 606
Number Of Items: 1
Shipping Weight (lbs): 2.4
Dimensions (in): 9 x 7.2 x 1.5

ISBN: 0072263210
Dewey Decimal Number: 005
EAN: 9780072263213
ASIN: 0072263210

Publication Date: May 30, 2007
Availability: Usually ships in 1-2 business days

Also Available In:

  • Kindle Edition - MCTS SQL Server 2005 Implementation & Maintenance Study Guide (Exam 70-431)

Similar Items:


Editorial Reviews:

Product Description
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



Customer Reviews:
Showing reviews 1-5 of 16



5 out of 5 stars EXCELLENT Prep   September 2, 2007
R. Pearrow (Montana)
12 out of 12 found this review helpful

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.


5 out of 5 stars More than an exam prep book   August 30, 2007
Billy Forsythe (Lexington, KY)
10 out of 10 found this review helpful

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.



5 out of 5 stars Excellent Book   November 2, 2007
Robert A. Cardona
8 out of 8 found this review helpful

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.


5 out of 5 stars Just passed the exam   April 14, 2008
Mike (New York, NY United States)
6 out of 6 found this review helpful

I used this book as my main study guide for 70-431. In general, this book provided the understanding needed for the test. I also found the videos to be helpful. My only criticisms are
1)The actual test is considerably more difficult than the practice exam that comes with this book. I took the pratice exam in 30 minutes while the real test took 2 hours.
2)The topic of db backups (through SQL and SSMS) seems to carry more weight on the test than in the book, so be prepared.

As a side note, the technical editor of this book (Darril Gibson) wrote a All-In-One study guide for several SQL exams. It's an excellent book and I used it as a side reference while studying. If you plan to take all three tests, you may want to save your money and just buy the Gibson book.



5 out of 5 stars Even better than Microsoft's book   January 22, 2008
Juan Jesus Saez Soto (Murcia, Spain)
8 out of 9 found this review helpful

Impressive and exciting. This book is perfectly arranged, documented and skilfully done. I don't usually rate the items five stars.

Showing reviews 1-5 of 16


CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.
Copyright 2008, SQL Server 2005 Books. All Rights Reserved. In association with Amazon.com