Buy New

or
Sign in to turn on 1-Click ordering.
or
Amazon Prime free trial required. Sign up when you check out. Learn more
Buy Used
Used - Good See details
Price: £5.61

or
Sign in to turn on 1-Click ordering.
 
   
More Buying Choices
Have one to sell? Sell yours here
or
Get a £0.25 Amazon.co.uk Gift Card
MCTS Training Kit: Implementing & Maintaining SQL Server 2005 Book/CD Package: Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)
 
 
Tell the Publisher!
I’d like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

MCTS Training Kit: Implementing & Maintaining SQL Server 2005 Book/CD Package: Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification) [Hardcover]

Solid Quality Learning
3.4 out of 5 stars  See all reviews (11 customer reviews)
RRP: £47.49
Price: £40.37 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £7.12 (15%)
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
In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.
Only 1 left in stock--order soon (more on the way).
Want guaranteed delivery by Saturday, June 2? Choose Express delivery at checkout. See Details
Amazon.co.uk Trade-In Store
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Plus, get an extra £5 Gift Certificate when you trade in books worth £10 or more before June 30, 2012. Visit the Books Trade-In Store for more details.

Frequently Bought Together

Customers buy this book with Implementing and Maintaining Microsoft SQL Server 2005 Exam: MCTS 70-431 Exam Cram £22.09

MCTS Training Kit: Implementing & Maintaining SQL Server 2005 Book/CD Package: Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification) + Implementing and Maintaining Microsoft SQL Server 2005 Exam: MCTS 70-431 Exam Cram
Price For Both: £62.46

Show availability and delivery details



Product details

  • Hardcover: 950 pages
  • Publisher: MICROSOFT PRESS; 1 edition (1 May 2006)
  • Language English
  • ISBN-10: 073562271X
  • ISBN-13: 978-0735622715
  • Product Dimensions: 23.4 x 20.1 x 5 cm
  • Average Customer Review: 3.4 out of 5 stars  See all reviews (11 customer reviews)
  • Amazon Bestsellers Rank: 219,088 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description

Product Description

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.

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.
 

Your tags: Add your first tag
 


Customer Reviews

Most Helpful Customer Reviews
49 of 51 people found the following review helpful
Format:Hardcover
These books have a tough expectation list as people want them to provide all they need to know to get through the associated examination and be a first class refernce book. The five-star rating applies to the former of these requirements as this is the market the book is aimed at. Having sat the examination I can say that all of the questions were answered in the book - and from previous exposure to these books that is not normally the case.

As a reference book it fails, simply because it is not intended as such and more obviously because to cover all the topics adequately it would have to be five times as long. That said, the section on Service Broker is way too vague - the knowledge it imparts will get you through the examination but will leave you floundering in the real world.

Use the book to pass the exam and to introduce you to the new technologies - look elsewhere for more in-depth practical (i.e real world) material.

[...]
Comment | 
Was this review helpful to you?
6 of 6 people found the following review helpful
It's an IT textbook 29 Jan 2008
Format:Hardcover
This is my first Microsoft Press textbook/training kit for an exam - and this is exactly what is focuses on - getting you through the exam.

It's very dry (and rather boring), and I much preferred reading the Wrox books Beginning SQL Server 2005 Administration, and then Professional SQL Server 2005 Administration (which appear to be comprehensive as well as being more readable).

Still, this book comes with a CD for 180 trial licence for SQL Server 2005 - and a Measure Up CD with exam simulation software.
Comment | 
Was this review helpful to you?
29 of 33 people found the following review helpful
Great reference 30 Aug 2006
Format:Hardcover
This book covers all of the 70-431 topics in just about as much detail as you need for the exam without over complicating matters. It also comes with 450 questions which is really useful in testing your knowledge. The explanations are in easy to understand english, with the possible exception of HHTP endpoints which could be done with abit more clarity. On the whole an excellent guide for the exam
Comment | 
Was this review helpful to you?
Most Recent Customer Reviews
Well structured, very useful
This was used in preparation for a Microsoft exam; and it covered all of the items that appeared in the actual test. Read more
Published 18 months ago by Mole
Used as reference not for exam - excellent
Probably unlike most, I got this as a reference, without really intending to do the exams (which I don't plan to do).

Overall this book was very helpful for me. Read more
Published 21 months ago by dubman23
Solid exam resource
Had a couple of annoyances with this book in that the practice exams didn't work and there was the odd error here and there, but otherwise it was a pretty solid purchase. Read more
Published on 29 Oct 2009 by M. Smith
Big
Is definetely one of the most readable book, but has all the information you need (some you dont!lol) but is fine, even being a bit big you can take it wherever you go (bus, tube,... Read more
Published on 30 Sep 2009 by D. Pedroso
Great beginning
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... Read more
Published on 6 July 2009 by Steven R. McEvoy
Not so easy to follow
I found this book is quite hard to follow. This is my very first SQL server book, and I was lost just in the first couple of the lessons. Read more
Published on 17 Sep 2008 by Qin Wang
Plain English (not)
This book is very dry and hard to read, some of the text is pure gobbledygook. It also assumes you have knowledge of some of the subjects it teaches. Read more
Published on 21 Aug 2008 by Mark Gilmour
Not Impressed!!
Honestly - utter rubbish!!
There is several times ive read chapters and not known what the hell they are talking about. Read more
Published on 3 Mar 2008 by Dale
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Listmania!


Look for similar items by category


Look for similar items by subject


Feedback


Amazon.co.uk Privacy Statement Amazon.co.uk Delivery Information Amazon.co.uk Returns & Exchanges