MySQL數(shù)據(jù)庫(kù)技術(shù)項(xiàng)目化教程
定 價(jià):39 元
- 作者:劉振棟
- 出版時(shí)間:2023/6/1
- ISBN:9787121455452
- 出 版 社:電子工業(yè)出版社
- 中圖法分類:TP311.132.3
- 頁(yè)碼:184
- 紙張:
- 版次:01
- 開本:16開
鑒于數(shù)據(jù)庫(kù)的基礎(chǔ)地位,講授如何使用數(shù)據(jù)庫(kù)技術(shù)對(duì)數(shù)據(jù)進(jìn)行有效組織、存儲(chǔ)、管理、檢索與維護(hù)的數(shù)據(jù)庫(kù)類課程已成為軟件開發(fā)類、計(jì)算機(jī)類、電子商務(wù)類、信息管理類等相關(guān)專業(yè)的基礎(chǔ)課程或?qū)I(yè)必修課程。通過(guò)數(shù)據(jù)庫(kù)類課程的學(xué)習(xí),學(xué)生應(yīng)能有意識(shí)地搜集并利用數(shù)據(jù)提升工作效率與效能,優(yōu)化社會(huì)資源配置,從而為我國(guó)的信息化、數(shù)字化、智能化建設(shè)貢獻(xiàn)自己的力量。 本書可以作為高職高專院校軟件開發(fā)專業(yè)、計(jì)算機(jī)專業(yè)、信息管理專業(yè)的教材,也可作為數(shù)據(jù)庫(kù)開發(fā)與管理愛好者的參考書。 全書是校企合作共同編寫的結(jié)果,在編寫過(guò)程中得到了科大訊飛股份有限公司高教人才事業(yè)群的大力支持。 從"教”與"學(xué)”兩個(gè)角度合理組織內(nèi)容,并以真實(shí)項(xiàng)目信貸系統(tǒng)數(shù)據(jù)庫(kù)設(shè)計(jì)與開發(fā)為主線,通過(guò)項(xiàng)目案例將MySQL數(shù)據(jù)庫(kù)知識(shí)點(diǎn)有機(jī)地串聯(lián)在一起,循序漸進(jìn)、深入淺出,并輔以教師教學(xué)服務(wù)資源(特別是實(shí)踐教學(xué)資源)、讀者學(xué)習(xí)輔助資源。 《Mysql數(shù)據(jù)庫(kù)技術(shù)項(xiàng)目化教程》基于信貸管理系統(tǒng)項(xiàng)目,以項(xiàng)目為導(dǎo)向、以任務(wù)為驅(qū)動(dòng),分為項(xiàng)目說(shuō)明書、項(xiàng)目數(shù)據(jù)庫(kù)開發(fā)環(huán)境部署、項(xiàng)目數(shù)據(jù)表建立與管理、項(xiàng)目數(shù)據(jù)查詢、數(shù)據(jù)庫(kù)編程、數(shù)據(jù)庫(kù)索引與視圖、數(shù)據(jù)庫(kù)安全及性能優(yōu)化、信貸管理系統(tǒng)集成9個(gè)項(xiàng)目。
劉振棟,畢業(yè)于吉首大學(xué),2017年至今任職于重慶城市職業(yè)學(xué)院,主要從事計(jì)算機(jī)相關(guān)專業(yè)課程教學(xué)工作,是中華職業(yè)教育社會(huì)員、重慶市職業(yè)技能培訓(xùn)領(lǐng)域?qū)<抑菐?kù)專家,曾參與重慶市教委基金項(xiàng)目基于WSN技術(shù)的露天開放場(chǎng)所汽車智能管理系統(tǒng)研究與實(shí)現(xiàn)等多項(xiàng)重點(diǎn)項(xiàng)目和課題,曾榮獲"全國(guó)應(yīng)用型課程改革實(shí)踐征文大賽”三等獎(jiǎng)等多項(xiàng)教學(xué)獎(jiǎng)項(xiàng),出版了《大數(shù)據(jù)開發(fā)環(huán)境搭建與開發(fā)實(shí)踐》、《計(jì)算機(jī)網(wǎng)絡(luò)基礎(chǔ)項(xiàng)目化教程》等多本著作。
項(xiàng)目一 項(xiàng)目說(shuō)明書 ··························································································.1
任務(wù)一 需求分析 ·················································································.1
任務(wù)二 功能分析 ·················································································.8
任務(wù)三 數(shù)據(jù)庫(kù)設(shè)計(jì) ·············································································.10
【項(xiàng)目小結(jié)】 ······················································································.23
【提升練習(xí)】 ······················································································.23
項(xiàng)目二 MySQL 的安裝與配置 ···········································································.24
任務(wù)一 安裝與配置 MySQL ···································································.24
任務(wù)二 啟動(dòng)、登錄、退出和停止 MySQL ·················································.36
【項(xiàng)目小結(jié)】 ······················································································.42
【提升練習(xí)】 ······················································································.42
項(xiàng)目三 數(shù)據(jù)庫(kù)的基本操作 ···············································································.43
任務(wù)一 創(chuàng)建數(shù)據(jù)庫(kù) ·············································································.43
任務(wù)二 查看和選擇數(shù)據(jù)庫(kù) ····································································.46
任務(wù)三 退出和刪除數(shù)據(jù)庫(kù) ····································································.48
【項(xiàng)目小結(jié)】 ······················································································.50
【提升練習(xí)】 ······················································································.50
項(xiàng)目四 數(shù)據(jù)表的創(chuàng)建與管理 ············································································.51
任務(wù)一 掌握 MySQL 的常用數(shù)據(jù)類型 ······················································.51
任務(wù)二 數(shù)據(jù)表的創(chuàng)建與管理 ·································································.54
任務(wù)三 數(shù)據(jù)管理 ················································································.60
任務(wù)四 數(shù)據(jù)約束管理 ··········································································.68
【項(xiàng)目小結(jié)】 ······················································································.76
【提升練習(xí)】 ······················································································.76
項(xiàng)目五 項(xiàng)目數(shù)據(jù)查詢 ·····················································································.80
任務(wù)一 單表數(shù)據(jù)查詢 ··········································································.80
任務(wù)二 分組數(shù)據(jù)查詢 ··········································································.91
任務(wù)三 多表連接查詢 ··········································································.93
任務(wù)四 子查詢 ···················································································.96
【項(xiàng)目小結(jié)】 ······················································································.99
【提升練習(xí)】 ······················································································.99
項(xiàng)目六 數(shù)據(jù)庫(kù)編程 ······················································································.101
任務(wù)一 存儲(chǔ)過(guò)程操作 ········································································.101
任務(wù)二 創(chuàng)建和調(diào)用存儲(chǔ)函數(shù) ·······························································.115
任務(wù)三 設(shè)置觸發(fā)器 ···········································································.118
任務(wù)四 創(chuàng)建事件 ··············································································.121
【項(xiàng)目小結(jié)】 ····················································································.122
【提升練習(xí)】 ····················································································.123
項(xiàng)目七 數(shù)據(jù)庫(kù)索引與視圖 ·············································································.124
任務(wù)一 索引創(chuàng)建和管理 ·····································································.124
任務(wù)二 視圖創(chuàng)建和管理 ·····································································.131
【項(xiàng)目小結(jié)】 ····················································································.140
【提升練習(xí)】 ····················································································.140
項(xiàng)目八 數(shù)據(jù)庫(kù)安全及性能優(yōu)化 ·······································································.141
任務(wù)一 用戶與權(quán)限管理 ·····································································.141
任務(wù)二 數(shù)據(jù)庫(kù)備份與恢復(fù) ··································································.150
任務(wù)三 數(shù)據(jù)庫(kù)性能優(yōu)化 ·····································································.155
【項(xiàng)目小結(jié)】 ····················································································.158
【提升練習(xí)】 ····················································································.158
項(xiàng)目九 信貸管理系統(tǒng)數(shù)據(jù)庫(kù)設(shè)計(jì) ····································································.159
任務(wù)一 信貸管理系統(tǒng)數(shù)據(jù)庫(kù)需求分析 ···················································.159
任務(wù)二 信貸管理系統(tǒng)數(shù)據(jù)庫(kù)概念模型設(shè)計(jì) ·············································.166
任務(wù)三 信貸管理系統(tǒng)數(shù)據(jù)庫(kù)邏輯模型設(shè)計(jì) ·············································.167
任務(wù)四 信貸管理系統(tǒng)數(shù)據(jù)庫(kù)物理模型設(shè)計(jì) ·············································.170
【項(xiàng)目小結(jié)】 ····················································································.176
【提升練習(xí)】 ····················································································.176
參考文獻(xiàn) ·····································································································.178