Flylib.com
MCITP Self-Paced Training Kit Exam 70-442 .Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
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
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
Database Modeling with MicrosoftВ® Visio for Enterprise Architects (The Morgan Kaufmann Series in Data Management Systems)
Getting Started
Configuring, Manipulating, and Reusing ORM Models
Generating a Physical Database Schema
Editing Logical Models”Intermediate Aspects
Reverse Engineering Physical Schemas to Logical Models
Agile Project Management: Creating Innovative Products (2nd Edition)
Simplify
Phase: Envision
Individual Performance
Practice: Low-Cost Change
An Achilles Heel?
The CISSP and CAP Prep Guide: Platinum Edition
Information Security and Risk Management
Cryptography
Security Architecture and Design
Initiation of the System Authorization Process
The Certification Phase
Cisco IP Communications Express: CallManager Express with Cisco Unity Express
Cisco IPC Express System Architecture
Summary
Dial Plan Considerations
Configuring the Router
Summary
Persuasive Technology: Using Computers to Change What We Think and Do (Interactive Technologies)
Overview of Captology
Computers as Persuasive Tools
Increasing Persuasion through Mobility and Connectivity
The Ethics of Persuasive Technology
Captology Looking Forward
.NET System Management Services
Using the System.Management Namespace
Handling WMI Events
Instrumenting .NET Applications with WMI
The WMI Schema
WMI Security
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies