Wiley India Pvt Ltd
|Number of Pages||632 Pages|
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. 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 CD features leading-edge exam prep software with test engine of case study practice questions and electronic flashcards. Teacher support package provided for classroom use. Key Features This Sybex Study Guide is an essential buy for all SQL Server 2005 developers and students looking to be certified in the new SQL Server 2005 program. Covers core exam in new, simplified Microsoft developer certification program. Huge established audience, MCDBAs (Microsoft Certified Database Administrators) certified under SQL Server 2000, many of whom will upgrade their certificates to the new program. Program developed in response to market demand--"the realization of a lot of customer feedback, both from those in the MCP community and those who've never really engaged in certification" ---Microsoft Learning About The 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 taught computer science in 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 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. 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.