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

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