MySQL數據庫技術與應用
胡曉輝、肖新元、曹方玲、趙頔、張煜、陳慧嬌
商品描述
"本書通過“學生信息管理系統”典型案例，採用MySQL 8.0，由淺入深、循序漸進地介紹數據庫的設計及MySQL相關概念與技術。全書共8個項目：認識數據庫、創建與管理數據庫、創建與管理數據表、數據處理、數據查詢、索引與視圖、數據庫編程和數據安全。全書理論與實踐相結合，每個任務的任務實施部分均有實施過程、執行結果等內容，能加深學生對知識點的理解，且本書配有在線開放課程，讀者可以通過資源鏈接實現靈活學習。 本書內容豐富、難度適中、可操作性強，既可以作為高職高專、應用型本科院校電腦類專業的學生用書，也可以作為全國電腦等級考試及“1+X”Web前端開發職業技能等級考試的參考用書，還可以作為廣大電腦愛好者的自學用書。"
目錄大綱
目 錄
項目1 認識數據庫
.
.........................................................................................................1
任務1.1 數據庫概述
.
.....................................................................................................1
知識點1 數據庫的基本概念
.
.................................................................................2
知識點2 數據庫發展史
.
........................................................................................2
知識點3 數據庫系統
.
...........................................................................................3
知識點4 數據模型
.
...............................................................................................3
知識點5 關系型數據庫
.
........................................................................................5
知識點6 常見的數據庫管理系統
.
.........................................................................7
任務1.2 MySQL的安裝與配置
.
....................................................................................8
知識點1 MySQL的優勢
.
......................................................................................9
知識點2 MySQL圖形化管理工具........................................................................9
任務1.3 數據庫設計
.
...................................................................................................22
知識點1 數據庫設計步驟
.
..................................................................................23
知識點2 概念設計
.
.............................................................................................23
知識點3 E-R圖設計實例
.
..................................................................................25
知識點4 邏輯結構設計
.
......................................................................................26
知識點5 數據庫設計規範化
.
...............................................................................27
項目2 創建與管理數據庫
.
............................................................................................34
任務2.1 創建數據庫
.
...................................................................................................34
知識點1 數據庫的構成
.
......................................................................................35
知識點2 數據庫的創建
.
......................................................................................35
知識點3 MySQL中的字符集和校對規則
.
...........................................................36
知識點4 數據庫的查看
.
......................................................................................36
任務2.2 管理數據庫
.
...................................................................................................41
知識點1 MySQL數據庫字符集及排序規則的查看
.
............................................41
知識點2 當前數據庫的指定
.
...............................................................................42
知識點3 數據庫的修改
.
......................................................................................42
知識點4 數據庫的刪除
.
......................................................................................42
任務2.3 使用圖形化管理工具管理數據庫
.
..................................................................45
項目3 創建與管理數據表
.
............................................................................................49
任務3.1 創建數據表
.
...................................................................................................49
知識點1 數據類型
.
.............................................................................................50
知識點2 數據表的創建
.
......................................................................................54
知識點3 數據表的查看
.
......................................................................................54
任務3.2 管理數據表
.
...................................................................................................59
知識點1 數據表的修改
.
......................................................................................59
知識點2 數據表的復制
.
......................................................................................60
知識點3 數據表的刪除
.
......................................................................................61
任務3.3 數據完整性約束
.
...........................................................................................65
知識點1 數據完整性約束總述
.
...........................................................................66
知識點2 主鍵約束
.
.............................................................................................67
知識點3 UNIQUE約束
.
......................................................................................67
知識點4 DEFAULT約束 ........................................................................................68
知識點5 FOREIGN
KEY約束
.
............................................................................68
知識點6 CHECK約束
.
.......................................................................................69
知識點7 約束的刪除 ..............................................................................................70
任務3.4 使用圖形化管理工具管理數據表
.
..................................................................74
項目4 數據處理
.
..........................................................................................................80
任務4.1 插入數據
.
......................................................................................................80
知識點1 INSERT…VALUES語句和INSERT…SET語句
.
...................................81
知識點2 INSERT…SELECT語句
.
......................................................................82
任務4.2 修改與刪除數據
.
...........................................................................................87
知識點1 數據的修改
.
.........................................................................................87
知識點2 數據的刪除
.
.........................................................................................88
知識點3 使用TRUNCATE語句清空數據表
.
......................................................88
項目5 數據查詢
.
..........................................................................................................95
任務5.1 簡單查詢
.
......................................................................................................95
知識點1 SELECT語句的基本格式
.
....................................................................96
知識點2 數據表中指定字段的選擇
.
....................................................................97
知識點3 查詢結果中列標題的修改
.
....................................................................97
知識點4 查詢結果中數據的替換
.
.......................................................................98
知識點5 結果集中重復行的消除
.
.......................................................................98
知識點6 字段值的計算
.
......................................................................................99
任務5.2 條件查詢
.
....................................................................................................108
知識點1 條件查詢總述
.
....................................................................................109
知識點2 比較運算
.
...........................................................................................109
知識點3 邏輯運算
.
...........................................................................................110
知識點4 範圍查詢
.
...........................................................................................111
知識點5 空值查詢
.
...........................................................................................111
知識點6 模糊查詢
.
...........................................................................................111
任務5.3 多表查詢
.
....................................................................................................117
知識點1 FROM子句
.
.......................................................................................117
知識點2 笛卡兒積
.
...........................................................................................118
知識點3 交叉連接
.
...........................................................................................118
知識點4 內連接
.
...............................................................................................119
知識點5 外連接
.
...............................................................................................120
知識點6 比較子查詢
.
.......................................................................................121
知識點7
EXISTS子查詢
.
.................................................................................121
知識點8 聯合查詢
.
...........................................................................................122
任務5.4 數據匯總與排序
.
.........................................................................................130
知識點1 聚合函數
.
...........................................................................................130
知識點2 GROUP
BY子句
.
...............................................................................131
知識點3 HAVING子句
.
....................................................................................131
知識點4 ORDER
BY子句
.
...............................................................................132
知識點5 LIMIT子句
.
........................................................................................132
項目6 索引與視圖
.
.....................................................................................................140
任務6.1 索引簡介
.
....................................................................................................140
知識點1 索引的概述
.
.......................................................................................141
知識點2 索引的創建
.
.......................................................................................142
知識點3 索引的查看
.
.......................................................................................145
知識點4 索引的刪除
.
.......................................................................................146
任務6.2 視圖
.
...........................................................................................................152
知識點1 視圖的概述
.
.......................................................................................153
知識點2 視圖的創建
.
.......................................................................................153
知識點3 視圖的修改
.
.......................................................................................154
知識點4 視圖的查看
.
.......................................................................................154
知識點5 視圖的更新
.
.......................................................................................155
知識點6 視圖的查詢
.
.......................................................................................155
知識點7 視圖的刪除
.
.......................................................................................155
知識點8 使用圖形化管理工具管理視圖
.
...........................................................156
項目7 數據庫編程
.
.....................................................................................................166
任務7.1 編程基礎知識
.
.............................................................................................166
知識點1 註釋和語句結束符
.
.............................................................................167
知識點2 數據類型
.
...........................................................................................168
知識點3 變量
.
..................................................................................................168
知識點4 運算符和表達式
.
................................................................................170
知識點5 流程控制結構
.
....................................................................................170
知識點6 數據庫信息查詢命令
.
.........................................................................174
知識點7 SQL基礎命令
.
...................................................................................175
知識點8 系統內置函數
.
....................................................................................176
任務7.2 存儲過程
.
....................................................................................................182
知識點1 存儲過程的創建和運行
.
.....................................................................183
知識點2 存儲過程的列表和查看
.
.....................................................................185
知識點3 存儲過程的修改和刪除
.
.....................................................................186
知識點4 錯誤處理
.
...........................................................................................187
知識點5 光標
.
..................................................................................................190
任務7.3 存儲函數
.
....................................................................................................195
知識點1 存儲函數的創建和調用
.
.....................................................................196
知識點2 存儲函數的列表和查看
.
.....................................................................197
知識點3 存儲函數的修改和刪除
.
.....................................................................198
任務7.4 觸發器
.
........................................................................................................201
知識點1 觸發器的創建
.
....................................................................................202
知識點2 觸發器的查看
.
....................................................................................203
知識點3 觸發器的刪除
.
....................................................................................203
項目8 數據安全
.
........................................................................................................207
任務8.1 用戶的權限和安全
.
......................................................................................207
知識點1 用戶管理
.
...........................................................................................208
知識點2 權限管理
.
...........................................................................................209
知識點3 使用圖形化管理工具管理用戶和權限
.
................................................211
任務8.2 數據的備份和還原
.
......................................................................................216
知識點1 系統數據庫的備份
.
.............................................................................217
知識點2 系統數據庫的還原
.
.............................................................................219
知識點3 系統數據表的導入/導出
.
...................................................................219
任務8.3 事務與鎖定機制
.
.........................................................................................229
知識點1 事務的管理
.
.......................................................................................230
知識點2 鎖定機制
.
...........................................................................................232
參考文獻
.
......................................................................................................................238
