Mcitp Developer Microsoft Sql Server 2005 Data Access Design & Optimization Study Guide, Exam 70-442

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

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


Market Description :
· Students and professionals studying for exam 70-442 as well as IT Professionals seeking a high level of SQL Server 2005 material.

About Author :
Marilyn Miller-White, SQL Server 2005 MCTS and MCITP, MCT, MCDBA, MCSE, is the owner of White Consulting, a New Jersey-based consultancy specializing in database and systems training and solutions. With a Masters in Education and a passion for learning, Marilyn began teaching computer science in New Jersey’s schools and colleges. While teaching, she decided to branch out to both the government and private sectors specializing in designing database, programming and systems solutions to support the growing needs of her customers. At present, she spends most of her time working with or presenting at events on SQL Server 2005 throughout North America. She loves to travel, especially to Washington and Texas where she can include a visit with her children. When home, she enjoys listening to classical music and the company of her cats: Holly and her new friend Sequel.
Cristian Leftner is a SQL Server MVP, developer, database administrator, trainer and CEO of MicroTraining, a consulting and training company. In his spare time he is a tech reviewer, author and leader for two user groups ITBoard and Romanian SQL Server User Group (an official PASS chapter). The involvement in communities is sustained also from a position of Advisory Council Member for Culminis EMEA. The common denominator for all his activities is Microsoft SQL Server.