Buy New

Sign in to turn on 1-Click ordering.
Buy Used
Used - Good See details
Price: 8.43

Trade in Yours
For a 1.63 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Tell the Publisher!
Id like to read this book on Kindle

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

MCTS Self-Paced Training Kit (Exam 70-433): Microsoft SQL Server 2008 - Database Development Book/DVD Package [Hardcover]

Tobias Thernstrom , Ann Weber , Mike Hotek
4.0 out of 5 stars  See all reviews (9 customer reviews)
RRP: 54.99
Price: 38.49 & FREE Delivery in the UK. Details
You Save: 16.50 (30%)
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
Only 4 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Want it Saturday, 19 April? Choose Express delivery at checkout. Details


Amazon Price New from Used from
Hardcover 38.49  
Paperback --  
Unknown Binding -- Trade-In Store
Did you know you can use your mobile to trade in your unwanted books for an Gift Card to spend on the things you want? Visit the Books Trade-In Store for more details or check out the Trade-In Amazon Mobile App Guidelines on how to trade in using a smartphone. Learn more.

Book Description

20 May 2009 0735626391 978-0735626393 1

Ace your preparation for the skills measured by MCTS Exam 70-433—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. 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:

  • Create and manage database objects
  • Query and modify data; implement subqueries and CTEs * Optimize table structures and data integrity
  • Create stored procedures, functions, and triggers
  • Manage transactions, error handling, and change tracking
  • Tune query performance
  • Implement database mail, full-text search, Service Broker, scripts
  • Work with XML and SQLCLR Assess your skills with the 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 kit includes:

  • 15% exam discount from Microsoft. Offer expires 12/31/13. Details inside.
  • Official self-paced study guide.
  • Practice tests with multiple, customizable testing options and a learning plan based on your results.
  • 200 practice and review questions.
  • 180-day trial of SQL Server 2008 Enterprise Edition.
  • Case scenarios, exercises, and best practices.
  • Fully searchable eBook of this guide, plus sample chapters from related books.

Frequently Bought Together

MCTS Self-Paced Training Kit (Exam 70-433): Microsoft SQL Server 2008 - Database Development Book/DVD Package + MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 Implementation And Maintenance Book/CD Package (PRO-Certification) + MCTS Self-Paced Training Kit (Exam 70-448): Microsoft® SQL Server® 2008 Business Intelligence Development and Maintenance: MCTS Exam 70-448 (Self-Paced Training Kits)
Price For All Three: 127.58

Buy the selected items together

Product details

  • Hardcover: 456 pages
  • Publisher: MICROSOFT PRESS; 1 edition (20 May 2009)
  • Language: English
  • ISBN-10: 0735626391
  • ISBN-13: 978-0735626393
  • Product Dimensions: 19.4 x 3.3 x 22.7 cm
  • Average Customer Review: 4.0 out of 5 stars  See all reviews (9 customer reviews)
  • Amazon Bestsellers Rank: 215,387 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Authors

Discover books, learn about writers, and more.

Product Description

About the Author

Tobias Thernstrom has 13+ years' experience with SQL Server, serves as program manager on the SQL Engine Platform Team at Microsoft, and helped develop several Microsoft certifications for SQL Server.

Ann Weber, MCITP, MCSE, is an instructor, consultant, and author with more than 12 years' experience with SQL Server. A Microsoft Certified Trainer, Ann has developed several courses and other learning materials for Microsoft.

Mike Hotek is a SQL Server® expert with three decades' experience as a consultant and solution developer. He has written several books, including Microsoft® SQL Server® 2008 Step by Step.

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

Customer Reviews

4.0 out of 5 stars
4.0 out of 5 stars
Most Helpful Customer Reviews
12 of 12 people found the following review helpful
I purchased this really to bone up on SQL Server 2008. I have developed versions 6.5 through to 2005 (with some 2008), so wasn't 100% about whether I would take the exam or not before reading.

One thing I will say, is that books written by multiple authors never seem to have that flowing consistency as with single author books, but I guess with technical books like this one, its needed. Having said that, I feel in one way or another the book definitely covered everything needed... Sometimes in great detail, other times just a mention so you can go away and do your own research, but everything none-the-less.

Given the depth of knowledge you need to take the exam, just bear in mind you wont get all the knowledge you need from the book, you will need to go away and research some areas more thoroughly (full syntatx and different usage / options of some statements etc). I say this, because some people think you can read the book and take the exam next day, which would be wrong. You do need some real world experience of using SQL Server, and the book states this from the start.

In addition to the book, you also get an electronic version on CD, trial version of the software in case you don't have SQL Server 2008, and trial exams.
Read more ›
Comment | 
Was this review helpful to you?
4 of 4 people found the following review helpful
This book is a 2 in one product as it covers aspects from practical point of view and also from MCTS 70-433 Exam point of view. It is a very good guide for best practices and provides practical coding samples of how to use the SQL Server 2008 database. It comes with 200 practices questions. I really like the book because of the fact that I needed to understand the practical use of SQLserver 2008 for my work purposes and also want to earn a certification. THis is essential kit for all beginner and Intermediate.
Comment | 
Was this review helpful to you?
4 of 4 people found the following review helpful
Format:Hardcover|Verified Purchase
First of all, this is the book you need for taking the SS 2008 Database Development exam, but it doesn't tell you everything. It skips over most areas briefly - just enough detail to give an understanding of the aspect, but more work is required to ensure you're good enough for the exam. It should be considered the central book that guides you around the exam subject. The other book I use currently is Microsoft's "Programming Microsoft SQL Server 2008".

If you don't have a decent amount of experience with SQL Server then you may well struggle - this isn't a book to teach someone new to the software.

There are a few typos, although nothing serious - just annoying. Also, in a couple of areas it will mention a command or property and not explain it until later. Another reason you wouldn't want to learn the subject from scratch.
Comment | 
Was this review helpful to you?
2 of 2 people found the following review helpful
4.0 out of 5 stars Good book to prepare for the exam 25 July 2010
By Mosaic
I passed 70-433 using only this book and Transcender (and SQL Server 2008 plus BOL of course!). I wanted to keep up with new developments because in my job I'm still on SQL 2000. There was a lot to learn and it took me several months reading and practising in the evenings and weekends to work through the book. In my opinion this book is better written and better organised than others in the series; this time I did not buy a second book to round out the material.
I have always been disappointed with the practice tests in the kits and after reading the reviews I decided not even to bother installing it this time.
As usual the CD is bound in the middle of the chapter review section, making it unpleasant to use the index
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
4.0 out of 5 stars Good refreshing point 14 Feb 2012
I brought this about a month ago and have the exam coming up next month...

This book is really good if you already have a bit of experience and want to refresh your memory of the syntax and the rules.

I have also taken a practise certification exam and realised that quite a few topics covered in the exam are NOT covered in the book, eg. creating a trace, cloning a session etc or that the book doesnt cover these sections in much detail.

I have found, however, that it covers XML quite extensively which I am pleased with.

I have found that reading through this book and then looking at the MSDN website for complete understanding and also practising coding in SQL Server has benefited me more...just hope I can pass the exam :-D

Overall, I am happy with the purchase and it has taught me a lot already.
Comment | 
Was this review helpful to you?
Would you like to see more reviews about this item?
Were these reviews helpful?   Let us know

Customer Discussions

This product's forum
Discussion Replies Latest Post
What format is the "ebook"? 2 14 Oct 2010
See all discussions...  
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions

Look for similar items by category