MCITP Self-Paced Training Kit (Exam 70-442): Designing and Optimizing Data Access by Using Microsoft SQL Server 2005

MCITP Self-Paced Training Kit (Exam 70-442): Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
Published:April 25, 2007Language:English
Author:Sara Morgan and Tobias Thernstrom of GrandMastersTechnology:Microsoft SQL Server 2005
Length:544 PagesISBN 13:9780735623835

List Price:

$ 59.99
About The BookYour 2-in-1 Self-Paced Training Kit


Ace your preparation for the skills measured by MCITP Exam 70-442—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what you’ve learned by applying your knowledge to 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 data access solutions, connections, and models

  • Write database queries, specialized queries, and XQuery expressions

  • Programmatically administer a SQL Server service

  • Design code that validates user data and handles errors

  • Choose appropriate transaction isolation levels and optimize locking

  • Tune query and application performance


    Assess your skills with 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.
    About Sara Morgan and Tobias Thernstrom of GrandMastersSara Morgan, MCSD, MCDBA, specializes in developing Web-based applications using Microsoft technologies. She coauthored Microsoft Self-Paced Training Kits for Exams 70-529 and 70-547 and has contributed articles to industry magazines, including MSDN Magazine and other industry publications.

    Tobias Thernström is a recognized SQL Server expert and a senior database architect with more than 10 years of experience. He is a Microsoft Certified Trainer and has helped develop several Microsoft SQL Server certifications for database professionals.

    GrandMasters is an IT consulting firm specializing in content development, exam development, and customized technical support.
    Other Books By GrandMasters
    Looking for training resources, events and advice from peers? Join the Microsoft Training and Certification Community. Preparing for an exam now? Find your Microsoft Certification Study Group. Talk to us on these social networks:
    What do you think of this book? Your feedback is important in helping us create books that serve your needs and meet your expectations.Please take our survey at

    Note: You will need this book's 13-digit International Standard Book Number (ISBN) to take the survey.The ISBN 13 can be found above.
    To report or search for corrections in this book or its companion content,
    search for the title in our online store and then check the Errata & Updates tab. To report errors, please go to our Submit errata page.