Message from Dean - May 8th 2007

I am currently testing out a new version of the APF Bridge Component - If you notice any errors within this demo store please drop me a line.

Binding: Hardcover
Dewey Decimal Number: 005
EAN: 9780735622715
ISBN: 073562271X
Item Dimensions: 362
Label: Microsoft Press
Manufacturer: Microsoft Press
MPN: 0-7356-2271-X
Number Of Items: 1
Number Of Pages: 992
Platform: No Operating System
Publication Date: June 28, 2006
Publisher: Microsoft Press
Studio: Microsoft Press

---

Alternate Versions: Click to Display

Related Items:

• MCITP Self-Paced Training Kit (Exams 70-640, 70-642, 70-646): Server Administrator Core Requirements (PRO-Certification)
• 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 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam (Exam Cram 2)
• Microsoft SQL Server(TM) 2005 Administrator's Pocket Consultant (Pro-Administrator's Pocket Consultant)
• see more

Browse for similar items by category:

• Featured Stores > Amazon.com Stores > Microsoft
• Books > Specialty Stores > Custom Stores > New & Used Textbooks > Computer Science > Database Storage & Design
• Books > Specialty Stores > Custom Stores > New & Used Textbooks > Computer Science > Programming Languages
• Books > Specialty Stores > Custom Stores > New & Used Textbooks > Computer Science > General AAS
• Books > Specialty Stores > Custom Stores > New & Used Textbooks > General AAS

---

Editorial Review:

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.




Rating: - SQL Server Basics
I work with SQL on a daily basis, mostly running queries. I needed a book to fill in all of the holes since I was self taught. This book is a great start at filling in the gaps. It covers everything from the different versions to understanding the design of full-text catalogs. There is also some good material on queries. Great book even if you are not going for a SQL cert.

---

Rating: - As Advertised
This is exactly what you need to study for this test. As it is published by Microsoft, it give you the ability to "think" like Microsoft which is what is needed when taking the test for the MCTS certification in SQL. The test on the CD gives you a chance to find out how much you know and also prepares you for the demanding cert exam.

---

Rating: - Good book, but ditch the practice exam
This thick, hefty book is very thorough and covers MOST of the bases you'll need for the 70-431 exam. There are still some useful details from the SQL Books Online (SQL Server's "help" files) that you should know, but this book gives a good starting point. Reading through each chapter thoroughly and doing every practice lesson will put you well on the road for success at the exam.

Where this book fails completely is the practice test that comes on CD with the book. The questions were very poorly written (sometimes missing vital information required to even discern what area of SQL server the question is supposed to be addressing) and were very dissimilar to the questions on the actual exam.

If you're looking for useful practice for the exam, use another book (like ExamCram) or buy a worthwhile practice test. Or, just take the test itself as practice - it's almost the same price as some of the practice exams on the web. But don't rely on the practice exam in this ... Read More

---

Rating: - Extra Content
I passed the 70-431 Exam using this book and a few others. I really like Murach's stuff better though.

Philip
www.SQLDataBasics.com

---

Rating: - not a good book to use for a job
I had to use this book for a class. It has many mistakes and the quizzes at the end of the chapters ask questions that weren't even covered. Everyone in my class including the instructor agreed that this was not a good book. It either barely discusses or doesn't even cover things that the quizzes ask you about. I am going to find another book to study from before I even think about taking the test. The labs were terrible also, some of them couldn't even be completed as set up by the book. I wouldn't even waste my money on this.

---