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
CompTIA Project+ Study Guide: Exam PK0-003
IT Project+ Study Guide
Project Initiation
Cost Planning
Comprehensive Project Plan
Project Execution
Image Processing with LabVIEW and IMAQ Vision
Some Definitions
Line-Scan Cameras
Compression Techniques
Quantitative Analysis
Application Examples
Systematic Software Testing (Artech House Computer Library)
An Overview of the Testing Process
Master Test Planning
Analysis and Design
The Software Tester
Appendix C IEEE Templates
101 Microsoft Visual Basic .NET Applications
Working with the Microsoft Visual Basic .NET Language
Building Web Applications
Advanced .NET Framework
Visual Studio .NET
Windows Server 2003 for .NET Developers
Programming Microsoft ASP.NET 3.5
Web Forms User Controls
Configuration and Deployment
ASP.NET State Management
HTTP Handlers and Modules
Index
Microsoft WSH and VBScript Programming for the Absolute Beginner
Getting Started with the WSH and VBScript
VBScript Basics
Combining Different Scripting Languages
Appendix A WSH Administrative Scripting
Appendix B Built-In VBScript Functions
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