Appendix B: Resources and Further Reading

September 28, 2025 ยท View on GitHub

Official Documentation

MySQL Reference Manual

  • URL: dev.mysql.com/doc
  • Description: Complete official documentation
  • Best For: Detailed syntax, features, configuration

MySQL Developer Zone

  • URL: dev.mysql.com
  • Description: Downloads, articles, community resources
  • Best For: Software downloads, release notes

Books

Beginner

  • Learning SQL by Alan Beaulieu

    • Comprehensive SQL introduction
    • Database-agnostic concepts
  • MySQL Crash Course by Rick Silva

    • Quick practical introduction
    • Hands-on examples

Intermediate

  • High Performance MySQL by Baron Schwartz et al.

    • Performance optimization
    • Scaling strategies
    • Real-world case studies
  • MySQL Cookbook by Paul DuBois

    • Problem-solution format
    • Practical recipes

Advanced

Online Courses

Free Courses

  • Udemy: Various MySQL courses
  • Coursera: Database specializations
  • LinkedIn Learning: Professional development
  • Pluralsight: Technology training

YouTube Channels

  • MySQL (Official channel)
  • Percona Database Performance
  • PlanetScale
  • Database Star
  • Programming with Mosh

Blogs and Websites

Technical Blogs

Community Sites

Tools and Software

GUI Tools

  • MySQL Workbench - Official GUI
  • DBeaver - Universal database tool
  • TablePlus - Modern native app
  • phpMyAdmin - Web-based admin
  • HeidiSQL - Windows-focused

Command Line Tools

  • mycli - Enhanced MySQL client
  • Percona Toolkit - DBA tools
  • MySQL Shell - Advanced shell

Monitoring

  • Percona Monitoring and Management
  • Prometheus + Grafana
  • Datadog
  • New Relic

Practice Platforms

Online Playgrounds

Sample Databases

  • Sakila - DVD rental store
  • World - Countries and cities
  • Employees - Large dataset
  • Northwind - Classic trading company

Download from: dev.mysql.com/doc/index-other.html

Conferences and Events

  • Oracle MySQL Conference
  • Percona Live
  • FOSDEM MySQL DevRoom
  • Local MySQL User Groups

Certifications

Oracle MySQL Certifications

  • MySQL Database Administrator
  • MySQL Developer
  • MySQL Cluster Administrator

Info: education.oracle.com

Community and Support

Forums

IRC and Chat

  • Libera.Chat: #mysql
  • MySQL Community Slack
  • Discord servers: Various database communities

Mailing Lists

Performance Resources

Tools

  • MySQLTuner - Configuration recommendations
  • pt-query-digest - Query analysis
  • PMM - Complete monitoring solution

Reading

  • Use The Index, Luke - SQL indexing guide
  • MySQL Performance Blog - Percona's blog
  • High Performance MySQL - The definitive book

Security Resources

Guides

  • MySQL Security Guide (Official)
  • CIS MySQL Benchmark
  • OWASP Database Security Cheat Sheet

Tools

  • MySQL Enterprise Security
  • Vault - Secret management
  • SSL/TLS Configuration guides

Cloud Resources

AWS

  • RDS for MySQL Documentation
  • Aurora MySQL
  • Database Migration Service

Google Cloud

  • Cloud SQL for MySQL
  • Database Migration Service

Azure

  • Azure Database for MySQL
  • Azure Database Migration Service

Contributing to MySQL

Open Source

Community Contributions

  • Write blog posts
  • Answer questions on forums
  • Create tools and libraries
  • Speak at user groups

Staying Updated

News Sources

  • MySQL Release Notes
  • Planet MySQL - Blog aggregator
  • DB Weekly Newsletter
  • MySQL Newsletter

Social Media

  • Twitter: @MySQL, @Percona, @PlanetScale
  • LinkedIn: MySQL groups
  • YouTube: Subscribe to database channels

Quick Reference Cards

  • MySQL Cheat Sheet - Common commands
  • SQL Quick Reference - Syntax guide
  • Performance Tuning Checklist
  • Security Hardening Guide

Many available at: devhints.io/mysql

Final Thoughts

The MySQL ecosystem is vast and constantly evolving. This list provides starting points for continued learning. Remember:

  1. Practice regularly - Set up test databases
  2. Join the community - Learn from others
  3. Stay curious - Explore new features
  4. Share knowledge - Teach what you learn
  5. Keep learning - Database technology evolves

The journey to MySQL mastery is ongoing. Each project brings new challenges and opportunities to deepen your understanding.

Good luck with your MySQL journey!


Thank you for reading "MySQL and You"!