MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
The MCTS 70-431 Exam Cram is a must-have resource in your MCTS 70-431 exam preparation. The Exam Cram focuses on exactly what you need to know to get certified. This includes features like:
Complete coverage of all 70-431 exam objectives
Exam alerts, practice questions, notes, tips, sidebars, cautions, test-taking strategies, and time-saving tips
Access to MeasureUp practice questions and innovative testing software
The popular Cram Sheet tear card, giving you the key facts you should review before you enter the testing center
Insight from author Thomas Moore, a Microsoft Certified Trainer (MCT) and SQL Server expert who has helped hundreds of students earn their SQL Server certifications
Sailing Through SQL 2005
By Brainbuz - January 3, 2007
I have six years experience working with earlier versions of SQL Server. SQL 2000 was also the only Microsoft Professional Exam I ever failed (in all honesty I wasn't really ready for the test and still only missed by 2 questions). With the new Vista/Longhorn series coming out I need to update my MCSE and this is the first of the new electives available and a product series I really want to document my competency in.
What makes SQL Server harder than many of the other exams in the MCSE/MCSA track is that you have to deal with a lot of programming issues and on top of that nearly everything can be done from the Command Line (SQL Queries), so you really need to go in knowing a lot of SQL commands. In addition SQL 2005 has packed in a lot of features - CLR (which lets developers interface other programming languages directly to SQL Server), enhanced XML support, a variety of distributed database configurations that can be created, etc.
This is a book designed purely to get you a passing grade on the Microsoft Certified Technical Specialist 70-431 test on Implementing and Maintaining Microsoft SQL Server 2005. Note that this test is not concerned with the use of a database, there's nothing on areas like programming in T-SQL. Instead it's oriented more to the database administrator.
A lot of exam preperation books are oriented around just the test. This book is written more in a standard text format, and it's a pretty good introduction to setting up the database. Each chapter has a small test to see what you learned, then at the end of the book there are two separate sample tests that are in the same format as in the real examination. Of course here you can then turn to the next chapter and there is the answers to all of the practice questions, something you won't find on the real test.
The book is written in a fairly simple tone so that reading it doesn't put you to sleep quite as fast as a lot... read more
Good for just the test
By R. Pathak - May 21, 2007
First of all, I just passed the test with very comfortable score. I did prepare for this test with this book along with MS training guide. It is very difficult to remember exactly where did the questions come from, but here is the overview to those who are starting to prepare.
This book is meant just for this test. It has a very direct focus on the test. Many times, it is much more useful if one has the background information which this book does not necessarily cover. So, in my opinion, starting the preparation with the training guide and finishing with this book is a good strategy to pass the test and also, to become a good DBA ( which is more important).