MCITP Developer: Microsoft® SQL ServerTM 2005 Data Access Design and Optimization Study Guide: Exam 70-442

by ;
Edition: CD
Format: Paperback
Pub. Date: 2007-04-01
Publisher(s): Sybex
Availability: This title is currently not available.
List Price: $59.99

Rent Book

Select for Price
There was a problem. Please try again later.

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

Summary

As your essential guide to Microsoft's new SQL Server 2005 certification (exam 70-442), this book offers you practical and in-depth coverage. Full coverage of all exam objectives is presented in a systematic approach so you can be confident you're getting the instruction you need for the exam. Plus, practical hands-on exercises reinforce critical skills and real-world scenarios put what you've learned in the context of actual job roles. Finally, challenging review questions in each chapter prepare you for exam day.

Author Biography

Marilyn Miller-White, SQL Server 2005 MCTS and MCITP, MCT, MCDBA, MCSE, is the owner of White Consulting, a New Jersey-based consultancy specializing in database and systems training and solutions.

Cristian Andrei Lefter is a SQL Server MVP, developer, database administrator, trainer, and CEO of MicroTraining, a consulting and training company.

Table of Contents

Designing Data Access
Designing Application Access
Designing Queries
Using Cursors
Planning Error-Handling
Planning a Transaction Strategy
Optimizing the Database and Applications
Designing Indexes
Scaling Out Applications
Creating a Performance Strategy
Storing Data Efficiently
Case Studies
Glossary
Table of Contents provided by Publisher. All Rights Reserved.

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.