---

MCITP Self-Paced Training Kit Exam 70-442 .Designing and Optimizing Data Access by Using Microsoft SQL Server 2005

ISBN: 073562383X
EAN: N/A

Year: 2007
Pages: 162

BUY ON AMAZON

• Table of Contents
• Back Cover
• MCITP Self-Paced Training Kit (Exam 70-442)-Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
• Introduction
• Hardware Requirements
• Software Requirements
• Case Scenarios
• Using the CD and DVD
• Microsoft Certified Professional Program
• Technical Support
• Evaluation Edition Software Support
• Chapter 1: Designing a Data Access Strategy
• Before You Begin
• Lesson 1: Designing Data Access Technologies
• Quick Check
• Lesson 2: Designing a Data Access Connection
• Quick Check
• Lesson 3: Designing a Data Access Object Model
• Quick Check
• Case Scenario: Selecting a Data Access Strategy
• Suggested Practices
• References
• Chapter Summary
• Chapter 2: Designing Database Queries
• Before You Begin
• Lesson 1: Writing Database Queries
• Quick Check
• Lesson 2: Improving Query Performance
• Quick Check
• Lesson 3: Retrieving Data from XML Sources
• Quick Check
• Case Scenario: Creating a Plan Guide
• Suggested Practices
• References
• Chapter Summary
• Chapter 3: Designing a Cursor and Caching Strategy
• Before You Begin
• Lesson 1: Designing Caching Strategies
• Quick Check
• Lesson 2: Designing a Cursor Strategy
• Quick Check
• Lesson 3: Designing Efficient Cursors
• Quick Check
• Case Scenario: Evaluating Cursor Performance
• Suggested Practices
• References
• Chapter Summary
• Chapter 4: Advanced Query Topics
• Before You Begin
• Lesson 1: Administering a SQL Server Service
• Quick Check
• Lesson 2: Querying with Multiple Active Result Sets
• Quick Check
• Lesson 3: Performing Asynchronous Processing
• Quick Check
• Case Scenario: Automating a Data-Mining Solution
• Suggested Practices
• References
• Chapter Summary
• Chapter 5: Data Integrity and Error Handling in SQL Server 2005
• Before You Begin
• Lesson 1: Validating Data and Permissions
• Quick Check
• Lesson 2: Detecting and Reacting to Errors
• Quick Check
• Case Scenario: Validating Data Integrity
• Suggested Practices
• Reference
• Chapter Summary
• Chapter 6: Designing Transactions and Transaction Isolation
• Before You Begin
• Lesson 1: Understanding the Available Transaction Isolation Levels
• Quick Check
• Lesson 2: Designing Transactions and Optimizing Locking
• Quick Check
• Case Scenario: Optimizing Locking
• Suggested Practices
• References
• Chapter Summary
• Chapter 7: Optimizing SQL Server 2005 Performance
• Before You Begin
• Lesson 1: Optimizing and Tuning Queries
• Quick Check
• Lesson 2: Optimizing Index Strategies
• Quick Check
• Lesson 3: Optimizing Data Storage
• Quick Check
• Case Scenario: Optimizing Query Performance
• Suggested Practices
• References
• Chapter Summary
• Chapter 8: Improving Database Application Performance
• Before You Begin
• Lesson 1: Scale Database Applications
• Quick Check
• Lesson 2: Resolving Performance Problems
• Quick Check
• Case Scenario: Diagnosing a Performance Problem
• Suggested Practices
• References
• Chapter Summary
• Case Scenario Answers
• Chapter 2: Creating a Plan Guide
• Chapter 3: Evaluating Cursor Performance
• Chapter 4: Automating a Data-Mining Solution
• Chapter 5: Validating Data Integrity
• Chapter 6: Optimizing Locking
• Chapter 7: Optimizing Query Performance
• Chapter 8: Diagnosing a Performance Problem
• Appendix A: References
• Design an Appropriate Data Access Object Model
• Write Queries
• Design Caching Strategies
• Design a Cursor Strategy
• Design Applications that Administer a SQL Server Service
• Scale Database Applications
• Resolve Performance Problems
• Manage Concurrency by Selecting the Appropriate Transaction Isolation Levels
• Design Code that Uses Transactions
• Optimize and Tune Queries for Performance
• Design Code that Validates Input Data and Permissions
• Appendix B: SQL Server 2005 Architecture and Internals
• Hardware Trends and Their Effect on SQL Server 2005
• SQLOS
• Common Language Runtime (CLR) Host
• SQL Server 2005 Storage Engine
• SQL Server 2005 Query Engine
• SQL Server 2005 Index Internals
• Database Encryption
• Glossary
• E-P
• R-U
• Index
• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• X
• List of Figures
• List of Tables
• List of Exercises
• CD Content