MySQL Database Applications

Name: MySQL Database Applications
ISBN: 9787568950176

刘洪军 / 邵菲菲Chongqing University Press · ChinaSep 2026

3.4

Word count: 142K words
Chapters: 36
ISBN: 9787568950176

Report an error Find this book

Summary

This book consists of 7 modules, including 25 work manuals. Its main content covers obtaining and using MySQL, database design and development, data migration and organization, data querying and use, MySQL database programming, MySQL daily management, and MySQL database application development. The book is also accompanied by course teaching resources such as micro-lectures, slides, teaching examples, and exercises for readers to study online.

This book can be used as a teaching textbook for programs such as computer science, big data, and artificial intelligence in higher vocational colleges, and can also serve as a learning reference for database beginners, software developers, and those interested in MySQL database applications.

Editor's review

This book is organized in modules, with 25 work manuals under 7 modules, breaking MySQL learning into tasks that can be completed one by one, from obtaining and using databases, design and development, all the way to data migration and organization, querying and use, database programming, daily management, and application development. The advantage of this “work manual” structure is that goals are clear: readers know what they need to do in each module rather than merely reading concepts. The content is broad, covering everything from basic queries to programming and management, making it suitable as a teaching textbook for relevant higher vocational programs and convenient for self-learners to progress module by module. The accompanying micro-lectures, slides, examples, and exercises facilitate learning by doing. Readers are advised not to merely skim syntax but to complete each task in the work manuals, paying special attention to the connection between data design and querying, and to tie the modules together with a small application development task at the end.

Who it's for

A good fit for

Students in higher vocational programs such as computer science, big data, and artificial intelligence
Database beginners who need to systematically learn MySQL fundamentals and applications
Software developers who want to supplement their database operations skills
People interested in MySQL application development who want to self-study task by task

Not a good fit for

Readers with relatively deep database experience who only want to look up advanced tuning techniques
Readers who need to study other databases such as Oracle or SQL Server in depth
Readers who are completely unwilling to operate hands-on and only want to read theoretical concepts

Reading tips

Proceed in the order of the 7 modules; for each work manual, complete the work yourself first, then check the results against the examples and exercises.
When studying the querying and programming modules, prepare a small database of your own and reproduce the book's operations on your own data.
After studying data design and development, review and organize the table structures and relationships, so that you do not know only how to write statements but not how to design.
Finally, use a simple application development task to connect modules such as data migration, querying, programming, and management, and test your comprehensive application ability.

About the publisher

Chongqing University Press China · Founded in 1985

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.

版权信息
内容提要
前言
模块1 MySQL获取与使用
工作手册1.1 数据库产品选型
工作手册1.2 在Windows11系统上安装和使用MySQL 8.0
工作手册1.3 通过MySQL Workbench操作MySQL数据库
工作手册1.4 获取和使用华为云MySQL数据库
模块2 数据库设计与开发
工作手册2.1 设计关系型数据库
工作手册2.2 在MySQL中创建数据库和数据表
模块3 数据迁移与整理
工作手册3.1 向MySQL8装载数据
工作手册3.2 整理数据表中的数据记录
模块4 数据查询与使用
工作手册4.1 从数据表中查询和展示数据
工作手册4.2 从多个数据表中获取数据
工作手册4.3 统计分析数据表中的数据
工作手册4.4 使用视图间接查询和管理数据
工作手册4.5 使用索引提高查询速度
模块5 MySQL数据库编程
工作手册5.1 学习MySQL编程基础
工作手册5.2 使用存储函数查询数据
工作手册5.3 使用存储过程管理维护数据
工作手册5.4 使用触发器管理维护数据
工作手册5.5 使用事件机制执行定时任务
工作手册5.6 使用事务保障数据一致性
模块6 MySQL日常管理
工作手册6.1 MySQL用户和权限管理
工作手册6.2 MySQL数据备份与恢复
工作手册6.3 MySQL日志管理与分析
工作手册6.4 MySQL性能监控与优化
模块7 MySQL数据库应用开发
工作手册7.1 使用JDBC编程操作MySQL数据库
工作手册7.2 使用Python编程操作MySQL数据库
附录

FAQ

Can I study this book directly with zero foundation?

This book is intended for database beginners, so it can be studied with zero foundation, but it is recommended that you first understand basic database concepts such as tables, fields, and primary keys. When studying, proceed in module order, complete each work manual hands-on, and when you encounter syntax questions, use the examples and micro-lecture resources to understand them; do not just read without practicing.

How should the 25 work manuals be used?

The work manuals are the task carriers of this book. It is recommended to use each one by “clarifying the task—operating hands-on—comparing with examples—completing exercises.” Do not skip the operation and go straight to the answers; after completing it, check whether the results meet the task requirements, so as to gradually build practical database operation experience.

What accompanying resources does the book include?

According to the introduction, this book is accompanied by course teaching resources such as micro-lectures, slides, teaching examples, and exercises for online learning. When using them, first watch the micro-lectures to understand key operation points, then practice against the teaching examples, and finally use the exercises to check your mastery. The specific way to obtain the resources is subject to the actual accompanying instructions of the book.

What level can I reach after finishing the book?

This book covers content from obtaining and using databases, design and development, data migration and organization, querying, and programming to daily management and application development. After completing all the work manual exercises, you should be able to independently complete basic database design, query writing, and simple application development, and have daily management operation skills. In-depth tuning still requires additional study.

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

刘洪军 Author

Liu Hongjun: publicly available information is currently limited, and details of his life, educational background, and professional positions cannot be confirmed. According to the library's holdings, his work is MySQL Database Application, which falls under the general category of computer science. The book focuses on the practical application of MySQL and is intended for readers who need to master database operations and development skills. It suggests that the author has some experience in database technology teaching or practice, and the writing is application-oriented, emphasizing the connection between database knowledge and concrete usage scenarios. Because verifiable information is scarce, his broader body of work and academic achievements cannot yet be introduced; readers may gain a sense of his approach and technical focus in database applications through this book.

邵菲菲 Author · China

Shao Feifei is a Chinese author about whom relatively limited public information is available. Judging from the holdings in our library, her work centers on the general category of computer science, and her representative title is MySQL Database Applications. The book deals with the study and practical use of database technology, focusing on MySQL, a relational database management system, and reads as a typical computer science textbook or technical guide. It can therefore be inferred that Shao Feifei's writing leans toward practical topics such as database operations, the use of SQL, and database design, with an emphasis on systematically organizing fundamental knowledge and guiding readers step by step through hands-on skills. The book is suitable as a course text for relevant university programs and as an introductory reference for self-learners. Because verifiable details of the author's life, education, and professional experience are scarce, a fuller assessment of her academic background and overall body of work is not yet possible, and the actual influence of her work awaits reader feedback and further documentation.