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 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.
Book Details
- Hardcover: 944 pages
- Publisher: McGraw-Hill Osborne Media; 1 edition (March 18, 2008)
- Language: English
- ISBN-10: 0071546693
- ISBN-13: 978-0071546690
- File Size: 17.5 MiB
- Hits: 1,008 times
