MCITP Developer: Microsoft SQL Server 2005 Data Access Design and Optimization Study Guide
Exam 70-442
1st Edition
Published on 2. April 2007
Book
Paperback/Softback
672 pages
978-0-470-10880-2 (ISBN)
Description
Your essential guide to Microsoft's new SQL Server 2005 certification
Get the preparation you need for exam 70-442, PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005, one of two required exams in the Microsoft MCITP: Database Developer certification path. Inside, you'll find practical and in-depth coverage, including:
Full coverage of all exam objectives in a systematic approach, so you can be confident you're getting the instruction you need for the exam
Practical hands-on exercises to reinforce critical skills
Real-world scenarios that put what you've learned in the context of actual job roles
Challenging review questions in each chapter to prepare you for exam day
Exam Essentials, a key feature at the end of each chapter that identifies critical areas you must become proficient in before taking exam 70-442
A handy tear card that maps every official exam objective to the corresponding chapter in the book, so you can track your exam prep objective by objective
Look inside for complete coverage of all exam objectives.
SYBEX TEST ENGINE:
Test your knowledge with advanced testing software. Includes all chapter review questions and bonus case study exam questions.
ELECTRONIC FLASHCARDS:
Reinforce your understanding with flashcards that can run on your PC, Pocket PC, or Palm handheld.
Also on CD, you'll find the entire book in searchable and printable PDF. Study anywhere, any time, and approach the exam with confidence.
Includes Real-World Scenarios, Hands-on Exercises, and Leading-Edge Exam Prep Software Featuring:
* Custom Test Engine
*
Hundreds of Sample Questions, Including Case Studies
*
Electronic Flashcards for PCs, Pocket PCs, and Palm Handhelds
*
Entire Book in PDF
Get the preparation you need for exam 70-442, PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005, one of two required exams in the Microsoft MCITP: Database Developer certification path. Inside, you'll find practical and in-depth coverage, including:
Full coverage of all exam objectives in a systematic approach, so you can be confident you're getting the instruction you need for the exam
Practical hands-on exercises to reinforce critical skills
Real-world scenarios that put what you've learned in the context of actual job roles
Challenging review questions in each chapter to prepare you for exam day
Exam Essentials, a key feature at the end of each chapter that identifies critical areas you must become proficient in before taking exam 70-442
A handy tear card that maps every official exam objective to the corresponding chapter in the book, so you can track your exam prep objective by objective
Look inside for complete coverage of all exam objectives.
SYBEX TEST ENGINE:
Test your knowledge with advanced testing software. Includes all chapter review questions and bonus case study exam questions.
ELECTRONIC FLASHCARDS:
Reinforce your understanding with flashcards that can run on your PC, Pocket PC, or Palm handheld.
Also on CD, you'll find the entire book in searchable and printable PDF. Study anywhere, any time, and approach the exam with confidence.
Includes Real-World Scenarios, Hands-on Exercises, and Leading-Edge Exam Prep Software Featuring:
* Custom Test Engine
*
Hundreds of Sample Questions, Including Case Studies
*
Electronic Flashcards for PCs, Pocket PCs, and Palm Handhelds
*
Entire Book in PDF
More details
Persons
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.
Cristian Andrei Lefter is a SQL Server MVP, developer, database administrator, trainer, and CEO of MicroTraining, a consulting and training company.
Cristian Andrei Lefter is a SQL Server MVP, developer, database administrator, trainer, and CEO of MicroTraining, a consulting and training company.
Content
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.