Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Overview

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.

Subscriber Reviews

Average Rating: 3.75 out of 5 rating Based on 8 Ratings

"good intro to MSSQL dev" - by Anonymous on 31-JAN-2012
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
This book is full of basic knowledge and practical hints about developping a MS SQL Server DB.
It won't say many things about management though.

Nevertheless, it's a good intro even for those who do not intend to take the exam.

Report as Inappropriate

"Don't rely on just this book!" - by Peter Tran on 03-MAY-2011
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
Yay! I just passed Microsoft Exam 70-433 with a little help from the book MCTS Self-Paced Training Kit (Exam 70-433): Microsoft® SQL Server® 2008 - Database Development. I’ll first cover the good part about this book followed by the bad part.

The good part is this book does cover all the materials from the exam. Some parts of the material are covered in better details than other. The chapters are organized very similar to the requirements posted by Microsoft.  Each chapter covers specific lesson plans with time estimate on how long it will take to review and study. There is a chapter review and suggested practice section which was helpful. I would have given up on this book if it weren’t for my Safari Books Online (SBO) membership. SBO has an excellent search feature that allowed me to find the sections I needed to study.

Here is the bad: I can’t fully credit this book with helping me pass. There were a lot of technical mistakes. The chapters did not have a good flow. Some were better written than others, which is typical when you have several authors. The worse part is the practice exam included with the book. If you have a Safari Books Online account, you can get the book and all the CD material of the “Extras” tab. MeasureUp created the practice tests. I was really disappointed with some of the incorrect answers. My warning is to you is to make sure you set aside time to actually very the question and answers in the practice tests.

I would use this book as a supplement to other materials rather than the sole study guide. There are a few great online resources. The books by Itzik Ben-Gan are in fact better materials to study.

Report as Inappropriate

"Only a Small Subset of CD" - by Anonymous on 25-FEB-2011
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
Only comes with a small subset of the CD. The low rating is for Safari not having getting/allowing access to full CD.
Report as Inappropriate

"Good " - by avnit on 15-MAY-2010
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
Good book for exam
Report as Inappropriate

Table of Contents

 

Extras

The publisher has provided additional content related to this title.


Description
Content

Visit the catalog page for MCTS Self-Paced Training Kit (Exam 70-433): Microsoft® SQL Server® 2008 - Database Development

  • Catalog Page

Visit the errata page for MCTS Self-Paced Training Kit (Exam 70-433): Microsoft® SQL Server® 2008 - Database Development

  • Errata

Download the complete CD content that was included with the print edition of this book. Includes practice files and tests.

  • CD Contents