Library of Math
New and Used Math Books at Great Low Prices
Subscribe to the Library of Math Feed

MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)

MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)

enlarge enlarge 
Author: Solid Quality Learning
Publisher: Microsoft Press
Category: Book

List Price: $59.99
Buy New: $32.00
You Save: $27.99 (47%)



New (35) Used (13) Collectible (1) from $26.45

Rating: 4.0 out of 5 stars 39 reviews
Sales Rank: 11071

Platform: No Operating System
Media: Hardcover
Pages: 992
Number Of Items: 1
Shipping Weight (lbs): 3.6
Dimensions (in): 9.1 x 7.4 x 2.1

MPN: 0-7356-2271-X
ISBN: 073562271X
Dewey Decimal Number: 005
EAN: 9780735622715

Publication Date: June 28, 2006
Availability: Usually ships in 1-2 business days

Similar Items:

  • MCITP Self-Paced Training Kit (Exams 70-640, 70-642, 70-646): Server Administrator Core Requirements (PRO-Certification) (PRO-Certification)
  • MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam (Exam Cram 2)
  • MCITP Self-Paced Training Kit (Exam 70-441): Designing Database Solutions by Using Microsoft SQL Server(TM) 2005 (Self-Paced Training Kits)
  • MCITP Self-Paced Training Kit (Exam 70-442): Designing and Optimizing Data Access by Using Microsoft SQL Server(TM) 2005 (Self-Paced Training Kits)
  • MCTS Self-Paced Training Kit (Exam 70-536): Microsoft .NET Framework 2.0 Application Development Foundation

Editorial Reviews:

Product Description
Announcing an all-new MCTS Training Kit designed to help maximize your performance on Exam 70-431, a core exam for the new Microsoft IT Professional certifications. This kit packs the tools and features that exam candidates want most including in-depth, self-paced training based on final exam content; rigorous, objective-by-objective review; exam tips from expert, exam-certified authors; and a robust testing suite. It also provides real-world scenarios, case study examples, and troubleshooting labs for skills and expertise that you can apply to the job.

Focusing on SQL Server 2005, this official study guide covers topics such as installing and configuring SQL Server, implementing database mirroring, managing database snapshots, working with XML and flat files, managing replication, backing up and restoring a database, monitoring and troubleshooting, and creating and implementing database objects.

Ace your exam preparation and ramp up quickly on SQL Server 2005 database administration by working at your own pace through the lessons, hands-on exercises, and practice tests. The flexible, best-of-class test engine on CD features 300 practice questions and pre-assessment and post-assessment capabilities. Choose timed or untimed testing mode, generate random tests, or focus on discrete objectives or chapters, and get detailed explanations for right and wrong answers including pointers back to the book for further study. You also get a 180-day evaluation version of SQL Server 2005 Enterprise Edition and a 15 percent exam discount voucher making this kit an exceptional value and a great career investment.


Customer Reviews:   Read 34 more reviews...

5 out of 5 stars 2-in-1 training kit   June 9, 2006
Arnel J. Domingo (Phoenix, AZ USA)
32 out of 39 found this review helpful

These 2 extras alone is worth more than the price of this book: First, there is the 15% discount on MCP exams. This translates to about $15. Then, there is the practice test software with 295 questions which is very similar to other commercial practice tests (cost at least $59). NOTE: I bought this book from other site because this book was already available there a week earlier than here at Amazon. The price of this book in Amazon is about $8 lower.

This is a hard bound book (I'm very impressed of the cover design). The papers are white and of high quality.

The contents are organized by exam objectives (there is also a card you can tear from the book that outlines the exam objectives and tells you what chapter and lesson you will find the objective discussed in the book). Every lesson has its summary and review questions. Reading some lessons and browsing through the pages of the book, I believe this is a comprehensive study guide for this exam and is, by itself, sufficient to prepare you to pass the exam.



5 out of 5 stars Excellent Book. Good exam preperation   December 29, 2006
Aftab Zafar (Dallas, TX)
3 out of 3 found this review helpful

Very good book. Detailed chapters. Things to remember are highlighted. End of chapter questions were highlighted. For those who are experienced with SQL 2000, you will find most of this book redundant, as most of the stuff comes from SQL 2000. But it does a good job explaining new technologies i.e. Service Broker, Contract/Queue, Partitioning etc.

For those who want to sit for the 70-431 exam, i suggest getting brain dump for this exam (free) or buy a testking cram. I passed on 12/19 with 947. Yeehaa!



5 out of 5 stars Good for reference and for the exam   August 26, 2006
Glenn Berry (Parker, CO)
4 out of 5 found this review helpful

This is one of the best Microsoft Press Training kits that I have seen. It has good overall coverage of the administrative features of SQL Server 2005 in addition to covering the exam objectives. It also has some useful dynamic management view (DMV) queries. It has a good lesson on how table partitioning works, which is very useful. Overall, a very valuable book.


5 out of 5 stars Outstanding Technical Book   February 24, 2007
Clyde LeBonz (PORTLAND, OR United States)
6 out of 8 found this review helpful

Outstanding technical book. It covers many areas of a very rich and complex product, and covers almost all of these areas well. The writing style and presentation is excellent. It will be useful to DBA's whether or not they go for the Microsoft certification. The extremely thorough chapter on XML is particularly impressive.

I am a SQL Server developer and instructor for Microsoft SQL Server 2000/2005 certification courses, and recommend this text to students who plan to take MCTS cert exam 70-431.

I recommend reading the book straight through, performing practice labs as desired, then using the Transcender practice exam to reveal your weak areas. If you set yourself a goal of 20-30 pages a day (hard to absorb much more), you'll finish in a month or two.

I passed the MCTS exam with a high grade, but thanks only in part to the practice exam that comes with this text. The text's one weakness is that the practice questions are not at all like those on the real cert exam; they are more like flash-card type questions. Even the Transcender exam was not up to their usual standards, but it is much better than what is included with the book.

The quality of the book itself, however, aside from the practice questions, is excellent. Highly recommended.




5 out of 5 stars Extremely well written   May 30, 2007
SharePoint Guru
4 out of 6 found this review helpful

I have been working with SQL Server since version 4.2. Since then, there have been a lot of books written, but few of this quality. The principal author has a gift for clear and succinct writing that only comes from knowing a topic well. Time and time again I marveled at how few words he used to explain complex technical topics. I recommend this book highly not only for those seeking certification, but also for those who wish to learn how to implement and maintain SQL Server 2005. Money well spent.

 
about us contact us privacy policy terms of use mision statement lom help
The Library of Math - Online Math Organized by Subject Into Topics. © 2005 - 2008 www.LibraryOfMath.com All rights reserved. math rss