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.

Amazon.com® Reader Reviews (Ranked by Helpfulness)

Average Amazon.com® Rating:  Based on 7 Ratings

Great book, Bad practice exams. - 2009-08-30
Reviewer Rating:
The book:

Great book, covers all of the exam topics very well and in a concise manner. You'll learn everything you need to know by doing the practice lessons that are at the end of every chapter. Even if you're not writing the exam, this book would be great for someone wanting to learn about SQL 2008 changes on the developer level. Highly recommended!

The practice exams that are included:

Are horrible for the most part. Many of the questions are overly complex and some make no sense. For example, to have a persisted view, what SET options have to be set to on. Choose all that apply (from a list of 10 or so possible answers)...nobody with a life is going to know that or even need to know it. Also some of the answers are quite wrong, tried a few of the queries and they failed, even though they were marked as right. I honestly wouldn't even use the practice exams and instead use MeasureUp or SelfTestSoftware.

In summary, the book is great, I went over the book for about a month and a half, and combined with my experience I scored 100% on the exam.

Don't Bother - 2009-09-25
Reviewer Rating:
This rather dull and pedantic book nominally covers the exam material, but the book's organization and samples are far less detailed than the usual Microsoft Press books. Also, the writing was so poor I gave up about half way through and instead bought the 70-433 Transcender exam. The Transcender exam has far better examples and explanations as well as instant feedback.
Don't waste your money with this book. Instead, spend another $30 and get the Transcender product and you'll do just fine on the exam.

Ben H.
MCSD
MCDBA
MCSD.NET

Practice tests are HORRIBLE - 2009-08-15
Reviewer Rating:
I have been going through these practice tests - while many are admittedly accompanied by a decent enough explanation, there are still plenty of them that use such a poor choice of words that you are really hard pressed to figure out what it is that they require from you. (At least) one of them has an outright incorrect syntax (which's what made me bypass it in the answers), but turns out that *that is* the correct answer...here's the query..
"SELECT product, employee, revenue FROM
SELECT product, employee, revenue,
RANK() OVER (PARTITION BY product
ORDER BY revenue DESC) AS rank
FROM Sales
) t1
WHERE rank = 1;"
Notice there's no starting parenthesis in the subquery...if run through the parser, it fails.

I have not taken the exam yet, but if the exam is styled on that on the practice CD, I am going to be VERY disappointed - it does not test you on concepts - but specifics of syntax etc. that are not really important in the grand scheme of things!

Useful for certification but not sufficient for other purposes - 2009-08-08
Reviewer Rating:
It is not well prepared and organized. Author must put more effort to organize information, exclude unnecessary ones and include useful materials. Still it is useful for certification purposes, not in all aspects yet useful.

Microsoft 70-433 Training Book - 2009-08-29
Reviewer Rating:
Even though I felt the shipping to be a tad on the expensive side, the delivery was quick and very well serviced. I was called to ensure that I got the product at the address that I wanted. The book itself is as described, in good condition, and the packaging was great. No complaints, every thing went smooth!

Browse Similar Topics

Top Level Categories:
Certification

Sub-Categories:
Certification > Microsoft
Microsoft > MCTS