影印版

定　價：￥99.00

作　者：	（美）微軟公司
出版社：	北京希望電子出版社
叢編項：	MS SQL SERVER 2000數據庫程序設計
標　簽：	影印版數據庫

ISBN：	9787900056559	出版時間：	2001-01-01	包裝：
開本：	787*1092 1/1	頁數：	660	字數：

內容簡介

　　本盤書是微軟認證高級技術培訓中心（CTEC）標準教材系列之一，課程號是2073A。本盤書詳細討論了Microsoft SQL Server 2000及其數據庫設計的基本知識，通過具體實驗培養(yǎng)讀者的動手能力。全書分為十五個單元，分別為：SQL Server概述、SQL Server編程概述、創(chuàng)建和管理數據庫、創(chuàng)建數據類型和表、實現數據完整性、計劃索引、創(chuàng)建和維護索引、實現視圖、實現存儲過程、實現用戶自定義函數、實現觸發(fā)器、多服務器分布式編程、優(yōu)化查詢性能、分析查詢、管理事務處理和鎖等。在每個單元中，都給出了考察讀者對本單元內容掌握情況的練習題，有助于讀者自我評價課程掌握情況。本盤書內容新穎，全面涵蓋了SQL Server 2000數據庫設計的基礎知識，是SQL Server 2000數據庫認證考試的權威教材。它是參加微軟認證考試的各類讀者的必備讀物，也是需要掌握SQL Server 2000 數據庫設計基礎知識的從業(yè)人員的不可缺少的自學讀物和社會相關領域培訓班教材。本光盤內容包括：在課堂中使用的所有練習文件。

作者簡介

暫缺《影印版》作者簡介

圖書目錄

lntroduction
Insmictor Notes
Introduction
Course Materials
Prerequisites
Course Outline
Setup
Microsoft Official Cutriculum
Microsoft Certified Professional Program
Facilities
Module 1: SQL Server Overview
Insmictor Notes
Overview
What Is SQL Server?
SQL Server Integration
SQL Server Databases
SQL Server Security
Working with SQL Server
Lab A4 SQL Server Overview
Review
Module 2: Overview of Programming SQL Server
Insmictor Notes
Overview
Designing Enterprise Application Architecture
SQL Server Programming Tools
The TransactSQL Programming Language
Elements of TransactSQL
Additional LangUage Elements
Ways to Execute TransactSQL Statemeflts
Recommended Practices
Lab Af Overview of TransactSQL
Review
Module 3: Creatin9 and Managing Databases
Insmictor Notes
Overview
Creating Databases
Creating FilegrouPs
ManagiY g Databases
Introduction to Data Smictores
Recommended Practices
Lab A: Creating and Managing Databases
Review
Module 4: Creating Data Types and Tables
Insmictor Notes
Overview
Creating Data TyPes
Creating Tables
Generating Column Values
Generating ScriPts
Recommended Practices
Lab A: Creating Data TyPes and Tables
Review
ModuIe 5: lmplementing Data lntegrity
Insmictor Notes
Overview
TyPes of Data Integrity
Enforcing Data Integrity
Defining Constraints
Types of Constraints
Disabling Constraints
Using Defaults and Rules
Deciding Which Enforcement Method to Use
Recommended Practices
Lab A: ImPlementing Data Integrity
Review
Module 6: Planning lndexes
Insmictor NotCs
Overview
Introduction to Indexes
Index Architecture
How SQL Server Retrieves Stored Data
How SQL Server Maintains lndex and HeaP Smictures
Deciding Which Colunms to IndeL
Recomrnended Practices
Lab A: Determining the Indexes of a Table
Review
Module 7: Creating and Maintaining lndexes
Insmictor NotCs
Overview
Creating Indexes
Creating lndex OPtions
Maintaining Indexes
Lab A: Creating and Maintaining Indexes
Introduction to Statistics
Querying the sysindexes Table
Setting Up Indexes Using the lndex Tuning Wizard
Performance Considerations
Reconunended Practices
Lab B: Viewing Index Statistics
Review
ModuIe 8: lmplementing Views
Insmictor NotCs
Overview
Introduction to Vews
Defining Views
Modifying Data Through Views
Optimizing Performance by Using Views
Recommended Practices
Lab Af ImPlementing Views
Review
Module 9: lmplementing Stored Procedures
Instfuctor Notes
Overview
Introduction to Stored Procedures
Creating Executing Modifying and Dropping Stored Procedures
Lab Af Creating Stored Procedures
Using Parameters in Stored Procedures
Executing Extended Stored Procedures
Handling Error Messages
PerfOrmance Considerations
Recommended Practices
Lab BCreating Stored Procedures Using Parameters
Review
Module 10: lmplementing Userdefined Functions
Instructor Notes
Overview
What Is a Userdefined Function?
Defining Userdefined Functions
Examples of Userdefined Functions
Recommended Practices
Lab ACreating Userdefined Functions
Review
ModuIe 11: lmplementing Triggers
Instmctor Notes
Overview
Introduction to Triggers
Defining Triggers
How Triggers Work
Performance Considerations
Recommended Practices
Lab A: Creating Triggers
Review
ModuIe 12: Programmin9 Across MuItiple Servers
Insmictor Notes
Overview
Introduction to Distributed Queries
Executing an Ad Hoc Query on a Remote Data Source
Setting UP a Linked Server Environment
Executing a Query on a Linked Server
Executing a Stored Procedure on a Linked ServeL
Managing Distributed Transactions
Modifying Data on a Linked ServeL
Using Partitioned Views
Recommended Practices
Lab Af Using Distributed Data
Review
Module 13: Optimizing Query PerfOrmance
Insmictor Notes
Overview
Introduction to the Query Optindzer
Obtaining Execution Plan InfOrmation
Using an Index to Cover a Query
Indexing Strategies
Ovetriding the Query Optimizer
Recommended Practices
Lab A: Optimizing Query PerfOrmance
Review
ModuIe 14: AnaIyzing Queries
Instructor Notes
Overview
Queries That Use the AND Operator
Queries That Use the OR Operator
Lab AAnalyzing Queries That Use the AND and OR Operators
Queries That Use Join Operations
Lab Bf Analyzing Queries That Use Different JoinStrategies
Recommended Practices
Review
Module 15: Managing Transactions and Locks
Instmctor Notes
Overview
Introduction to Transactions and Locks
Managing Transactions
SQL Server Locking
Managing Locks
Recommended Practices
Lab Af Managing Transactions and Locks
Review