MySQL Chapter Index

Introduction

This index lists all 31 chapters in the Hello Code MySQL track, grouped by topic. Use it to jump to a lesson or compare coverage with frontend/gen_article_plan/mysql.md.

Prerequisites

  • None—this page is a map, not a lesson

Getting Started (01–06)

#Chapter
01What Is MySQL
02Installing MySQL on Windows
03Installing MySQL on macOS
04Installing MySQL on Linux
05Installing MySQL with Docker
06MySQL Configuration and Client Tools

Schema and CRUD (07–11)

#Chapter
07Database Management Basics
08Creating Tables and Data Types
09Inserting Data
10SELECT Queries Basics
11Updating and Deleting Data

Advanced Queries (12–14)

#Chapter
12Joins and Multi-Table Queries
13Subqueries
14Group By and Aggregates

Integrity and Performance (15–16)

#Chapter
15Constraints and Keys
16Indexes and EXPLAIN

Transactions and Programs (17–21)

#Chapter
17Transactions Basics
18Isolation Levels and Locks
19Views
20Stored Procedures and Functions
21Triggers

Operations and Security (22–24)

#Chapter
22Users and Permissions
23Backup and Restore
24Query Performance Basics

MySQL 8 Features (25–26)

#Chapter
25JSON Data Type
26Window Functions

Projects (27–28)

#Chapter
27Project: Blog Database Design
28Project: E-Commerce Orders

Troubleshooting and Resources (29–31)

#Chapter
29MySQL Troubleshooting
30MySQL Resources and Book Recommendations
31MySQL Chapter Index (this page)
TrackWhy
JDBCJava database access
Spring BootWeb apps with MySQL
LinuxServer deployment
GitSchema in version control
MongoDBDocument modeling, $lookup, PyMongo
RedisCaching and session layers
VueSPA UI for CRUD APIs backed by MySQL (24, 25)

FAQ

Where is the planning document?

Chinese outline: frontend/gen_article_plan/mysql.md.

Partitioning and replication?

Covered at concept level in Query Performance Basics and resources chapter; see MySQL manual for depth.

Suggested reading order?

Follow chapter numbers 01→31, or 01→11 for SQL essentials then 27→28 projects.

JDBC install chapters duplicate?

JDBC track focuses on driver setup; this track focuses on SQL and DBA skills.

Report a typo?

Improve docs via Git fork workflow.

/category-logos/mysql.png in category_meta_info.json.