- Hardcover: 992 pages
- Publisher: Microsoft Press; 1 edition (June 28, 2006)
- Language: English
- ISBN-10: 073562271X
- ISBN-13: 978-0735622715
- Product Dimensions: 7.6 x 2 x 9.2 inches
- Shipping Weight: 3.6 pounds (View shipping rates and policies)
- Average Customer Review: 52 customer reviews
- Amazon Best Sellers Rank: #2,433,976 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification) 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
From the Publisher
Key Book Benefits: - Comprehensive study guide written by exam-certified authors - Deeper, more focused coverage of exam objectives and sub-objectivesplus 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
About the Author
The mentors at Solid Quality Learning combine deep technical expertise and real-world implementation experience to provide advanced solutions and training for the Microsoft SQL Server database platform.
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
You must practice with SSMS if you want any hope to pass the sims. My office is still SS 2000, so here is what I did to prepare:
1. spent $500 on parts from New Egg to build a test box (quad core, 4 gig memory)
2. installed VMware ESXi v4.0 hypervisor (it's free) ... the MS hyperV product is crap!
3. created 4 separate virtual servers
4. installed Windows 2003 (I am MSDN so easy for me) & SS 2005 (free with this book) on all 4 servers
5. installed AdventureWorks
6. backed up the template so I could restore a server to 'fresh & clean' in 5 minutes
7. worked most of the examples in the book, includng Mirroring, Clustering, Alerts, Log Shipping, Linked Servers, etc.
The questions on the CD are excellent practices for the real exam.
For the SSMS simulation:
1. know how to configure Linked Servers (especially the different security models)
2. know how to set up backup & restore operations
3. *NOTE* MS Best-Practices - if you change from Full recovery to Bulk-Logged, set TORN_PAGE_DETECTION ... not mentioned in the book, but found the hint on a blog.
4. know how to read Activity Monitor
Outside of the hands-on skills you need, this book is the only material you need to study. I found it lively and entertaining ... quite exciting to read. The 70-444 book will put you to sleep!
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 book - it's a terrible gauge of what the real deal is like.
It begins with the assumption that you are new to everything SQL and introduces the theory and necessary practices to get you up to speed in SQL Server 2005 implementation and maintenance as quickly as possible. The book requires dedication and time to work through. Most of the practices, particularly those involving the use of SQL Server Management Studio wizards and dialog boxes ( the graphical interface of SQL ) are superbly explained. SQL Server Agent Jobs, Database Snapshots, Mirroring and Log Shipping to name but a few are all beautifully presented and one can certainly apply the book lessons quickly in a work environment. However SQL 2005 implementation and maintenance involves more than just the use of the graphical user interface. Database Administrators must be comfortable working with Transact SQL. The book introduces Transact SQL and moves through the structure and syntax of the language at pace. Those users coming from a non programming background or with no previous exposure to older versions of SQL Server will most probably find Transact SQL challenging and may require further study in the topic beyond that provided by the text book. Overall though an excellant book, both as a preparatory guide for the Microsoft SQL Server 2005 exam and a reference guide. Highly recommended.
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.
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 ...
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 ...
Most recent customer reviews
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...Read more