MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification) |  | Author: Solid Quality Learning
Publisher: Microsoft Press
List Price: $59.99
Buy New: $14.71
as of 11/22/2009 00:16 CST details
You Save: $45.28 (75%)
New (43) Used (19) Collectible (1) from $14.71
Seller: bookoutlet1
Rating:  49 reviews
Sales Rank: 24573
Platform: No Operating System
Media: Hardcover
Pages: 992
Number Of Items: 1
Shipping Weight (lbs): 3.6
Dimensions (in): 9.1 x 7.7 x 1.9
MPN: 0-7356-2271-X
ISBN: 073562271X
Dewey Decimal Number: 005
EAN: 9780735622715
ASIN: 073562271X
Publication Date: June 28, 2006
Availability: Usually ships in 1-2 business days
| |
| Also Available In:
|
| Similar Items:
| |
| 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 mostincluding 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 answersincluding 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 vouchermaking this kit an exceptional value and a great career investment.
|
| Customer Reviews:
Showing reviews 1-5 of 49
 A superb guide to SQL 2005 September 25, 2009
Paul Gilmore (Carlow, Ireland)
This text book is simply superb.
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.
All you need to pass the exam September 24, 2009
David Martin (South Florida, USA)
The exam is half Q&A, half simulation. I passed the exam (960/1000) using only this book, and several web blogs that discussed this exam and it's simulation questions.
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!
Nice resource for study September 7, 2009
Pedro Morales (San Juan, Puerto Rico)
Some people are going to tell you that to pass an exam you will not need the books, I tell you that you must read and practice with the books. They are a great source of information and goes beyond from answer exams questions.
Very good book! August 30, 2009
Uilton Lobo
This exam material, as another microsoft's material, is a great way to study for certification exam. It explains whit several details about the contents. I recommend!!!!
Great beginning July 5, 2009
Steven R. McEvoy (Canada)
This book was a team effort from the Solid Quality Learning team. The authors include: Daren Bieniek, Randy Dyess, Mike Hotek, Javier Loria, Adam Machanic, Antonia Soto and Adolfo Wiernik. In my experience, sometimes group projects like that fail because of too many hands in the pot. Not in this case. This book is excellently written. The Self-Paced Training Kits (SPTK), are designed for just that - for a person to be able to buy it, and work through the material, either to prepare for the certification exam, or because they want to deepen their knowledge of a product, to either be more proficient in their job or to advance their career. This book will help reach all of those objectives and more. At nearly a thousand pages it is chock full of information to absorb; fortunately it is structured in such a way as to make that possible.
Each chapter begins with a brief introduction of the concepts to be covered. Each concept has its own section. Then there is a great lesson Summary to review and highlight the objectives of the chapters and what you should now know. Then there is a written review, both theoretical questions and practical case studies. The software on the student CD, has self tests, that can be used for chapter review of certification prep. They can be used both in a learning mode or exam mode.
This book was used in the Microsoft academy that I attended. It is a great resource that I am sure to reference for years to come.
Showing reviews 1-5 of 49
|
|
|
|
