MySQL數(shù)據(jù)庫(kù)技術(shù)項(xiàng)目化教程
定 價(jià)：39 元
- 作者：劉振棟
- 出版時(shí)間：2023/6/1
- ISBN：9787121455452
- 出 版 社：電子工業(yè)出版社
- 中圖法分類(lèi)：TP311.132.3
- 頁(yè)碼：184
- 紙張：
- 版次：01
- 開(kāi)本：16開(kāi)
鑒于數(shù)據(jù)庫(kù)的基礎(chǔ)地位，講授如何使用數(shù)據(jù)庫(kù)技術(shù)對(duì)數(shù)據(jù)進(jìn)行有效組織、存儲(chǔ)、管理、檢索與維護(hù)的數(shù)據(jù)庫(kù)類(lèi)課程已成為軟件開(kāi)發(fā)類(lèi)、計(jì)算機(jī)類(lèi)、電子商務(wù)類(lèi)、信息管理類(lèi)等相關(guān)專(zhuān)業(yè)的基礎(chǔ)課程或?qū)I(yè)必修課程。通過(guò)數(shù)據(jù)庫(kù)類(lèi)課程的學(xué)習(xí),學(xué)生應(yīng)能有意識(shí)地搜集并利用數(shù)據(jù)提升工作效率與效能，優(yōu)化社會(huì)資源配置，從而為我國(guó)的信息化、數(shù)字化、智能化建設(shè)貢獻(xiàn)自己的力量。 本書(shū)可以作為高職高專(zhuān)院校軟件開(kāi)發(fā)專(zhuān)業(yè)、計(jì)算機(jī)專(zhuān)業(yè)、信息管理專(zhuān)業(yè)的教材，也可作為數(shù)據(jù)庫(kù)開(kāi)發(fā)與管理愛(ài)好者的參考書(shū)。 全書(shū)是校企合作共同編寫(xiě)的結(jié)果，在編寫(xiě)過(guò)程中得到了科大訊飛股份有限公司高教人才事業(yè)群的大力支持。 從"教”與"學(xué)”兩個(gè)角度合理組織內(nèi)容，并以真實(shí)項(xiàng)目信貸系統(tǒng)數(shù)據(jù)庫(kù)設(shè)計(jì)與開(kāi)發(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ō)明書(shū)、項(xiàng)目數(shù)據(jù)庫(kù)開(kāi)發(fā)環(huán)境部署、項(xiàng)目數(shù)據(jù)表建立與管理、項(xiàng)目數(shù)據(jù)查詢(xún)、數(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)專(zhuān)業(yè)課程教學(xué)工作，是中華職業(yè)教育社會(huì)員、重慶市職業(yè)技能培訓(xùn)領(lǐng)域?qū)＜抑菐?kù)專(zhuān)家，曾參與重慶市教委基金項(xiàng)目基于WSN技術(shù)的露天開(kāi)放場(chǎng)所汽車(chē)智能管理系統(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ù)開(kāi)發(fā)環(huán)境搭建與開(kāi)發(fā)實(shí)踐》、《計(jì)算機(jī)網(wǎng)絡(luò)基礎(chǔ)項(xiàng)目化教程》等多本著作。
項(xiàng)目一 項(xiàng)目說(shuō)明書(shū) ··························································································.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ù)類(lèi)型 ······················································.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ù)查詢(xún) ·····················································································.80
任務(wù)一 單表數(shù)據(jù)查詢(xún) ··········································································.80
任務(wù)二 分組數(shù)據(jù)查詢(xún) ··········································································.91
任務(wù)三 多表連接查詢(xún) ··········································································.93
任務(wù)四 子查詢(xún) ···················································································.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
書(shū)單推薦
