MySQL: From Beginner to Mastery

Name: MySQL: From Beginner to Mastery
ISBN: 9787302457992

Mingri Technology (Jilin Province Mingri Technology Co., Ltd.)Tsinghua University Press2017

No rating yet

Chapters: 27
Series: Software Development Video Lecture Hall
ISBN: 9787302457992

Report an error Find this book

Summary

MySQL: From Beginner to Mastery is a volume in the "Software Development Video Lecture Hall" series published by Tsinghua University Press, compiled by the Mingri Technology team, which has long been engaged in software development and education and training. Starting from absolute beginners, the book unfolds in four levels—basic knowledge, core techniques, advanced applications, and project practice—and is divided into 4 parts and 23 chapters: it begins with database systems, data models, and relational database design; then moves on to MySQL installation and configuration, graphical management tools, database and table operations, storage engines and data types, insert/update/delete/query operations, data queries, and common functions; it then goes deeper into indexes, views, data integrity constraints, stored procedures and stored functions, triggers, transactions and events, backup and recovery, performance optimization, privilege management, and security control; finally, through cases such as managing MySQL with PHP, building an online community with Apache+PHP+MySQL, and constructing an online mall with Struts 2+Spring+Hibernate+MySQL, it links scattered knowledge points into a complete development workflow. Throughout the book, knowledge explanations advance in step with concrete examples, and the program code includes detailed comments, making it easy to reproduce on a computer while reading. It is suitable as the first book for programming beginners teaching themselves MySQL, as supplementary reading for students following a course, or as a reference manual for developers in daily work.

Editor's review

很多数据库入门书的问题在于“讲得全、用不上”：概念罗列一大堆，真到动手建表、写查询时还是无从下手。这本书的编排方式正好相反，每一章的知识点后面都跟着可直接运行的示例，代码带注释，读者可以在自己的机器上照着敲、跟着改，读完一章就有一章的实际产出。结构上采用“基础知识→核心技术→高级应用→项目实战”的四段递进：前面几章解决装环境、认界面、建库建表这些最容易被劝退的门槛；中间把索引、视图、存储过程、触发器、事务讲清楚，这是面试和实际开发里真正分高下的地方；最后用网上社区、网络商城这类完整案例，把PHP与MySQL、Java框架与MySQL的配合方式演示一遍，让读者知道学到的SQL在真实项目里长什么样。本书属于清华社“软件开发视频大讲堂”丛书，该丛书自2008年起持续修订、销量长期居同类前列，被不少高校选作教学参考。对于想要一本“能从第一页读到最后一页”的MySQL入门书的人来说，它足够系统，也足够实用。

Who it's for

A good fit for

完全没有数据库基础、想系统自学MySQL的编程初学者
计算机、软件工程等专业学生，配合数据库课程做同步练习
需要独立完成增删改查、建表与简单优化的初级开发人员
希望把PHP或Java框架与MySQL结合起来做项目的自学者

Not a good fit for

已有多年MySQL运维经验、想深入研究InnoDB内核与源码的资深DBA
只想查命令速查表、不需要系统学习的读者
以PostgreSQL、Oracle或SQL Server为主要技术栈的学习者

Reading tips

务必边读边动手：先在本机装好MySQL，每章的示例都亲手运行一遍，比只读代码有效得多。
第1篇可以快速通读建立框架，第2篇起放慢速度，重点吃透查询、索引、事务三部分。
遇到存储过程、触发器、性能优化等章节，建议先自己写一版，再对照书中写法找差距。
项目实战篇不要跳过，可以挑一个案例跟着做完整流程，把前面零散的知识串起来。

About the publisher

Tsinghua University Press China · Founded in 1980

Founded in 1980, Tsinghua University Press has 57 titles in our collection, covering popular science, medicine, health, law, philosophy and social sciences. Representative works include medical popular-science books such as Cancer Truth: Doctors Are Reading It Too and New Knowledge on Cancer by Bo Luo (Li Zhizhong), legal titles such as Sunshine Is the Best Preservative: Express Delivery of Major Global Anti-Corruption Cases, and works like Qi Ge's A Brief History of Philosophy with Big Ideas and Liu Yunhao's From the Internet to a New Industrial Revolution. Its authors include science writers, medical researchers, the Renmin University of China anti-corruption master's class and university scholars, reflecting a publishing profile that balances academic seriousness with accessible reading. As public information is limited, this profile is based only on the titles in our collection.

Part 1 Basic Knowledge
Chapter 1 Database Fundamentals
Chapter 2 Getting to Know MySQL
Chapter 3 Using MySQL Graphical Management Tools
Chapter 4 Database Operations
Chapter 5 Storage Engines and Data Types
Chapter 6 Operating Data Tables
Part 2 Core Techniques
Chapter 7 MySQL Basics
Chapter 8 Inserting, Deleting, and Updating Table Data
Chapter 9 Data Queries
Chapter 10 Common Functions
Chapter 11 Indexes
Chapter 12 Views
Chapter 13 Data Integrity Constraints
Part 3 Advanced Applications
Chapter 14 Stored Procedures and Stored Functions
Chapter 15 Triggers
Chapter 16 Applying Transactions
Chapter 17 Events
Chapter 18 Backup and Recovery
Chapter 19 MySQL Performance Optimization
Chapter 20 Privilege Management and Security Control
Part 4 Project Practice
Chapter 21 Managing Data in MySQL Databases with PHP
Chapter 22 Building an Online Community with Apache+PHP+MySQL
Chapter 23 Building an Online Mall with Struts 2+Spring+Hibernate+MySQL

FAQ

这本书适合零基础的人看吗？

适合。本书从数据库基本概念和MySQL安装配置讲起，不预设读者有编程经验；但建议先了解一点计算机基础操作，遇到PHP、Java框架部分时不必强求一次看懂，可先重点掌握SQL部分。

这本书讲的是哪个MySQL版本？

2017年首版以当时主流的MySQL版本为基础讲解，主要内容（SQL语法、建表、查询、索引、事务等）在后来的8.0版本中依然通用；若使用MySQL 8.0，安装配置章节的操作界面可能与书中略有差异，可参照官方文档对应操作。

读完这本书能达到什么水平？

能够独立完成数据库安装配置、库表设计、增删改查、多表查询、索引与事务的基本运用，并理解备份恢复与权限管理流程，具备初级数据库开发与日常维护的能力；更深入的性能调优与内核原理仍需后续专门学习。

书中的代码和案例能直接运行吗？

书中示例基于标准MySQL语法编写并附有注释，一般可直接在本地MySQL中运行；项目案例还涉及PHP环境或Java框架，需要按书中步骤搭建相应运行环境，个别依赖版本可能需要自行调整。

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

Mingri Technology (Jilin Province Mingri Technology Co., Ltd.) Author

Mingri Technology, whose full name is Jilin Province Mingri Technology Co., Ltd., is a high-tech company specializing in software development, education and training, and the integration of software development educational resources, and it organizes the compilation of computer programming textbooks. Its works are aimed mainly at programming beginners and focus on learning languages such as Python, Java, C#, and SQL, as well as GUI design and web front-end development; its common categories are programming design, computer fundamentals, and software learning. Representative works include the upgraded editions of Python GUI Design, SQL, and Java in the “Zero Foundation Learning” series, along with study notes on HTML+CSS+JavaScript and a complete self-study course on C#. The company has developed textbook series such as “From Beginner to Master” and “Software Development Video Lecture Hall”; related textbooks have received industry and university press awards, and several titles have long ranked among the top sellers in their categories. Public information is limited; the author name is an institutional byline, and the focus is on the compilation and publication of computer programming educational materials.