Guided Notes
Introduction to MySQL
What makes MySQL distinct, and connecting to a server.
MySQL is a relational database management system — it stores data in tables and speaks standard SQL, with a few of its own extensions and conventions layered on top.
A MySQL server can host multiple databases, each with its own set of tables. You connect with a client (command line, or a GUI like MySQL Workbench) and select a database with `USE database_name;` before querying.
MySQL is the database behind an enormous share of the web (it powers WordPress, for instance) because it's free, fast for typical web workloads, and has a huge ecosystem of tooling.