教育>高职高专>计算机类
MySQL数据库技术项目化教程  

MySQL数据库技术项目化教程  "

作者:刘振栋,柏世兵,黄天春
ISBN:9787121455452
定价:¥39.0
字数:294千字
页数:184
出版时间:2023-06
开本:16开
版次:01-01
装帧:
出版社:电子工业出版社
简介

鉴于数据库的基础地位,讲授如何使用数据库技术对数据进行有效组织、存储、管理、检索与维护的数据库类课程已成为软件开发类、计算机类、电子商务类、信息管理类等相关专业的基础课程或专业必修课程。通过数据库类课程的学习,学生应能有意识地搜集并利用数据提升工作效率与效能,优化社会资源配置,从而为我国的信息化、数字化、智能化建设贡献自己的力量。 本书可以作为高职高专院校软件开发专业、计算机专业、信息管理专业的教材,也可作为数据库开发与管理爱好者的参考书。 全书是校企合作共同编写的结果,在编写过程中得到了科大讯飞股份有限公司高教人才事业群的大力支持。 从"教”与"学”两个角度合理组织内容,并以真实项目信贷系统数据库设计与开发为主线,通过项目案例将MySQL数据库知识点有机地串联在一起,循序渐进、深入浅出,并辅以教师教学服务资源(特别是实践教学资源)、读者学习辅助资源。 《Mysql数据库技术项目化教程》基于信贷管理系统项目,以项目为导向、以任务为驱动,分为项目说明书、项目数据库开发环境部署、项目数据表建立与管理、项目数据查询、数据库编程、数据库索引与视图、数据库安全及性能优化、信贷管理系统集成9个项目。

前言

当今社会被称为信息时代、移动互联网时代、大数据时代、智能时代等,信息起着极为重要的作用,不但成为人们生产和生活的核心要素,还是决策和智能的来源,人们的一切活动都在生产信息、利用信息、依靠信息。在这种背景下,用于管理信息的数据库(DataBase,DB)成为众多系统(例如信贷管理、企业资源计划、决策支持、客户关系管理、电商平台、物流、在线支付、智能交通、智慧城市等系统)必不可少的组成部分,为它们的正常运行和发挥作 用提供最基础的数据支持。就具体应用而言,由于数据量、访问压力、性能、安全需求、设计者偏好等的不同,使用 的数据库也不尽相同。目前主流的数据库管理系统有 Oracle、DB2、SQL Server、MySQL、GBase、MongoDB、Redis、HBase 等,其中,MySQL 由于简单、高效、开源等优点,已成为众多软件系统的首选数据库。 鉴于数据库的基础地位,如何使用数据库技术对数据进行有效的组织、存储、管理、检索与维护已成为软件工程、计算机科学与技术、电子商务、信息管理等相关专业的基础课程或专业必修课程。通过数据库课程的学习,学生能有意识地搜集并利用数据提升工作效率,优化社会资源配置,从而为我国的信息化、数字化、智能化建设贡献自己的力量。 为此,编者结合金融信贷管理平台的开发经验,从“教”与“学”两个角度合理地组织内容,以真实项目“信贷管理系统数据库设计与开发”为主线编写了本书,通过项目案例将MySQL 数据库的知识点串联在一起。为方便教学,本书还配有完备的电子教学服务资源(特别是实践教学资源)和学习辅助资源,请有需要的教师和学生扫描二维码下载。 本书具有以下特点。 (1)采用“项目一体化”教学方式,既有教师的讲述,又有学生独立思考、上机操作等内容。 (2)配套资源丰富。本书提供教学大纲、教学课件、电子教案、程序源码等多种教学资源,对重要的知识点和操作方法提供视频讲解,学生可以在线观看和学习。 (3)紧跟时代潮流,注重技术变化。书中包含了 MySQL 最新版本的特性和技术,以便使学生掌握的知识点更贴近岗位的实际需求。 (4)编写本书的教师都具有多年的教学和实际软件开发经验,能够突出重点和难点,激发学生的学习热情。 本书是校企合作的结果,在编写过程中得到了科大讯飞股份有限公司高教人才事业群的大力支持,在此对他们提供的实验案例和数据表示衷心的感谢。在编写过程中,编者参阅了大量相关资料,在此一并表示感谢!由于本书编者水平有限,书中难免会出现一些错误或者表述不准确、不严谨的地方,恳请读者批评指正。如果读者在教材使用中遇到问题,或者要学习更多的内容,请通过电子邮件联系编者,邮箱地址是:8932898@qq.com。

目录

项目一 项目说明书 ··························································································.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

作者简介

编辑推荐

作者寄语

电子资料

http://www.hxedu.com.cn/hxedu/fg/book/bookinfo.html?code=G0455450

www.luweidong.cn

下一个