Binding: Hardcover Dewey Decimal Number: 005 EAN: 9780735622715 ISBN: 073562271X Label: Microsoft Press Manufacturer: Microsoft Press Number Of Items: 1 Number Of Pages: 992 Platform: No Operating System Publication Date: June 28, 2006 Publisher: Microsoft Press Sales Rank: 12464 Studio: Microsoft Press
Product DescriptionAnnouncing 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
Average Rating:
Rating: - Another Successful MCTS 70-431 Exam taker!
[...]
This book is the only book I needed to pass the exam.[...]Of course, it goes without saying that you need an actual experience of the database in order for you to pass the exam (specially the simulation challenges).
Personally, I like the tear-out because it guided me throughout my study of the lessons. Going from page one to the end, page to page, could be overwhelming. The six major topics in the tear-out objectives guideline simplify the study process (you go by "theme"). ... Read More
Rating: - Check Errors at microsoft.com Before Studying
As an exam preparation guide it just about did the job for me; I read the whole book, did all the exercises and practice tests and passed the exam. However, I was disappointed to find so many errors in the book, some of which were not listed on Microsoft's own corrections page for this book on the web, even now, four years after publication. Frustratingly, I also found that some of the answers to practice tests on the CD are blatantly incorrect, leaving me to wonder what to do if the same questions ... Read More
Rating: - A useful reference, and not just for the exam
This book covers the material for the basic SQL 2005 exam fairly well. If one does most of the exercises, one should be able to pass the exam. The practice tests that come with the book are unrealistically difficult - I never cracked 80% on them, yet scored 92% on the exam.
I was a little disappointed that they left out a big step in mirroring - one needs to poke holes in the Windows firewall for it to work. But other than that, the instructions were quite clear, and it was trivial for ... Read More
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.
- Another Successful MCTS 70-431 Exam taker!
- Check Errors at microsoft.com Before Studying
