What's Next?

What's Next

You have completed the MySQL course. Here are natural next steps:

  • PostgreSQL — MySQL's most capable open-source competitor. Adds native JSON (JSONB), better window functions, full-text search, and stricter SQL standards compliance.
  • SQLite — The world's most deployed database. Zero configuration, a single file, and perfect for local tools, mobile apps, and testing.
  • Database design — Study normalization (1NF, 2NF, 3NF, BCNF), ER diagrams, and indexing strategies. The schema design behind an application determines its performance for years.
  • Query optimization — Learn how MySQL's query planner works. Use EXPLAIN to see execution plans, add indexes, and avoid full table scans.
  • Transactions — MySQL supports ACID transactions with BEGIN, COMMIT, and ROLLBACK. Understand isolation levels (READ COMMITTED, REPEATABLE READ, SERIALIZABLE).
  • Replication — MySQL's primary-replica replication scales reads horizontally across many servers.

Resources

  • MySQL 8.0 Reference Manual — The complete official documentation.
  • Use The Index, Luke — An exceptional free guide to SQL indexing and performance.
  • Learning MySQL by Dyer, Beaulieu & Pachev — Practical O'Reilly introduction.
  • High Performance MySQL by Schwartz, Zaitsev & Tkachenko — The definitive guide to MySQL at scale.
← Previous