MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)

MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)
by Solid Quality Learning

MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)
List Price: $59.99
Our Price: $41.99
You Save: $18.00 (30%)
Availability: Usually ships in 1 to 2 months
Buy Used: from $1.06 (click here)
Category: Book
See more book details and other editions


(Click here)
Buy this book at online book store in your country
Canada | UK | Germany | France

Book Summary Information

Author: Solid Quality Learning
Edition: Hardcover
Audio: English (Unknown); English (Original Language); English (Published)
Published: 2006-06-28
ISBN: 073562271X
Number of pages: 992
Publisher: Microsoft Press

Book Reviews of MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)

Book Review: All you need to pass the exam
Summary: 5 Stars

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!

Summary of MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)

Exam Prep Guide

Ace your preparation for the skills measured by MCTS Exam 70-431—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what you?ve learned by applying your knowledge to real-world case scenarios and practices. This official Microsoft study guide is designed to help you make the most of your study time.

Maximize your performance on the exam by learning to:

  • Install and configure SQL Server
  • Create tables and indexes, define columns, and implement constraints
  • Implement functions, stored procedures, and triggers by using Transact-SQL
  • Work with relational and XML data
  • Monitor, troubleshoot and tune queries
  • Maintain database availability with log shipping, database mirroring, and replication
  • Prepare a backup strategy and restore a database

Practice Tests

Assess your skills with practice tests on CD. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers?including a customized learning path that describes how and where to focus your studies.

Your training kit includes:

  • 15% exam discount from Microsoft. Offer expires 12/31/10. Details inside.
  • Official self-paced study guide.
  • Practice tests with multiple, customizable testing options and a learning plan based on your results.
  • 450 practice and review questions.
  • Case scenarios, practice exercises, and best practices.
  • 180-day evaluation version of Microsoft SQL Server 2005 Enterprise Edition.
  • Fully searchable eBook.

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

Certification Central Books

