MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification) |  | Author: Solid Quality Learning
Publisher: Microsoft Press
Category: Book
List Price: $59.99
Buy Used: $4.84
as of 9/10/2010 08:46 EDT details
You Save: $55.15 (92%)
New (27) Used (44) from $4.84
Seller: atlanta-book-company
Rating:  51 reviews
Sales Rank: 77532
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: May 31, 2006
Availability: Usually ships in 1-2 business days
| |
| Features:
| • | ISBN13: 9780735622715 | | • | Condition: USED - Very Good | | • | Notes: BUY WITH CONFIDENCE, Over one million books sold! 98% Positive feedback. Compare our books, prices and service to the competition. 100% Satisfaction Guaranteed |
|
| 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 51
 2-in-1 training kit June 9, 2006
Arnel J. Domingo (Phoenix, AZ USA)
34 out of 41 found this review helpful
These 2 extras alone is worth more than the price of this book: First, there is the 15% discount on MCP exams. This translates to about $15. Then, there is the practice test software with 295 questions which is very similar to other commercial practice tests (cost at least $59). NOTE: I bought this book from other site because this book was already available there a week earlier than here at Amazon. The price of this book in Amazon is about $8 lower.
This is a hard bound book (I'm very impressed of the cover design). The papers are white and of high quality.
The contents are organized by exam objectives (there is also a card you can tear from the book that outlines the exam objectives and tells you what chapter and lesson you will find the objective discussed in the book). Every lesson has its summary and review questions. Reading some lessons and browsing through the pages of the book, I believe this is a comprehensive study guide for this exam and is, by itself, sufficient to prepare you to pass the exam.
Outstanding Technical Book February 24, 2007
Clyde LeBonz (PORTLAND, OR United States)
9 out of 11 found this review helpful
Outstanding technical book. It covers many areas of a very rich and complex product, and covers almost all of these areas well. The writing style and presentation is excellent. It will be useful to DBA's whether or not they go for the Microsoft certification. The extremely thorough chapter on XML is particularly impressive.
I am a SQL Server developer and instructor for Microsoft SQL Server 2000/2005 certification courses, and recommend this text to students who plan to take MCTS cert exam 70-431.
I recommend reading the book straight through, performing practice labs as desired, then using the Transcender practice exam to reveal your weak areas. If you set yourself a goal of 20-30 pages a day (hard to absorb much more), you'll finish in a month or two.
I passed the MCTS exam with a high grade, but thanks only in part to the practice exam that comes with this text. The text's one weakness is that the practice questions are not at all like those on the real cert exam; they are more like flash-card type questions. Even the Transcender exam was not up to their usual standards, but it is much better than what is included with the book.
The quality of the book itself, however, aside from the practice questions, is excellent. Highly recommended.
All you need to pass the exam September 24, 2009
David Martin (South Florida, USA)
3 out of 3 found this review helpful
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!
Good for reference and for the exam August 26, 2006
Glenn Berry (Parker, CO)
4 out of 5 found this review helpful
This is one of the best Microsoft Press Training kits that I have seen. It has good overall coverage of the administrative features of SQL Server 2005 in addition to covering the exam objectives. It also has some useful dynamic management view (DMV) queries. It has a good lesson on how table partitioning works, which is very useful. Overall, a very valuable book.
Another Successful MCTS 70-431 Exam taker! July 1, 2009
Marlon A. Ribunal (Long Beach, CA USA)
1 out of 1 found this review helpful
[...]
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").
I am very satisfied with this book, not only because I passed the 70-431 exam but also it serves as a good reference.
Highly recommended!
-Marlon Ribunal
[..]
Showing reviews 1-5 of 51
|
Microsoft BizTalk
Microsoft BizTalk server streamlines business processes so you can concentrate on making your business succeed. BizTalk and other Microsoft server products available at Carnal Software give your business a competitive advantage that cuts operational costs and enhances productivity. |
Microsoft Server
Employ a wide-range of Microsoft server applications and organize your small business to keep it functioning smoothly. Windows and SQL servers bring all of Microsoft’s cutting-edge technologies to your fingertips. |
Microsoft SharePoint
Whether you are across the hall or across the world, easily share information with colleagues using the Microsoft SharePoint server. This comprehensive content management system maximizes efficiency within your organization and at deeply discounted prices; you can’t afford to not have an effective way to share information within and out of your organization. |
Windows
Find personal computing programs for your Windows operating system all at deeply discounted below retail prices. Learn better typing skills, how to speak Spanish and find an assortment of other graphics and word processing applications like Adobe and Microsoft Office. |
Server
Find about any server application for Windows or Mac. Different Microsoft server application help you effectively manage your business and keep it running smoothly. Products like Microsoft SharePoint that allow you to easily exchange information between colleagues along with similar software applications for Mac systems are available here at much lower costs than you would find in a retail store. |
Database
Database software applications and learning tools help you organize your office, your finances, even your life. Most, if not all database software applications are compatible with the Windows operating system. Never lose important data again or be disorganized for your next meeting. |
Productivity
Organize your finances, learn a new language or skill and even make your own will with Productivity software solutions from Carnal Software. Available software works with the Windows operating system but we also have a wide variety of programs for Mac to choose from. |
Accounting
Bookkeeping and accounting software helps you run a business or your family’s finances with just the click of a mouse. Programs are available for both the Windows and Mac operating systems. Maintain your productivity and always know where you stand financially with accounting software products from Carnal Software. |
Books: Microsoft BizTalk
Knowing how to harness all of the features of the BizTalk server is a large part to streamlining business processes and making your business run as smoothly as possible. BizTalk knowledge resources from Carnal Software help you easily learn BizTalk quickly! |
Books: Microsoft Server
Step-by-step Microsoft server guides help you easily learn the ins and outs of all the cutting edge Microsoft server applications. They’re designed to train you to effectively use all of the features in Windows Vista, Microsoft BizTalk and other applications for organizing your work and life. |
Books: Microsoft SharePoint
Easily learn how to use Microsoft SharePoint to share information with colleagues and business associates with SharePoint books at CarnalSoftware.com. Understand all of the components and features SharePoint has to make your company function more efficiently. |
Books: Windows
Find training and support materials and quickly learn how to effectively utilize your Windows server or Windows operating system. Official Windows training manuals and curriculum available at CarnalSoftware.com helps you learn all of the useful features of your system. |
Books: Server
Effectively utilize your Windows server with Microsoft training manuals and resources to get the most from your Windows server investment. |
Books: MS Certificate
Find Microsoft training manuals to learn how to effectively use Microsoft server products and become a certified Microsoft technician. Manuals and programs available at CarnalSoftware.com can give you a competitive advantage in today’s tough job market. |
|
|
|
|
Retail web solutions and shopping cart optimization: SEO Commerce: an architecture for your retail e-commerce site's product catalog and shopping cart that lets you gain additional power and visibility day in and day out. Visit SEO Advantage Online Library for search engine optimization tips and more...
|
|
|
|
|
