MCITP SQL Server 2005 Database Developer All-in-One Exam Guide (Exams 70-431, 70-441 & 70-442) - Hardcover

Gibson, Darril

Hardcover

ISBN 10: 0071546693 ISBN 13: 9780071546690

Publisher: McGraw Hill, 2008

Synopsis

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

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

About this title

About the Author

Darril Gibson, MCT, MCDBA, MCSD, MCITP, is a professional trainer specializing in Microsoft technologies. He is the author of MCITP SQL Server 2005 Database Administration All-in-One Exam Guide.

Edition details

• Publisher: McGraw Hill
• Publication date: 2008
• Language: English
• ISBN 10: 0071546693
• ISBN 13: 9780071546690
• Binding: Hardcover
• Edition number: 1
• Number of pages: 944