Microsoft SQL Server 2000使用Transact-SQL進(jìn)行數(shù)據(jù)庫查詢

引言                  
   講授提示                  
   概述                  
   課程材料                  
   準(zhǔn)備工作                  
   本課程概覽                  
   附錄                  
   微軟專業(yè)認(rèn)證方案                  
   設(shè)備                  
   關(guān)于本課程                  
   課程時間安排                  
   培訓(xùn)員教材光盤內(nèi)容                  
   學(xué)生教材光盤內(nèi)容                  
 第1單元　Transact-SQL概述                  
   概述                  
   Transact－SQL編程語言                  
   Transact-SQL語句的類型                  
   Transact-SQL語法要素                  
   系統(tǒng)函數(shù)                  
   實(shí)驗(yàn)A  使用 SQL Server聯(lián)機(jī)幫助                  
   復(fù)習(xí)                  
 第2單元  使用Transact-SQL的查詢工具                  
   概述                  
   SQL Query Analyzer（SQL查詢分析器）                  
   使用SQL Query Analyzer中的對象瀏覽工具                  
   使用SQL Query Analyzer模板                  
   使用osql工具                  
   執(zhí)行Transact-SQL語句                  
   推薦練習(xí)                  
   實(shí)驗(yàn)A  創(chuàng)建并執(zhí)行Transact-SQL腳本                  
   復(fù)習(xí)                  
 第3單元  數(shù)據(jù)查詢                  
   概述                  
   使用SELECT語句查詢數(shù)據(jù)                  
   過濾數(shù)據(jù)                  
   格式化結(jié)果集                  
   查詢的工作原理                  
   查詢使如何被自動緩存的                  
   影響性能的注意事項(xiàng)                  
   推薦練習(xí)                  
   實(shí)驗(yàn)A　查詢數(shù)據(jù)并操作結(jié)果集                  
   復(fù)習(xí)                  
 第4單元　數(shù)據(jù)分組和匯總                  
   概述                  
   用TOPn列出前n個記錄                  
   使用聚集函數(shù)                  
   GROUP BY使用基礎(chǔ)                  
   在結(jié)果集中生成匯總值                  
   使用 COMPUTE和 COMPM BY子句                  
   推薦練習(xí)                  
   實(shí)驗(yàn)A  數(shù)據(jù)分組和匯總                  
   復(fù)習(xí)                  
 第5單元  多表連接                  
   概述                  
   使用表的別名                  
   從多個表中合并數(shù)據(jù)                  
   合并多個結(jié)果集                  
   推薦練習(xí)                  
   實(shí)驗(yàn)A  查詢多個表                  
   復(fù)習(xí)                  
 第6單元  使用子查詢                  
   概述                  
   子查詢介紹                  
   把子查詢用作派生的表                  
   把子查詢用作表達(dá)式                  
   用于查詢關(guān)聯(lián)數(shù)據(jù)                  
   使用 EXISTS和 NOT EXIST操作符                  
   推薦練習(xí)                  
   實(shí)驗(yàn)A  使用子查詢                  
   復(fù)習(xí)                  
 第7單元  數(shù)據(jù)修改                  
   概述                  
   使用事務(wù)                  
   插入數(shù)據(jù)                  
   刪除數(shù)據(jù)                  
   更新數(shù)據(jù)                  
   性能因素                  
   推薦練習(xí)                  
   實(shí)驗(yàn)A  修改數(shù)據(jù)                  
   復(fù)習(xí)                  
 第8單元  全文索引查詢                  
   概述                  
   Microsoft Search介紹                  
   Microsoft Search組件                  
   獲取全文索引的信總                  
   編寫全文檢索查詢                  
   推薦練習(xí)                  
   實(shí)驗(yàn)A  全文索引                  
   復(fù)習(xí)                  
 第9單元  對象編程                  
   概述                  
   描述編程對象的文本內(nèi)容                  
   視圖介紹                  
   視圖的優(yōu)點(diǎn)                  
   創(chuàng)建視圖                  
   介紹存儲過程                  
   觸發(fā)器介紹                  
   介紹用戶自定義函數(shù)                  
   推薦練習(xí)                  
   實(shí)驗(yàn)A  使用視圖                  
   復(fù)習(xí)                  
 附錄A  圖書館數(shù)據(jù)庫案例學(xué)習(xí)                  
 附錄B  數(shù)據(jù)庫模式