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
Beginners Guide to DarkBASIC Game Programming (Premier Press Game Development)
Welcome to DarkBASIC
Introduction to Computer Programming
Number Crunching Mathematical and Relational Operators and Commands
The Art of Using Animated Sprites for 2D Games
Playing Some Tunes CD Audio, MIDI and MP3 Music
Interprocess Communications in Linux: The Nooks and Crannies
Executable File Format
Command-Line Values
Key Terms and Concepts
exec s Minions
A ClientServer Message Queue Example
Secure Programming Cookbook for C and C++: Recipes for Cryptography, Authentication, Input Validation & More
Installing Boost.Build
Tokenizing a String
Reading a Comma-Separated Text File
Introduction
Computing a Dot Product
What is Lean Six Sigma
The Four Keys to Lean Six Sigma
Key #3: Work Together for Maximum Gain
Beyond the Basics: The Five Laws of Lean Six Sigma
Making Improvements That Last: An Illustrated Guide to DMAIC and the Lean Six Sigma Toolkit
The Experience of Making Improvements: What Its Like to Work on Lean Six Sigma Projects
Special Edition Using FileMaker 8
Working with Buttons on Layouts
Developing for Multiple Users
GetNthRecord
FileMaker Extra: The Limits of Customization
Scheduled Tasks
Microsoft Visual Basic .NET Programmers Cookbook (Pro-Developer)
XML
Multithreading
Windows Controls
Remoting and Enterprise Services
Security and Cryptography
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