Fundamentals of Databases
Tags
Summary
Using a library management system and a production management system as practice cases, it begins with concrete problem analysis and explains knowledge and operational skills in the process of solving problems. All examples are implemented and managed with SQL statements. The book serves as a beginner’s guide, a reference manual for intermediate and advanced users, and a foundational database textbook for colleges, universities, and training programs.
Editor's review
From a professional standpoint, the book’s positioning is clear: it serves lower-year students in computer science and related majors or career changers with no prior background. It sets aside certain advanced or cutting-edge topics (such as NoSQL and distributed databases) and instead solidifies instruction in basic operations including SELECT, INSERT, UPDATE, and DELETE—a trade-off that reflects the author’s judgment about teaching priorities. The discussion of the E-R model and relational normalization, though not deep, is sufficient to lay a key foundation for further study.
As an introductory text, its strengths are compactness and accessibility. Note, however, that the cases and operations may be based on a specific database system (such as MySQL or Access), so readers should adapt them appropriately to current mainstream environments. Overall, this is a competent “first database book” that helps you establish the correct conceptual framework and avoid being distracted too early by complex technologies.
Who it's for
A good fit for
- Lower-year undergraduates in computer science or information management
- Career changers entering IT who need to build database knowledge
- Professionals in non-technical roles who need to understand data storage and query logic (e.g., product managers, operations staff)
- Self-learners who need to grasp database fundamentals quickly for course projects or simple projects
Not a good fit for
- Experienced developers already proficient in SQL who seek advanced database optimization or distributed architecture
- Readers who want to delve into the internal mechanisms of a specific database system (e.g., Oracle, PostgreSQL)
Reading tips
- Read alongside practice: install a lightweight local database (such as SQLite or a learning edition of MySQL) and run the book’s SQL examples as you go
- Focus on Chapter 3 (Database Design) and Chapter 4 (SQL Queries); these two parts are central to understanding how databases work
- Supplement reading with online interactive database tutorials to deepen your understanding of query results
About the publisher
Chongqing University Press is a comprehensive university press whose publishing areas span social and cultural studies, industrial technology, finance and economics, medicine, social psychology, and theory. Judging from its catalog, the press publishes both academic works and popular science titles. Representative books include E. H. Gombrich's Shadows: The Depiction of Cast Shadows in Western Art, Magnesium-Based Hydrogen Storage Materials by Pan Fusheng et al., Research on China's Regional Spatial Development Models by Sun Jiuwen, and titles from the Gynecologic Oncology Committee of the Chinese Anti-Cancer Association, such as the Guidelines for Diagnosis and Treatment of Common Gynecologic Malignancies in China (2019) and Bipolar Disorder: What You and Your Family Need to Know. Its authors work in art history, materials science, regional economics, clinical medicine, and social research methods. Public information is limited, but its publishing profile combines academic translation, industrial technology, and practical medical guides.
Contents
- 版权信息
- 前言
- 第1章 数据库基础
- 1.1 数据库基础知识
- 1.1.1 什么是数据库
- 1.1.2 数据库和表
- 1.1.3 列和行
- 1.1.4 主键与外键
- 1.2 数据库的发展
- 1.2.1 人工管理阶段
- 1.2.2 文件系统阶段
- 1.2.3 数据库系统阶段
- 1.3 数据库管理系统和数据库系统
- 1.3.1 数据库管理系统
- 1.3.2 数据库系统
- 1.4 SQL语言
- 1.5 常用的关系型数据库管理系统
- 1.5.1 MySQL
- 1.5.2 Oracle
- 1.5.3 SQL Server
- 1.5.4 Access
- 本章小结
- 课后习题
- 第2章 MySQL简介
- 2.1 数据库管理系统简介
- 2.2 MySQL的优势
- 2.3 Windows平台下安装与配置MySQL
- 2.3.1 安装MySQL
- 2.3.2 配置Path变量
- 2.3.3 配置MySQL
- 2.3.4 重置root密码
- 2.4 启动服务并登录MySQL数据库
- 2.4.1 启动MySQL服务
- 2.4.2 登录MySQL数据库
- 2.5 MySQL常用图形化管理工具
- 本章小结
- 课后习题
- 第3章 数据库基本操作
- 3.1 创建数据库
- 3.1.1 关系数据库设计
- 3.1.2 数据库设计规范化
- 3.1.3 创建数据库
- 3.1.4 创建数据库的语法
- 3.2 管理数据库
- 3.2.1 修改数据库
- 3.2.2 显示数据库
- 3.2.3 打开数据库
- 3.3 删除数据库
- 3.4 综合案例——“图书管理系统”
- 3.4.1 案例背景
- 3.4.2 案例目的
- 3.4.3 案例分析
- 3.5 实训项目——生产管理系统
- 3.5.1 实训目的
- 3.5.2 实训内容
- 本章小结
- 课后习题
- 第4章 数据表的基本操作
- 4.1 MySQL数据类型
- 4.1.1 数值类型
- 4.1.2 日期和时间类型
- 4.1.3 字符串类型
- 4.2 创建数据表
- 4.2.1 创建数据表的语法形式
- 4.2.2 主键约束
- 4.2.3 外键约束
- 4.2.4 非空约束
- 4.2.5 唯一性约束
- 4.2.6 默认约束
- 4.2.7 自增属性
- 4.3 查看数据表结构
- 4.3.1 查看数据表基本结构
- 4.3.2 查看数据表详细结构
- 4.4 修改数据表
- 4.4.1 修改表名
- 4.4.2 修改字段数据类型
- 4.4.3 修改字段名
- 4.4.4 添加字段
- 4.4.5 删除字段
- 4.5 数据表的其他操作
- 4.5.1 修改字段排序
- 4.5.2 更改表的存储引擎
- 4.5.3 删除表的外键约束
- 4.6 删除数据表
- 4.6.1 删除没有被关联的表
- 4.6.2 删除被其他表关联的主表
- 4.7 综合案例——图书管理系统
- 4.7.1 案例背景
- 4.7.2 案例目的
- 4.7.3 案例操作过程
- 4.8 实训项目——生产管理系统
- 本章小结
- 课后习题
- 第5章 数据插入、更新与删除
- 5.1 数据插入
- 5.1.1 常用插入语句
- 5.1.2 其他插入语句
- 5.2 更新数据
- 5.2.1 更新单表数据
- 5.2.2 更新多个表的数据
- 5.3 删除数据
- 5.3.1 DELETE语句
- 5.3.2 TRUNCATE TABLE语句
- 5.3.3 DELETE与TRUNCATE的区别
- 5.4 综合案例——图书管理系统
- 5.5 实训项目——生产管理系统
- 5.5.1 实训目的
- 5.5.2 案例操作过程
- 本章小结
- 课后习题
- 第6章 数据查询
- 6.1 单表查询
- 6.1.1 SELECT语法格式
- 6.1.2 查询所有字段
- 6.1.3 查询指定字段
- 6.1.4 WHERE子句
- 6.1.5 关键字DISTINCT（查询结果不重复）
- 6.1.6 GROUP BY子句
- 6.1.7 HAVING子句
- 6.1.8 ORDER BY子句
- 6.1.9 LIMIT子句
- 6.2 集合函数
- 6.2.1 COUNT（）函数
- 6.2.2 SUM（）函数和AVG（）函数
- 6.2.3 MAX（）函数和MIN（）函数
- 6.3 多表查询
- 6.3.1 AS取别名
- 6.3.2 连接查询
- 6.3.3 子查询
- 6.3.4 UNION合并结果查询
- 6.4 综合案例——图书管理系统
- 6.5 实训项目——生产管理系统
- 6.5.1 实训目的
- 6.5.2 实训内容
- 本章小结
- 课后习题
- 第7章 视图
- 7.1 视图概述
- 7.2 创建视图
- 7.3 查看视图相关信息
- 7.3.1 通过DESCRIBE语句查看视图的结构
- 7.3.2 通过Show Table Status语句查看视图的基本信息
- 7.3.3 通过Show Create View查看视图的详细信息
- 7.4 修改视图
- 7.5 更新视图
- 7.5.1 使用INSERT语句更新视图
- 7.5.2 使用UPDATE语句更新视图
- 7.5.3 使用DELETE语句更新视图
- 7.6 删除视图
- 7.7 综合案例——图书管理系统
- 7.8 实训项目——生产管理系统
- 7.8.1 实训目的
- 7.8.2 实训内容
- 本章小结
- 课后习题
- 第8章 索引
- 8.1 索引的分类
- 8.2 创建索引
- 8.3 删除索引
- 8.4 综合案例——图书管理系统
- 8.5 实训项目——生产管理系统
- 8.5.1 实训目的
- 8.5.2 实训内容
- 本章小结
- 课后习题
- 第9章 存储过程和函数
- 9.1 存储过程
- 9.1.1 概念
- 9.1.2 存储过程的优点
- 9.1.3 创建和使用存储过程
- 9.1.4 变量
- 9.1.5 流程的控制
- 9.1.6 查看存储过程
- 9.1.7 修改存储过程
- 9.1.8 删除存储过程
- 9.2 存储函数
- 9.2.1 概念
- 9.2.2 存储过程和函数区别
- 9.2.3 创建和使用存储函数
- 9.2.4 查看存储函数
- 9.2.5 修改存储函数
- 9.2.6 删除存储函数
- 9.3 综合案例——图书管理系统
- 9.4 实训项目——生产管理系统
- 9.4.1 实训目的
- 9.4.2 实训内容
- 本章小结
- 课后习题
- 参考文献
FAQ
Is this book suitable for complete beginners?
Which database version does the book use? Is it outdated?
What level can I reach after finishing this book?
Comments
Find this book
This site is an index: you start “Search all sources” in your browser, and the entries it lists all point to third-party sites; please judge their availability yourself.
About the author
Peng Yang is an author of computer-related books about whom limited public information is available; details such as an English name, nationality, and dates of birth and death are not publicly recorded, and two of the author's works are held in the collection. Judging from the representative titles Hadoop Big Data Technology: Principles and Applications and Fundamentals of Databases, Peng Yang's writing is aimed mainly at the teaching and examination needs of computer science and related majors, covering two areas: big data processing frameworks and the basic principles of databases. The former explains the technical principles and applications of the Hadoop ecosystem, while the latter focuses on database fundamentals. Both are general computer science readings commonly used for examinations and teaching reference. The available information is not yet sufficient to outline the author's professional background or academic experience, so readers may look to the works themselves to understand the author's editorial approach; the style tends toward a systematic overview of technical concepts in service of course study, making the books suitable as introductory and exam-preparation aids.
Li Xiaoping is an author with limited publicly available information, and only two works by this author are currently known, covering computer-aided engineering and database technology respectively. One is the DEFORM-3D Plastic Forming CAE Application Tutorial, which focuses on the application of DEFORM-3D software to computer-aided engineering in plastic forming and addresses engineering practice and teaching needs as a professional software tutorial. The other is Fundamentals of Databases, a basic computer science teaching text suitable for beginners building up database concepts. Judging from the existing works, Li Xiaoping's writing tends toward practical and instructional technical content, emphasizing operating methods and basic knowledge and serving exam-oriented and comprehensive computer learning contexts. Since information such as dates of birth and death, nationality, education, and professional experience has not been publicly recorded, this introduction is based only on the works and common classifications in the database and makes no speculation about the author's personal background.
