MySQL Resources and Book Recommendations
Introduction
You have installed MySQL, written SQL from CRUD through transactions, indexed queries, and built blog and shop schemas. Keep growing by running real apps against your databases and using official references when behavior surprises you. This chapter curates documentation, books, and links to other Hello Code tracks.
Prerequisites
- Progress through this track (or equivalent SQL experience)
- At least one project chapter attempted (recommended)
How to Keep Learning
- Point a small Spring Boot or JDBC app at your schema
- Break something safely—wrong charset, missing index, deadlock demo
- Fix with EXPLAIN, slow log, and Troubleshooting
- Automate backups before schema changes
Reading without executing leaves gaps in transactions and locking intuition.
Official References
| Resource | Best for |
|---|---|
| MySQL 8.0 Reference Manual | Authoritative syntax and server vars |
| MySQL Tutorial | Structured reread |
| MySQL Shell | Modern CLI and JS/Python scripting |
| MariaDB Knowledge Base | If using MariaDB fork |
Recommended Books
High Performance MySQL (Silva, Chime, et al.)
- Indexing, replication, schema design at scale
- Best after this track when running production workloads
MySQL Crash Course (Ben Forta)
- Short, example-driven SQL primer
- Good companion for quick pattern lookup
Learning MySQL (Tahaghoghi, DuBois)
- Broader beginner-to-intermediate coverage
- Useful if you want another narrative on fundamentals
Pick one book and apply it to shop or blog_prod—not three at once.
Pair With Hello Code Tracks
| Track | Connection |
|---|---|
| JDBC | Connect Java to MySQL |
| Spring Boot | JPA, connection pools, migrations |
| Linux | Server install, systemd, Docker |
| Git | Version SQL migrations |
| Nginx | App + DB deploy topology |
| MongoDB | Document data alongside MySQL |
| Redis | Cache-aside in front of MySQL reads |
Advanced Topics (Next Steps)
| Topic | Where to go |
|---|---|
| Partitioning | MySQL manual Partitioning chapter |
| Replication / HA | Manual Replication, managed cloud RDS |
| MySQL HeatWave / cloud | Vendor docs when you outgrow one VPS |
| Migration tools | Flyway, Liquibase with Spring |
FAQ
MySQL vs PostgreSQL next?
PostgreSQL excellent for advanced SQL—MySQL skills transfer; syntax differs on JSON, window edge cases.
Certification?
Oracle MySQL certification optional—projects prove more for juniors.
ORM without SQL?
Learn SQL first—ORM generates SQL you must debug.
Stack Overflow?
Search exact error code ERROR 1062 with MySQL version.
Stay on 8.0 LTS?
Follow vendor support lifecycle; upgrade minors regularly.
Community?
MySQL forums, DBAs on Reddit, conference talks on indexing war stories.