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
