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

by Solid Quality Learning (Author) "A key part of installing a new SQL Server 2005 instance is selecting the appropriate SQL Server 2005 edition for the installation..." (more)
Key Phrases: managing replication, server performance, querying data, Server Agent, Books Online, Answers Answers (more...)

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.

From the Publisher
Key Book Benefits: - Comprehensive study guide written by exam-certified authors - Deeper, more focused coverage of exam objectives and sub-objectives—plus instructive case studies and troubleshooting scenarios to enhance your performance on the job - 300 practice questions on CD, with a test engine that enables customized testing, pre-assessment and post-assessment, and automated scoring and feedback - Complete objective-by-objective review section, plus a tear-out exam-mapping grid - Exam tips based on real-world test experience - 180-day evaluation version of SQL Server 2005 Enterprise Edition - 15 percent exam discount voucher from a leading authorized testing center (limited time offer) - Microsoft Encyclopedia of Networking, Second Edition, eBook - Practice files on CD - Entire study guide in searchable eBook format

See all Editorial Reviews

Product Details

• Hardcover: 992 pages
• Publisher: Microsoft Press (June 28, 2006)
• Language: English
• ISBN-10: 073562271X
• ISBN-13: 978-0735622715
• Product Dimensions: 9.1 x 7.4 x 2 inches
• Shipping Weight: 3.6 pounds (View shipping rates and policies)
• Average Customer Review: 3.9 out of 5 stars See all reviews (45 customer reviews)
• Amazon.com Sales Rank: #13,456 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #3 in	Books > Computers & Internet > Certification Central > MS SQL Server
  #7 in	Books > Computers & Internet > Microsoft > Development > SQL Server
  #10 in	Books > Computers & Internet > Certification Central > Publisher > Microsoft Press

Customer Reviews

Most Helpful Customer Reviews

72 of 76 people found the following review helpful:

4.0 out of 5 stars Good book, July 7, 2006

By	Jose A. Campo "A+/Net+/MCSA/MCTS SQL2005" (Houston, TX) - See all my reviews (REAL NAME)

Taking the test which this study guide is focus to is a very important step before give any content's feedback (i'm still preparing myself for the test) But i will give my 1st impression about the book anyway.

Pros:
Very well organized book. Chapters and content are divided in small chunks of information (lessons). For busy people (like me) or those which like to do self study at own pace this is a big aid.

I like the writing style also. Not boring, not too technical altought you should have a previous SQL 2000 background if you want to take full advantage of this book.

I did like chapter 11, the backup and restore processes. This is a must for every SQL admin. and it is well covered. The same for the Maintenance Plan and Job topics (Ch 14)

The 15% off in the test price is a good bonus. You should consider this if you're in a low budget.


Cons or critics:
The test engine is an added value but... i don't know ... after taking a few custom tests ... i am not pretty sure about their content's difficulty. I mean, IMO, questions seems too easy for me. I've took a lot of Microsoft tests before (i'm MCSA) and i've never seen easy questions like these in most of them. You must read a lot and think well before mark an answer and i don't feel that when i'm taking this book's test engine. Do not misunderstand what i'm saying, a free Test Engine is a nice bonus, i just want to give a non parcial review. I'm a customer too and we must rely in good study sources to avoid test failures.

Chapter 5: just a brief T-SQL review; use a Sybex SQL 2000 Design book for better preparation or buy the Ben Forta book instead (ISBN: 0672325675), you won't regret and it will help you a lot.

Chapter 12: hey! what happened with the pics here? ... too much words and just a few pics for this topic. Fragmentation concepts are easier to understand when you see how they works; here's when drawings and pics enter into action.

Final comment.
Currently, this is the only book for this test in the market. Sybex and the others are still in press, so there are not much choices either but overall, is a good election anyway; easy to read and very well organized. Find a good PC or laptop, VMWARE or Virtual PC and that's all you need for your study track (SQL 2005 evaluation version is included)

Need extra info? Try SQL 2005 Stanek pocket book ...

UPDATED 7/26/2006:
I already have the new Sybex book for this test. And 'till now, what i've read so far ... i've not found it better than Solid's book. Some Sybex chapters are just a re impression of their old 70-228 book. I keep you informed ...

12 of 12 people found the following review helpful:

4.0 out of 5 stars Good Book -- great value, December 6, 2006

By	Stephen Moore (Oklahoma City) - See all my reviews (REAL NAME)

I just passed 70-431. I'm a DBA w/ experience on SQL 2005 and SQL 2000. This book and the accompanying CD were the only tools I used to study. I read the book cover to cover, although I skipped the actual practices. (I would only recommend skipping the practices if you have a lot of real world experience with the product.) Then I moved on to the practice tests on CD, and had pretty mediocre passing scores on three practice tests in certification mode (45 questions, answers scored at end). Finally, I used the practice test in study mode, where you could review your answers as you went to drill down into areas that I needed more work on. Having the accompanying practice test (295 questions) makes this kit a great value. I felt as though I learned a lot during all of this and wasn't just "studying for the test". One word on the test format itself -- there were plenty of simulations to do -- everything was not multiple choice.

32 of 39 people found the following review helpful:

5.0 out of 5 stars 2-in-1 training kit, June 9, 2006

By	Arnel J. Domingo "Edupoint" (Phoenix, AZ USA) - See all my reviews (REAL NAME)

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.