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