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