Detailed and authoritative, this book serves as both a complete certification study guide and reference on-the-job essential. Get full details on all exam topics including how to: Installing and configuring SQL Server Transact-SQL 2005Manage designUse and XMLWork with functions, triggers, and CLR integrationOptimize, monitor, and safely stored databasesCreate disaster recoveryWork proceduresHandle with Service Broker, Web Services, and MARSUse SQL Server Reporting Services and Notification ServicesManage locks, deadlock , and cursorsTransfer data using Replication and SQL Server Integration Services CD-ROM Features: Six full practice exams-two for each exam: 70-431, 70-441, & 70-442Scripts of the exercises step-by-step in training clip bookVideo of electronic books authorComplete