MCTS Self-Paced Training Kit (Exam 70-433): Microsoft SQL Server 2008-Database Development: Microsoft SQL Server 2008 Database Development |  | Authors: Tobias Thernstrom, Ann Weber, Mike Hotek, Grandmasters
Publisher: Microsoft Press
Category: Book
List Price: $69.99
Buy New: $2.36
as of 3/10/2010 01:49 CST details
You Save: $67.63 (97%)
New (25) Used (5) from $2.36
Seller: hightech_computer_books
Rating:  10 reviews
Sales Rank: 12292
Media: Hardcover
Edition: 1
Pages: 496
Number Of Items: 1
Shipping Weight (lbs): 2.6
Dimensions (in): 9 x 7.4 x 1.5
ISBN: 0735626391
Dewey Decimal Number: 005
EAN: 9780735626393
ASIN: 0735626391
Publication Date: May 20, 2009
Availability: Usually ships in 1-2 business days
| |
| Similar Items:
| |
| Editorial Reviews:
Product Description
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.
|
| Customer Reviews:
Showing reviews 1-5 of 10
I love it, I hate it March 3, 2010
Jose A. Campo (Houston, TX)
I do have a love/hate relationship with this book. There are nice things on it and others that I really dislike.
The positive side, it is a clear and concise book. Explanations are easy to follow, plenty of graphics and not a lot of "blah blah blah" trying to explain a simple T-SQL statement or query; that's good, I really love those kind of books because don't make me waste my precious time :-) To give you an example, I found very clear its explanation about SQL2005/2008 partitions; the previous SQL2005 cert book, 70-431, put more details and more complex examples on that particular topic, that could confuses you a bit.
The negative side is that this is intended to pass the Microsoft certification, not just a mere T-SQL or developer book. If that was the case, I could give a higher rating. But people who get or buy this book (not me on this case) are investing their money in something will help them to pass the Microsoft test with little or not effort, assuming you read it from cover to cover. I do not feel or I do not think that's the case here or the book allow you to do that. Explanations are short, the book itself is thin, so all obscure and weird options that we do have in T-SQL won't be here, in fact, they are not. And that's misleading, because when you seat for the real test, Microsoft will try to "kill" you with really strange T-SQL options and queries that you barely see in real world.
At this point you maybe wonder why I bought it? well ... I opened it in a popular bookstore and enjoyed the way has been written. I need to improve my programming skills, not my dba skills, and this book satisfies that need. I am currently not pursuing this cert. and because that reason, I believe is or was money well spent.
If you're new or not an experienced T-SQL programmer, do not rely on this book only to pass the Microsoft test, get another resource, like "Microsoft SQL Server 2008 T-SQL Fundamentals" from Itzik Ben-Gan. Itzik's book is pure gold, awesome book. Both provide a better coverage for the 70-433 test.
 VERY incomplete December 16, 2009
J. Strickland
2 out of 2 found this review helpful
This book doesn't even come close to covering the topics in the 70-433 exam. That wouldn't be such a problem is MS didn't market it as a preparation spcifically for that exam. I think that is very unethical.
If you go for the test without a considerable amount of SQL2008 and other version experience or training you are going to be in trouble when you take the exam.
Maybe that explains the steep discount. At least the book will make up a part of my reference library.
 Goog book November 24, 2009
Igor Basmanov (Moscow Russia)
1 out of 1 found this review helpful
I took the exam 433 with help of this book from MS and BOL, Book of APress. This book covers nearly all topics of MS-exam (70-80%). It is suitable for the beginning of developments with SQL2008. For a more complete study see other sources too.
 Don't Bother September 25, 2009
Benjamin Herrin (Greensboro, NC)
8 out of 8 found this review helpful
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
Great book, Bad practice exams. August 30, 2009
Righteousman (Canada)
6 out of 6 found this review helpful
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.
Showing reviews 1-5 of 10
|
|
|
