影印版

定　价：¥99.00

作　者：	（美）微软公司
出版社：	北京希望电子出版社
丛编项：	MS SQL SERVER 2000数据库程序设计
标　签：	影印版数据库

ISBN：	9787900056559	出版时间：	2001-01-01	包装：
开本：	787*1092 1/1	页数：	660	字数：

内容简介

　　本盘书是微软认证高级技术培训中心（CTEC）标准教材系列之一，课程号是2073A。本盘书详细讨论了Microsoft SQL Server 2000及其数据库设计的基本知识，通过具体实验培养读者的动手能力。全书分为十五个单元，分别为：SQL Server概述、SQL Server编程概述、创建和管理数据库、创建数据类型和表、实现数据完整性、计划索引、创建和维护索引、实现视图、实现存储过程、实现用户自定义函数、实现触发器、多服务器分布式编程、优化查询性能、分析查询、管理事务处理和锁等。在每个单元中，都给出了考察读者对本单元内容掌握情况的练习题，有助于读者自我评价课程掌握情况。本盘书内容新颖，全面涵盖了SQL Server 2000数据库设计的基础知识，是SQL Server 2000数据库认证考试的权威教材。它是参加微软认证考试的各类读者的必备读物，也是需要掌握SQL Server 2000 数据库设计基础知识的从业人员的不可缺少的自学读物和社会相关领域培训班教材。本光盘内容包括：在课堂中使用的所有练习文件。

作者简介

暂缺《影印版》作者简介

图书目录

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