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