Book Subjects
Most talked about in Certification Central Books
QoS and Traffic Management in IP and ATM Networks ImageQoS and Traffic Management in IP and ATM Networks
by David McDysan
McGraw-Hill Companies; Published: 1999-11-01; Paperback; Book
Best price: $47.86
Price in other shops: $55.00
Accelerated Lotus Notes Application Development Study Guide ImageAccelerated Lotus Notes Application Development Study Guide
by Libby Ingrassia Schwarz
McGraw-Hill Companies; Published: 1998-12-30; Paperback; Book
Best price: $6.50
Price in other shops: $29.99
Real World Java 2 with CDROM (Java Masters) ImageReal World Java 2 with CDROM (Java Masters)
by Justin Couch
McGraw-Hill Companies; Published: 1999-01; Paperback; Book
Best price: $146.45
A+ Certification DOS/Windows (Accelerated A+ Certification Study Guide) ImageA+ Certification DOS/ Windows (Accelerated A+ Certification Study Guide)
Computing Mcgraw-Hill; Published: 1998-12; Paperback; Book
Best price: $12.80
Price in other shops: $24.99
PowerPoint 2000 Expert Microsoft Office User Specialist and Certification Procedures ImagePowerPoint 2000 Expert Microsoft Office User Specialist and Certification Procedures
Glencoe McGraw-Hill; Published: 2000-01-01; Unknown Binding; Book
Excel 97: Certification Procedures (Glencoe Comprehensive Approach Series) ImageExcel 97: Certification Procedures (Glencoe Comprehensive Approach Series)
by Carole Tobias
Mcgraw-Hill (Tx); Published: 1997-10; Hardcover; Book
Price in other shops: $40.75
Computer Networks (4th Edition) ImageComputer Networks (4th Edition)
by Andrew S. Tanenbaum
Prentice Hall; Published: 2002-08-19; Hardcover; Book
Best price: $19.84
Price in other shops: $120.67
CompTIA A+ Certification All-in-One Exam Guide, Sixth Edition ImageCompTIA A+ Certification All-in-One Exam Guide, Sixth Edition
by Michael Meyers
McGraw-Hill Osborne Media; Published: 2006-12-21; Hardcover; Book
Best price: $19.95
Price in other shops: $59.99
Sun Certified Programmer for Java 2 Study Guide (Exam 310-025) (Book/CD-ROM package) ImageSun Certified Programmer for Java 2 Study Guide (Exam 310-025) (Book/ CD-ROM package)
by Syngress Media Inc
McGraw-Hill Companies; Published: 2000-03-03; Hardcover; Book
Best price: $7.30
Price in other shops: $49.99
McGraw Hill's Encyclopedia of Networking and Telecommunications with CDROM (Network Professional's Library) ImageMcGraw Hill's Encyclopedia of Networking and Telecommunications with CDROM (Network Professional's Library)
by Tom Sheldon, Thomas Sheldon
McGraw-Hill Companies; Published: 2001-01; Hardcover; Book
Best price: $19.95
Price in other shops: $79.99
Similar Books and other products
MCITP Self-Paced Training Kit (Exam 70-443): Designing a Database Server Infrastructure Using Microsoft SQL Server 2005 (Pro Certification) ImageMCITP Self-Paced Training Kit (Exam 70-443): Designing a Database Server Infrastructure Using Microsoft SQL Server 2005 (Pro Certification)
by J.C. Mackin, Mike Hotek
Microsoft Press; Published: 2006-12-06; Hardcover; Book
Best price: $5.24
Price in other shops: $59.99
Microsoft  SQL Server(TM) 2005 Administrator's Pocket Consultant (Pro-Administrator's Pocket Consultant) ImageMicrosoft SQL Server(TM) 2005 Administrator's Pocket Consultant (Pro-Administrator's Pocket Consultant)
by William R. Stanek
Microsoft Press; Published: 2005-11-30; Paperback; Book
Best price: $10.00
Price in other shops: $29.99
70-297: MCSE Guide to Designing a Microsoft Windows Server 2003 Active Directory and Network Infrastructure Image70-297: MCSE Guide to Designing a Microsoft Windows Server 2003 Active Directory and Network Infrastructure
by Jay Adamson
Course Technology; Published: 2004-09-08; Paperback; Book
Best price: $49.68
Price in other shops: $135.95
MCITP Self-Paced Training Kit (Exam 70-442): Designing and Optimizing Data Access by Using Microsoft  SQL Server(TM) 2005 (Self-Paced Training Kits) ImageMCITP Self-Paced Training Kit (Exam 70-442): Designing and Optimizing Data Access by Using Microsoft SQL Server(TM) 2005 (Self-Paced Training Kits)
by Sara Morgan, Tobias Thernstrom
Microsoft Press; Published: 2007-04-25; Paperback; Book
Best price: $14.75
Price in other shops: $59.99
70-298: MCSE Guide to Designing Security for Microsoft Windows Server 2003 Network Image70-298: MCSE Guide to Designing Security for Microsoft Windows Server 2003 Network
by Byron Wright
Course Technology; Published: 2004-09-01; Paperback; Book
Best price: $10.00
Price in other shops: $140.95
Guide to Microsoft Windows Server 2003 Command Line Administration ImageGuide to Microsoft Windows Server 2003 Command Line Administration
by Deborah Haralson
Course Technology; Published: 2003-08-18; Paperback; Book
Best price: $99.98
Price in other shops: $120.95
Microsoft® Windows PowerShell(TM) Step By Step (Step By Step (Microsoft)) ImageMicrosoft® Windows PowerShell(TM) Step By Step (Step By Step (Microsoft))
by Ed Wilson
Microsoft Press; Published: 2007-05-16; Paperback; Book
Best price: $708.23
MCITP Self-Paced Training Kit (Exam 70-441): Designing Database Solutions by Using Microsoft  SQL Server(TM) 2005 (Self-Paced Training Kits) ImageMCITP Self-Paced Training Kit (Exam 70-441): Designing Database Solutions by Using Microsoft SQL Server(TM) 2005 (Self-Paced Training Kits)
by Dejan Sarka, Andy Leonard, Javier Loria, Adolfo Wiernik
Microsoft Press; Published: 2007-09-12; Paperback; Book
Best price: $16.00
Price in other shops: $59.99
MCTS Self-Paced Training Kit (Exam 70-433): Microsoft® SQL Server® 2008 Database Development ImageMCTS Self-Paced Training Kit (Exam 70-433): Microsoft® SQL Server® 2008 Database Development
by Tobias Thernstrom, Ann Weber, Mike Hotek
Microsoft Press; Published: 2009-05-20; Hardcover; Not Machine Specific; Book
Best price: $37.35
Price in other shops: $69.99
MCTS Self-Paced Training Kit (Exam 70-432): Microsoft® SQL Server® 2008 Implementation and Maintenance (Pro-Certification) ImageMCTS Self-Paced Training Kit (Exam 70-432): Microsoft® SQL Server® 2008 Implementation and Maintenance (Pro-Certification)
by Mike Hotek
Microsoft Press; Published: 2009-02-18; Hardcover; Book
Best price: $37.25
Price in other shops: $69.99
Book store. Illustrated catalog of books on different categories