Buy New

or
Sign in to turn on 1-Click ordering.
Buy Used
Used - Very Good See details
Price: £18.47

or
Sign in to turn on 1-Click ordering.
 
   
Trade in Yours
For a £7.94 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
Colour:
Image not available

 
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 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 (8 customer reviews)
RRP: £54.99
Price: £35.19 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £19.80 (36%)
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 5 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Want delivery by Tuesday, 28 May? Choose Express delivery at checkout. See Details

Formats

Amazon Price New from Used from
Hardcover £35.19  
Unknown Binding --  
Trade In this Item for up to £7.94
Trade in MCTS Self-Paced Training Kit (Exam 70-433): Microsoft SQL Server 2008 - Database Development Book/DVD Package for an Amazon.co.uk gift card of up to £7.94, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). 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 Book/CD Package (Self-Paced Training Kits)
Price For All Three: £105.57

Buy the selected items together


Product details


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
Format:Hardcover
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. The trial exams were also invaluable, as reading the book gives you the areas you need to learn, and the exams tell you how you need to learn them - for example, some of the questions that ask you to put a list of statements in the right order for example (with extra statements not required), use different ways of writing SQL than I am used to (for example it will just say join, instead of inner, left etc, or will sometimes seem ambiguous, so you must know the full sytax of statements including any abbreviations, default or optional keywords etc).

I certainly found there was a lot to learn, but thats good. If I'd come away thinking I could take the exam the next day, I would have failed and therefore been ripped off, so I am glad! I am now going to try the exam (have it booked for mid jan, 2010), and the book also comes with a 15% voucher off the exam which also helped greatly.
Comment | 
Was this review helpful to you?
4 of 4 people found the following review helpful
Format:Hardcover
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
By Mr BD TOP 1000 REVIEWER
Format:Hardcover|Amazon 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?
Would you like to see more reviews about this item?
Were these reviews helpful?   Let us know
Most Recent Customer Reviews
Search Customer Reviews
Only search this product's reviews

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
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
   
Related forums


Listmania!


Look for similar items by category


Feedback


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