Vous voulez voir cette page en français ? Cliquez ici.


or
Sign in to turn on 1-Click ordering.
More Buying Choices
Have one to sell? Sell yours here
MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation & Maintenance
 
 
Share your own customer images
Search inside this book

MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation & Maintenance [Hardcover]

Solid Quality Learning (Author)
3.3 out of 5 stars  See all reviews (3 customer reviews)
List Price: CDN$ 80.99
Price: CDN$ 49.62 & this item ships for FREE with Super Saver Shipping. Details
You Save: CDN$ 31.37 (39%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Usually ships within 1 to 2 months.
Ships from and sold by Amazon.ca. Gift-wrap available.

Product Details

Product Description

Book Description

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.

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.

Inside This Book (Learn More)
First Sentence
A key part of installing a new SQL Server 2005 instance is selecting the appropriate SQL Server 2005 edition for the installation. Read the first page
Explore More
Concordance
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 
(1)
(1)
(1)
Agree with these tags?

Your tags: Add your first tag
 
See most popular tags
 

Customer Reviews

3 Reviews
5 star:
 (1)
4 star:
 (1)
3 star:    (0)
2 star:    (0)
1 star:
 (1)
 
 
 
 
 
Average Customer Review
3.3 out of 5 stars (3 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most helpful customer reviews

4.0 out of 5 stars Great beginning, July 5 2009
By 
Steven R. McEvoy "MCWPP" (Canada) - See all my reviews
(TOP 50 REVIEWER)    (HALL OF FAME)    (REAL NAME)   
This review is from: MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation & Maintenance (Hardcover)
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.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


5.0 out of 5 stars Helpful, Nov 10 2009
By 
Steven C. Howes "stevejunk" (Winnipeg Canada) - See all my reviews
(REAL NAME)   
This review is from: MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation & Maintenance (Hardcover)
I'll cut to the chase... This book and it's companions for exam 70-443 and 70-444 helped me pass the exams and get the MCITP certification. For these books that's what matters.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


1.0 out of 5 stars Evaluation Software Limits the use of this Book, Mar 2 2008
By 
W. Curlew - See all my reviews
(REAL NAME)   
This review is from: MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation & Maintenance (Hardcover)
Many examples in this book can not be compleated with the "Evaluation Software" that is included with the book. Chapters 14, and 15 both reference features not included in this version of the software.

The book has been reading very nicely and I believe that I have learned a lot from it but I have become very frustrated with the way the not all the examples/practice areas can be accessed with the limitations of the included software
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

Share your thoughts with other customers: Create your own review
Want to see more reviews on this item?
› Go to Amazon.com to see all 51 reviews  3.9 out of 5 stars 
 
 
Only search this product's reviews


Listmania!

Create a Listmania! list

Look for similar items by category

Look for similar items by subject























i.e., each book must be in subject 1 AND subject 2 AND ...

Feedback

Would you like to update product info or give feedback on images?

Amazon.ca Privacy Statement Amazon.ca Shipping Information Amazon.ca Returns & Exchanges