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
Absolute Beginner[ap]s Guide to Project Management
Setting the Stage for Success
Project Plan Checklist
Common Project Control Challenges
Common Project Change Control Challenges
Seven Powerful Principles
The Complete Cisco VPN Configuration Guide
IPsec
L2TP
Summary
Cisco VPN Software Client
Issues with Site-to-Site Connections
Information Dashboard Design: The Effective Visual Communication of Data
Displaying Excessive Detail or Precision
Arranging the Data Poorly
Cluttering the Display with Useless Decoration
Effective Dashboard Display Media
Make the Viewing Experience Aesthetically Pleasing
Professional Struts Applications: Building Web Sites with Struts ObjectRelational Bridge, Lucene, and Velocity (Experts Voice)
The Challenges of Web Application Development
Form Presentation and Validation with Struts
Building a Data Access Tier with ObjectRelationalBridge
Templates and Velocity
Building the JavaEdge Application with Ant and Anthill
Cisco ASA: All-in-One Firewall, IPS, and VPN Adaptive Security Appliance
File Transfer Protocol
Architectural Overview
Summary
Architectural Overview
Introduction to PKI
InDesign Type: Professional Typography with Adobe InDesign CS2
Getting the Lead Out
First Impressions: Creating Great Opening Paragraphs
Up Next
Right Indent Tab
Ignoring Text Wrap
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