Microsoft SQL Server 2005 应用之数据享用设计与优化（1-CD;1-DVD-Eval） MCITP Self-Paced Training
点此进入淘宝搜索页搜索分类: 图书,进口原版书,计算机 Computers & Internet ,
作者： Sara Morgan, Tobias Thernstrom 著
出 版 社： Oversea Publishing House
出版时间： 2007-4-1字数：版次： 1页数： 508印刷时间： 2007/04/01开本： 16开印次： 1纸张： 胶版纸I S B N ： 9780735623835包装： 平装编辑推荐
作者简介：Sara Morgan，Sara Morgan, an independent author and consultant based in Baton Rouge, Louisiana, is an MCSD and MCDBA and is certified
in SQL Server 2000 and Visual Basic .NET. She specializes in devel-oping leading-edge Web-based applications using Microsoft tech-nologies. Since graduating from Louisiana State University with adegree in quantitative business analysis, she has been developingsoftware for a variety of industries, including a not-for-profit hospi-tal, a financial company offering mortgages, a major retailer, a soft-ware company that writes legislative software, and an applicationservice provider.
Sara has written articles for MSDN Magazine, Enterprise Development, .NET Development, Visual Studio Magazine, and DevX.com. She has also co-written MCTS Self-Paced Training Kit (Exam 70-529): Microsoft .NET Framework 2.0 Distributed Application Development(Microsoft Press,2006) and MCPD Self-Paced Training Kit (Exam 70-547): Designing and Developing Web-Based Applications Using the Microsoft .NET Framework. Sara's articles about enhanced computing and her latest research efforts can be found at http://www.custsolutions.net.
内容简介
EXAM PREP GUIDE Ace your preparation for the skills measured by MCITP Exam 70-442 - and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what you've learned by applying your knowledge to real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time. Maximize your performance on the exam by learning to: *Create data access solutions, connections, and models *Write database queries, specialized queries, and XQuery expressions *Programmatically administer a SQL Server service *Design code that validates user data and handles errors *Choose appropriate transaction isolation levels and optimize locking *Tune query and application performance PRACTICE TESTS Assess your skills with practice tests on CD. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers - including a customized learning path that describes how and where to focus your studies.
目录
Introduction
Hardware Requirements
Software Requirements
Installing SQL Server 2005
Installing Visual Studio 2005
Installing the AdventureWorks Database
Installing Microsoft Web Application Stress Tool
Case Scenarios
Case Scenarios and the 70-442 Exam
Case Scenario Structure
Using the CD and DVD
How to Install the Practice Tests
How to Use the Practice Tests
How to Uninstall the Practice Tests
Microsoft Certified Professional Program
Technical Support
Evaluation Edition Software Support
1 Designing a Data Access Strategy
Before You Begin
Lesson I: Designing Data Access Technologies
Selecting a Network Protocol
Selecting a Data Provider
How to Connect by Using ADO.NET
How to Connect by Using MDAC
How to Connect by Using SQL Native Client
Managing Password Policies
Lab: Connecting to a SQL Server Service
Lesson 2: Designing a Data Access Connection
Designing Connections for Heterogeneous Client Computers
Designing Connections for HTTP Web Services
Designing Connections for Another SQL Server Instance
Lab: Creating and Consuming HTTP Endpoints
Lesson 3: Designing a Data Access Object Model
What is the ADO Object Model?
Using a Disconnected Model with ADO.NET
Using a Connected Model with ADO.NET
Lab: Selecting a Data Access Object Model
Case Scenario: Selecting a Data Access Strategy
Suggested Practices
References
Chapter Summary
2 Designing Database Queries
Before You Begin
Lesson 1: Writing Database Queries
Write SELECT Queries
Writing Full-Text Queries
Lab: Writing Database Queries
Lesson 2: Improving Query Performance..
Showing the Execution Plan
Using Query Hints
Using Plan Guides
Using Searchable Arguments
Lab: Tuning Queries
Lesson 3: Retrieving Data from XML Sources.
Working with XML Data
……
3 Designing A Cursor And Caching StrategyChapter
4 Advanced Query TopicsChapter
5 Data Integrity And Error Handling In SQL Server 2005Chapter
6 Designing Transactions And Transaction IsolationChapter
7 Optimizing SQL Server
2005 PerformanceChapter
8 Improving Database Application PerformanceAnswers Appendix A: ReferencesAppendix B: Sql Server
2006 Architecture And Internals
