緒論...................................................................................................................................... 1
項目一 “天意購物”數(shù)據(jù)庫設(shè)計與實現(xiàn)................................................................................11
任務(wù)一 數(shù)據(jù)庫的規(guī)劃設(shè)計 .....................................................................................................11
任務(wù)二 數(shù)據(jù)庫的創(chuàng)建.............................................................................................................14
任務(wù)三 數(shù)據(jù)庫的維護.............................................................................................................19
綜合實訓(xùn)..................................................................................................................................30
項目二 “天意購物”數(shù)據(jù)庫中數(shù)據(jù)表的創(chuàng)建與管理............................................................. 32
任務(wù)一 創(chuàng)建數(shù)據(jù)表.................................................................................................................32
任務(wù)二 數(shù)據(jù)表記錄的編輯 .....................................................................................................47
任務(wù)三 數(shù)據(jù)表的維護.............................................................................................................51
綜合實訓(xùn)..................................................................................................................................53
項目三 實現(xiàn)“天意購物”數(shù)據(jù)庫中數(shù)據(jù)的查詢.................................................................. 57
任務(wù)一 單表查詢 ....................................................................................................................57
任務(wù)二 多表查詢 ....................................................................................................................72
任務(wù)三 高級查詢 ....................................................................................................................81
綜合實訓(xùn)..................................................................................................................................85
項目四 “天意購物”數(shù)據(jù)庫中視圖與索引的使用................................................................. 86
任務(wù)一 視圖的創(chuàng)建、刪除和維護..........................................................................................86
任務(wù)二 索引的創(chuàng)建、刪除和維護..........................................................................................93
綜合實訓(xùn)................................................................................................................................101
項目五 程序設(shè)計............................................................................................................. 103
任務(wù)一 T-SQL 編程 ..............................................................................................................103
任務(wù)二 存儲過程 ..................................................................................................................114
任務(wù)三 觸發(fā)器 ......................................................................................................................122
綜合實訓(xùn)................................................................................................................................133
項目六 “天意購物”數(shù)據(jù)庫的安全與保護機制.................................................................. 134
任務(wù)一 數(shù)據(jù)庫安全...............................................................................................................134
任務(wù)二 數(shù)據(jù)庫的備份與還原 ...............................................................................................149
綜合實訓(xùn)................................................................................................................................161