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
Software Configuration Management
Configuration Identification
Metrics and Configuration Management Reference
Appendix E Test Plan
Appendix U Acronyms and Glossary
Appendix Y Supplier CM Market Analysis Questionnaire
Snort Cookbook
Running Snort to Detect Intrusions
Detecting Viruses
Administering Snort with HenWen
Port Knocking
Performing Forensics Using Snort
Lotus Notes Developers Toolbox: Tips for Rapid and Successful Deployment
The Work Pane
What Is a Formula?
What Are Functions and Commands?
Working with User Prompts
Archiving Data Using an Agent
An Introduction to Design Patterns in C++ with Qt 4
Constructors
Review Questions
Installing Libraries: A Lab Exercise
Q_PROPERTY Macro: Describing QObject Properties
Qt SQL Classes
What is Lean Six Sigma
The Four Keys to Lean Six Sigma
Key #1: Delight Your Customers with Speed and Quality
Beyond the Basics: The Five Laws of Lean Six Sigma
When Companies Start Using Lean Six Sigma
The Experience of Making Improvements: What Its Like to Work on Lean Six Sigma Projects
Cultural Imperative: Global Trends in the 21st Century
Culture and Climate
Culture and Religion
The Pacific Rim: The Fourth Cultural Ecology
The China Phenomenon
Appendix B Leadership Test
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