MySQL数据库技术项目化教程
正版保障 假一赔十 可开发票
￥ 24.56 6.3折 ￥ 39 全新
库存64件
广东广州
认证卖家担保交易快速发货售后保障
作者刘振栋，柏世兵，黄天春主编
出版社电子工业出版社
ISBN9787121455452
出版时间2023-06
装帧平装
开本其他
定价39元
货号13093405
上书时间2025-01-01
商品详情
- 品相描述：全新
- 商品描述
-
作者简介
" 刘振栋，毕业于吉首大学，2017年至今任职于重庆城市职业学院，主要从事计算机相关专业课程教学工作，是中华职业教育社会员、重庆市职业技能培训领域专家智库专家，曾参与重庆市教委基金项目基于WSN技术的露天开放场所汽车智能管理系统研究与实现等多项重点项目和课题，曾荣获""全国应用型课程改革实践征文大赛”三等奖等多项教学奖项，出版了《大数据开发环境搭建与开发实践》、《计算机网络基础项目化教程》等多本著作。"
目录
项目一 项目说明书 ··························································································.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
内容摘要
鉴于数据库的基础地位，讲授如何使用数据库技术对数据进行有效组织、存储、管理、检索与维护的数据库类课程已成为软件开发类、计算机类、电子商务类、信息管理类等相关专业的基础课程或专业必修课程。通过数据库类课程的学习,学生应能有意识地搜集并利用数据提升工作效率与效能，优化社会资源配置，从而为我国的信息化、数字化、智能化建设贡献自己的力量。 本书可以作为高职高专院校软件开发专业、计算机专业、信息管理专业的教材，也可作为数据库开发与管理爱好者的参考书。 全书是校企合作共同编写的结果，在编写过程中得到了科大讯飞股份有限公司高教人才事业群的大力支持。 从"教”与"学”两个角度合理组织内容，并以真实项目信贷系统数据库设计与开发为主线，通过项目案例将MySQL数据库知识点有机地串联在一起，循序渐进、深入浅出，并辅以教师教学服务资源（特别是实践教学资源)、读者学习辅助资源。 《Mysql数据库技术项目化教程》基于信贷管理系统项目，以项目为导向、以任务为驱动，分为项目说明书、项目数据库开发环境部署、项目数据表建立与管理、项目数据查询、数据库编程、数据库索引与视图、数据库安全及性能优化、信贷管理系统集成9个项目。
主编推荐
"编者结合金融信贷管理平台的开发经验，从“教”与“学”两个角度合理地组织内 容，以真实项目“信贷管理系统数据库设计与开发”为主线编写了本书，通过项目案例将 MySQL 数据库的知识点串联在一起。"
精彩内容
鉴于数据库的基础地位，讲授如何使用数据库技术对数据进行有效组织、存储、管理、检索与维护的数据库类课程已成为软件开发类、计算机类、电子商务类、信息管理类等相关专业的基础课程或专业必修课程。通过数据库类课程的学习,学生应能有意识地搜集并利用数据提升工作效率与效能，优化社会资源配置，从而为我国的信息化、数字化、智能化建设贡献自己的力量。 本书可以作为高职高专院校软件开发专业、计算机专业、信息管理专业的教材，也可作为数据库开发与管理爱好者的参考书。 全书是校企合作共同编写的结果，在编写过程中得到了科大讯飞股份有限公司高教人才事业群的大力支持。 从"教”与"学”两个角度合理组织内容，并以真实项目信贷系统数据库设计与开发为主线，通过项目案例将MySQL数据库知识点有机地串联在一起，循序渐进、深入浅出，并辅以教师教学服务资源（特别是实践教学资源)、读者学习辅助资源。 《Mysql数据库技术项目化教程》基于信贷管理系统项目，以项目为导向、以任务为驱动，分为项目说明书、项目数据库开发环境部署、项目数据表建立与管理、项目数据查询、数据库编程、数据库索引与视图、数据库安全及性能优化、信贷管理系统集成9个项目。
— 没有更多了 —
以下为对购买帮助不大的评价