Microsoft® SQL Server™ 2005: Applied Techniques Step by Step

Microsoft® SQL Server™ 2005: Applied Techniques Step by Step
Published:June 21, 2006Language:English
Author:Solid Quality LearningTechnology:Microsoft SQL Server 2005
Length:368 PagesISBN 13:9780735623163

List Price:

$ 39.99
About The BookTake your database skills to the next level with this hands-on, step-by-step guide.

Learn more-advanced skills to design, build, test, deploy, and maintain SQL Server databases—one step at a time. Ideal for developers who understand database essentials, this learn-by-doing tutorial offers practical guidance, code samples, and a collection of techniques to help you solve real-world business problems.

Discover how to:
  • Manage data access with server logins and user and server roles

  • Implement a disaster recovery strategy

  • Use aggregate functions to compute totals and complex statistical values

  • Optimize query performance by managing IO statistics and designing indexes

  • Work with remote data sources—including third-party databases

  • Provide remote access through the Internet or a middle-tier service interface

  • Manage transactions, implement error handlers, and define isolation levels

  • Go further and work with SQL Server Reporting Services and Notification Services


  • Includes a CD featuring:
  • All practice exercises

  • Code samples
  • 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 www.microsoft.com/learning/booksurvey

    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 companion content,
    please go to www.microsoft.com/learning/support/books/