Free Trial

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


All-in-One is All You Need

Get complete coverage of all three Microsoft Certified IT Professional database developer exams for SQL Server 2005 in this comprehensive volume. Written by a SQL Server expert and MCITP, this definitive exam guide features learning objectives at the beginning of each chapter, exam tips, practice questions, and in-depth explanations. Detailed and authoritative, the book serves as both a complete certification study guide and an essential on-the-job reference.

Get full details on all exam topics including how to:

• Install and configure SQL Server 2005

• Manage database design

• Use Transact-SQL and XML

• Work with functions, triggers, and CLR integration

• Optimize, monitor, and secure databases

• Create stored procedures

• Handle disaster recovery

• Work with Service Broker, Web Services, and MARS

• Use SQL Server Reporting Services and Notification Services

• Manage locks, deadlocks, and cursors

• Transfer data using Replication and SQL Server Integration Services

The CD-ROM features:

• Six full practice exams-two for each exam: 70-431, 70-441, & 70-442

• Scripts from the step-by-step exercises in the book

• Video training clips from the author

• Complete electronic book

Subscriber Reviews

Average Rating: 4 out of 5 rating Based on 1 Rating

No Subscribers have provided a review for this book.

Table of Contents



The publisher has provided additional content related to this title.

A Message from the Publisher

Please download the attached files for instructions as to accessing the companion CD materials.

Windows version files