MySQL数据库应用项目化微课教程
作 译 者：卢扬
出 版 日 期：2024-11-01
书 代 号：G0495940
Ｉ Ｓ Ｂ Ｎ：9787121495946
图书简介：
本书采用项目引导结合任务驱动的模式进行编写。全书分为两部分：示范篇和实训篇。 示范篇以“学生成绩管理系统”数据库项目为主线，将该数据库项目分解为多个任务，每个任务按照“知识目标”→“能力目标”→“任务情境”→“任务描述”→“任务分析”→“知识导读”→“任务实施”→“任务总结”的形式进行编排，详细讲述了数据库的设计、MySQL 数据库的创建与管理、MySQL数据库表数据的操作、MySQL 数据库数据的程序式处理、MySQL 数据库的运行与维护。 实训篇以“社区书房管理系统”数据库项目为主线，包括数据库的设计、数据库和表的管理、表数据的更新、表数据的查询、索引的应用、视图的应用、存储过程和存储函数的应用、触发器的应用、数据库的安全管理共 9 个实训任务，重点培养学生提出问题、分析问题和解决问题的综合能力。 本书以培养学生的数据库设计、应用和管理能力为目标，内容新颖，通俗易懂，实用性强，可作为高等院校、高等职业院校数据库相关课程的教材，也可作为广大技术人员及自学者参考用书。
-
配 套 资 源
-
图 书 内 容
内容简介
本书采用项目引导结合任务驱动的模式进行编写。全书分为两部分：示范篇和实训篇。 示范篇以“学生成绩管理系统”数据库项目为主线，将该数据库项目分解为多个任务，每个任务按照“知识目标”→“能力目标”→“任务情境”→“任务描述”→“任务分析”→“知识导读”→“任务实施”→“任务总结”的形式进行编排，详细讲述了数据库的设计、MySQL 数据库的创建与管理、MySQL数据库表数据的操作、MySQL 数据库数据的程序式处理、MySQL 数据库的运行与维护。 实训篇以“社区书房管理系统”数据库项目为主线，包括数据库的设计、数据库和表的管理、表数据的更新、表数据的查询、索引的应用、视图的应用、存储过程和存储函数的应用、触发器的应用、数据库的安全管理共 9 个实训任务，重点培养学生提出问题、分析问题和解决问题的综合能力。 本书以培养学生的数据库设计、应用和管理能力为目标，内容新颖，通俗易懂，实用性强，可作为高等院校、高等职业院校数据库相关课程的教材，也可作为广大技术人员及自学者参考用书。图书详情
ISBN：9787121495946开 本：16(185*260)页 数：256字 数：430本书目录
第一篇 示范篇——学生成绩 管理系统 工作任务一 数据库的设计··············································································.2 1.1 初识数据库系统················································································.2 1.1.1 数据库系统的基本概念 ······························································.3 1.1.2 数据库系统的基本特点 ······························································.6 1.1.3 数据库系统的内部体系结构 ························································.6 1.2 “学生成绩管理系统”数据库设计概述与需求分析··································.10 1.2.1 数据库设计概述·······································································.11 1.2.2 数据抽象过程··········································································.12 1.2.3 数据库设计的需求分析 ·····························································.12 1.3 “学生成绩管理系统”数据库概念设计·················································.21 1.3.1 概念模型················································································.22 1.3.2 概念模型的表示方法 ································································.23 1.3.3 E-R 模型的设计·······································································.24 1.4 “学生成绩管理系统”数据库逻辑设计·················································.26 1.4.1 关系模型的基本术语 ································································.27 1.4.2 关系的定义和性质····································································.28 1.4.3 关键码···················································································.29 1.4.4 E-R 模型到关系模型的转换························································.29 1.4.5 关系模式的规范化····································································.30 1.5 “学生成绩管理系统”数据库物理设计·················································.35 1.5.1 MySQL 简介···········································································.36 1.5.2 MySQL 系统数据类型·······························································.36 知识巩固 1 ····························································································.41 工作任务二 MySQL 数据库的创建与管理··························································44 2.1 “学生成绩管理系统”数据库创建和管理··············································.44 2.1.1 数据库概述·············································································.45 2.1.2 使用 Navicat 图形化工具创建数据库·············································.46 2.1.3 SQL 简介 ···············································································.48 2.1.4 使用 CREATE DATABASE 语句创建数据库 ··································.48 VI | MySQL 数据库应用项目化微课教程 2.1.5 使用 ALTER DATABASE 语句修改数据库 ····································.51 2.1.6 使用 DROP DATABASE 语句删除数据库 ······································.51 2.2 “学生成绩管理系统”数据表创建·······················································.52 2.2.1 数据表的概述··········································································.53 2.2.2 数据完整性·············································································.54 2.2.3 数据完整性约束·······································································.54 2.2.4 使用 Navicat 图形化工具创建数据表·············································.55 2.2.5 使用 CREATE TABLE 语句创建数据表·········································.57 2.2.6 使用 CREATE TABLE…LIKE 语句复制数据表·······························.58 2.3 “学生成绩管理系统”数据表管理·······················································.60 2.3.1 使用 SQL 语句显示表信息 ·························································.61 2.3.2 使用 Navicat 图形化工具修改数据表·············································.62 2.3.3 使用 ALTER TABLE 语句修改数据表···········································.63 2.3.4 使用 ALTER TABLE 语句修改表约束···········································.64 2.3.5 使用 RENAME TABLE 语句修改表名···········································.65 2.3.6 使用 DROP TABLE 语句删除数据表 ············································.66 知识巩固 2 ····························································································.67 工作任务三 MySQL 数据库表数据的操作··························································70 3.1 数据更新························································································.70 3.1.1 使用 Navicat 图形化工具更新数据················································.71 3.1.2 使用 INSERT 语句插入数据 ·······················································.72 3.1.3 使用 UPDATE 语句修改数据 ······················································.73 3.1.4 使用 DELETE 语句删除数据·······················································.73 3.1.5 使用 TRUNCATE TABLE 语句清空数据 ·······································.74 3.2 单表查询························································································.75 3.2.1 查询简介················································································.76 3.2.2 SELECT 查询··········································································.77 3.2.3 查询指定字段··········································································.77 3.2.4 查询满足条件的记录 ································································.78 3.2.5 查询结果的编辑·······································································.81 3.2.6 按指定列名排序·······································································.82 3.2.7 LIMIT 子句限制返回的行数 ·······················································.83 3.3 分组统计查询··················································································.86 3.3.1 聚合（集合）函数····································································.87 3.3.2 分组统计················································································.88 3.3.3 分组筛选················································································.89 3.4 多表连接查询··················································································.92 目录 | VII 3.4.1 使用连接谓词连接····································································.94 3.4.2 使用 JOIN 关键字连接 ······························································.95 3.5 嵌套查询······················································································.100 3.5.1 嵌套查询概述········································································.102 3.5.2 使用关系运算符的嵌套查询 ·····················································.102 3.5.3 使用谓词 IN 的嵌套查询··························································.103 3.5.4 使用谓词 EXISTS 的嵌套查询···················································.104 3.5.5 带子查询的数据更新 ······························································.105 3.6 索引····························································································.110 3.6.1 索引概述··············································································.111 3.6.2 使用 Navicat 图形化工具创建与删除索引·····································.112 3.6.3 创建索引··············································································.113 3.6.4 使用 SHOW INDEX 语句查看索引·············································.115 3.6.5 使用 DROP INDEX 语句删除索引··············································.115 3.7 视图的创建与应用··········································································.116 3.7.1 视图概述··············································································.117 3.7.2 使用 Navicat 图形化工具创建视图··············································.118 3.7.3 使用 CREATE VIEW 语句创建视图············································.120 3.7.4 使用 SQL 语句查看视图 ··························································.122 3.7.5 使用 ALTER VIEW 语句修改视图··············································.123 3.7.6 使用 DROP VIEW 语句删除视图 ···············································.123 3.7.7 通过视图管理数据··································································.123 知识巩固 3 ··························································································.126 工作任务四 MySQL 数据库数据的程序式处理 ·····················································.130 4.1 存储过程和存储函数的创建与应用·····················································.130 4.1.1 MySQL 编程基础···································································.131 4.1.2 存储过程··············································································.138 4.1.3 存储函数··············································································.144 4.1.4 流程控制语句········································································.147 4.1.5 游标····················································································.156 4.2 事务管理······················································································.161 4.2.1 事务的概念···········································································.162 4.2.2 事务的类型及操作··································································.163 4.3 触发器的创建和应用·······································································.167 4.3.1 触发器的概念········································································.168 4.3.2 创建与使用触发器··································································.168 4.3.3 查看触发器···········································································.170 VIII | MySQL 数据库应用项目化微课教程 4.3.4 删除触发器···········································································.170 知识巩固 4 ··························································································.171 工作任务五 MySQL 数据库的运行与维护·······················································.174 5.1 MySQL 环境搭建 ···········································································.174 5.1.1 MySQL 安装与配置································································.175 5.1.2 MySQL 图形化管理工具介绍····················································.175 5.1.3 MySQL 服务器操作································································.176 5.2 数据库的用户和权限管理·································································.193 5.2.1 用户管理··············································································.194 5.2.2 权限管理··············································································.198 5.3 数据库的备份与还原·······································································.206 5.3.1 备份和还原概述·····································································.207 5.3.2 使用 Navicat 图形化管理工具备份和还原数据库 ···························.207 5.3.3 使用 mysqldump 命令备份数据库···············································.210 5.3.4 使用 mysql 命令还原数据库······················································.211 5.3.5 MySQL 日志·········································································.212 5.4 表数据的导入与导出·······································································.214 5.4.1 使用 Navicat 图形化管理工具将数据导出到 Excel 中 ·····················.215 5.4.2 使用 Navicat 图形化管理工具导入 Excel 中的数据 ························.217 5.4.3 使用 mysql 命令导出为文本文件················································.220 5.4.4 使用 mysqlimport 命令导入文本文件···········································.221 知识巩固 5 ··························································································.224 第二篇 实训篇——社区书房管理系统 实训任务一 数据库的设计···········································································.228 一、实训目的·················································································.228 二、实训任务·················································································.228 实训任务二 数据库和表的管理·····································································.230 一、实训目的·················································································.230 二、实训任务·················································································.230 实训任务三 表数据的更新···········································································.233 一、实训目的·················································································.233 二、实训任务·················································································.233 实训任务四 表数据的查询···········································································.235 一、实训目的·················································································.235 目录 | IX 二、实训任务·················································································.235 实训任务五 索引的应用··············································································.238 一、实训目的·················································································.238 二、实训任务·················································································.238 实训任务六 视图的应用··············································································.239 一、实训目的·················································································.239 二、实训准备·················································································.239 三、实训任务·················································································.239 实训任务七 存储过程和存储函数的应用 ························································.241 一、实训目的·················································································.241 二、实训任务·················································································.241 实训任务八 触发器的应用···········································································.242 一、实训目的·················································································.242 二、实训任务·················································································.242 实训任务九 数据库的安全管理·····································································.243 一、实训目的·················································································.243 二、实训任务·················································································.243展开前 言
数据库技术是现代信息科学与技术的重要组成部分，也是计算机数据处理与信息管理系统的核心。数据库技术可以有效地组织和存储计算机信息处理过程中的大量数据，减少数据存储冗余，实现数据共享，保障数据安全，并且可以高效地查询处理数据。随着信息技术的发展，数据库技术在各行各业中得到了广泛的应用。因此，社会需要大量的高素质、技能型的专业人才来应用数据库技术。为了适应社会的发展，我们总结了多年数据库教学与应用的经验，组织编写了这本以职业能力为主、突出实践技能培养、充分体现职业教育理念的教材。 本书遵循“项目引导，任务驱动”的教学理念，将全书分为两部分：示范篇和实训篇。示范篇以“学生成绩管理系统”数据库项目为主线，根据数据库管理和应用工作过程，将该数据库项目分解为5个工作任务，分别为数据库的设计、MySQL数据库的创建与管理、MySQL数据库表数据的操作、MySQL数据库数据的程序式处理、MySQL数据库的运行与维护。 在编排时一改传统的学科体系内容编排形式，以工作过程为参照体系，将每个任务又细分为若干任务，并按照“知识目标”→“能力目标”→“任务情境”→“任务描述”→“任务分析”→“知识导读”→“任务实施”→“任务总结”的形式进行编排。首先，通过生动的“任务情境”对话，非常形象地引出任务的缘由和应用背景，引人入胜，使读者“知其然”，又“知其所以然”；然后，通过“任务描述”和“任务分析”部分，布置具体的任务内容，分析解决任务的方法；之后，在“知识导读”部分介绍相应的理论知识；接着，在“任务实施”部分给出完整的任务实施过程；最后，在“任务总结”部分归纳知识要点。学生在阅读本书并完成任务时，可以轻松地学习 MySQL 数据库的理论知识并进行实践操作，完成任务的过程既是学习的过程，也是工作的过程，教、学、做三位一体，将理论和实践相结合，充分体现了职业教育的特点。 实训篇以“社区书房管理系统”数据库项目为主线。在完成示范篇对应任务的学习和操作的基础上，结合教师的适当引导，要求学生自行设计完成任务的方案，并且实施该方案，培养学生提出问题、分析问题和解决问题的能力，使学生掌握知识，并且运用知识解决实际问题。 本书由扬州市职业大学卢扬、周欢、田永晔任主编：由扬州市职业大学张光桃、施俊任副主编。本书在编写过程中，还得到了扬州国脉通信发展有限责任公司等合作企业的大力支持，参考和引用了相关文献的内容，在此对所参考的文献作者及合作企业有关人员表示诚挚的谢意！ 特别说明：为保证书中软件界面截图与软件功能按钮的一致性，本书对软件界面截图中的功能按钮“其它”不进行修改，其正确写法应为“其他”。由于时间仓促，加上编者水平有限，书中疏漏之处在所难免，敬请读者批评指正。展开作者简介
卢扬，女，副教授，扬州市职业大学信息工程学院骨干教师。毕业于东南大学。主持校级精品课程"数据库应用”的建设，担任数据库应用、及计算机信息技术等课程的教学工作。参与了校级精品课程和省级成人高等教育精品课程"网页设计与制作”的建设。主持多项省级、校级课题。参与了省级软件技术专业群建设工作，承担了"数据库技术”网络课程的视频的录制工作。指导学生完成毕业设计，并荣获江苏省优秀毕业设计指导教师荣誉称号。先后参与编写了《网页设计与制作》 、《环境工程CAD设计与应用》 、《SQL SERVER数据库应用技术》，该作者具备一定的写作功底，态度较为认真。 -
样 章 试 读本书暂无样章试读！
-
图 书 评 价 我要评论
