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
Product details
|
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
Front Cover | Copyright | Table of Contents | Excerpt | Index
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 PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
What Other Items Do Customers Buy After Viewing This Item?
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.
[...]
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.
[...]
6 of 6 people found the following review helpful
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.
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.
29 of 33 people found the following review helpful
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
Would you like to see more reviews about this item?
Were these reviews helpful?
Let us know
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
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
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
Listmania!
Look for similar items by category
- Books > Computing & Internet > Certification > Exams > Microsoft Certified Systems Engineer (MCSE)
- Books > Computing & Internet > Certification > Publishers > Microsoft Press
- Books > Computing & Internet > Certification > Subjects > Microsoft > SQL Server
- Books > Computing & Internet > Databases > Applications > Microsoft SQL Server
- Books > Computing & Internet > Databases > Applications > SQL > Microsoft SQL Server
- Books > Computing & Internet > Databases > Database Design & Theory
- Books > Computing & Internet > Databases > Database Theory
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Web Development > Web-server Software > Microsoft
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
