《MySQL資料庫技術項目化教程》是電子工業出版社出版的圖書，作者是劉振棟,柏世兵,黃天春。
基本介紹
- 中文名：MySQL資料庫技術項目化教程
- 作者：劉振棟,柏世兵,黃天春
- 出版時間：2023年6月
- 出版社：電子工業出版社
- 頁數：184 頁
- 字數：294千字
- ISBN：9787121455452
- 開本：16 開
內容簡介,圖書目錄,
內容簡介
鑒於資料庫的基礎地位，講授如何使用資料庫技術對數據進行有效組織、存儲、管理、檢索與維護的資料庫類課程已成為軟體開發類、計算機類、電子商務類、信息管理類等相關專業的基礎課程或專業必修課程。通過資料庫類課程的學習,學生應能有意識地蒐集並利用數據提升工作效率與效能，最佳化社會資源配置，從而為我國的信息化、數位化、智慧型化建設貢獻自己的力量。 本書可以作為高職高專院校軟體開發專業、計算機專業、信息管理專業的教材，也可作為資料庫開發與管理愛好者的參考書。 全書是校企合作共同編寫的結果，在編寫過程中得到了科大訊飛股份有限公司高教人才事業群的大力支持。 從"教”與"學”兩個角度合理組織內容，並以真實項目信貸系統資料庫設計與開發為主線，通過項目案例將MySQL資料庫知識點有機地串聯在一起，循序漸進、深入淺出，並輔以教師教學服務資源（特別是實踐教學資源）、讀者學習輔助資源。 《Mysql資料庫技術項目化教程》基於信貸管理系統項目，以項目為導向、以任務為驅動，分為項目說明書、項目資料庫開發環境部署、項目數據表建立與管理、項目數據查詢、資料庫編程、資料庫索引與視圖、資料庫安全及性能最佳化、信貸管理系統集成9個項目。
圖書目錄
項目一 項目說明書 ··························································································.1
任務一 需求分析 ·················································································.1
任務二 功能分析 ·················································································.8
任務三 資料庫設計 ·············································································.10
【項目小結】 ······················································································.23
【提升練習】 ······················································································.23
項目二 MySQL 的安裝與配置 ···········································································.24
任務一 安裝與配置 MySQL ···································································.24
任務二 啟動、登錄、退出和停止 MySQL ·················································.36
【項目小結】 ······················································································.42
【提升練習】 ······················································································.42
項目三 資料庫的基本操作 ···············································································.43
任務一 創建資料庫 ·············································································.43
任務二 查看和選擇資料庫 ····································································.46
任務三 退出和刪除資料庫 ····································································.48
【項目小結】 ······················································································.50
【提升練習】 ······················································································.50
項目四 數據表的創建與管理 ············································································.51
任務一 掌握 MySQL 的常用數據類型 ······················································.51
任務二 數據表的創建與管理 ·································································.54
任務三 數據管理 ················································································.60
任務四 數據約束管理 ··········································································.68
【項目小結】 ······················································································.76
【提升練習】 ······················································································.76
項目五 項目數據查詢 ·····················································································.80
任務一 單表數據查詢 ··········································································.80
任務二 分組數據查詢 ··········································································.91
任務三 多表連線查詢 ··········································································.93
任務四 子查詢 ···················································································.96
【項目小結】 ······················································································.99
【提升練習】 ······················································································.99
項目六 資料庫編程 ······················································································.101
任務一 存儲過程操作 ········································································.101
任務二 創建和調用存儲函式 ·······························································.115
任務三 設定觸發器 ···········································································.118
任務四 創建事件 ··············································································.121
【項目小結】 ····················································································.122
【提升練習】 ····················································································.123
項目七 資料庫索引與視圖 ·············································································.124
任務一 索引創建和管理 ·····································································.124
任務二 視圖創建和管理 ·····································································.131
【項目小結】 ····················································································.140
【提升練習】 ····················································································.140
項目八 資料庫安全及性能最佳化 ·······································································.141
任務一 用戶與許可權管理 ·····································································.141
任務二 資料庫備份與恢復 ··································································.150
任務三 資料庫性能最佳化 ·····································································.155
【項目小結】 ····················································································.158
【提升練習】 ····················································································.158
項目九 信貸管理系統資料庫設計 ····································································.159
任務一 信貸管理系統資料庫需求分析 ···················································.159
任務二 信貸管理系統資料庫概念模型設計 ·············································.166
任務三 信貸管理系統資料庫邏輯模型設計 ·············································.167
任務四 信貸管理系統資料庫物理模型設計 ·············································.170
【項目小結】 ····················································································.176
【提升練習】 ····················································································.176
參考文獻 ·····································································································.178
