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