|
MCITP Developer: Microsoft SQL Server 2005 Database Access Design & Optimization Study Guide
* Guides candidates through the 70442 exam, one of two required exams for Microsoft's brand-new MCITP Developer program
* Addresses such topics as writing Transact-SQL queries, programming the database, performing database tuning and optimization, designing databases, and implementing databases at the physical level
* There are
currently more than 138,000 MCDBAs (Microsoft Certified Database Administrators) certified under SQL Server 2000, many of whom will be upgrading their certifications to the new program
* The CD-ROM features leading-edge exam prep software and a test engine of case study practice questions and electronic flashcards
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.
|
