MCITP: Developer Microsoft SQL Server 2005 Data Access Design & Optimization Study Guide, Exam 70-442 (With CD)

0.0

This comprehensive book will guide readers through Microsoft's brand new SQL 2005 developer exam: PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005 (70-442). Candidates for this exam are Professional Database Developers who design and implement database solutions. They have three or more years dedicated to database work. Topics include: Writing Transact-SQL queries Programming the database Performing database tuning and optimization Designing databases--at both the conceptual and logical levels Implementing databases at the physical level Key Features Covers core exam in new, simplified Microsoft developer certification program. Huge established audience! There are currently 138,485 MCDBAs (Microsoft Certified Database Administrators) certified under SQL Server 2000, many of whom will be upgrading their certs to the new program. Lots of excitement in the wake of release of the dramatically improved SQL Server 2005. Program developed in response to market demand Table of Contents Chapter 1. Designing Data Access Chapter 2. Designing Application Access Chapter 3. Designing Queries Chapter 4. Using Cursors Chapter 5. Planning Error-Handling Chapter 6. Planning a Transaction Strategy Chapter 7. Optimizing the Database and Applications Chapter 8. Designing Indexes Chapter 9. Scaling Out Applications Chapter 10. Creating a Performance Strategy Chapter 11. Storing Data Efficiently Chapter 12. Case Studies Glossary