← All tutorials
Skill Zuno · skillzunos.com · Fullstack
MySQL tutorial
Learn MySQL on Skill Zuno. This MySQL tutorial covers New, Easy, Medium, Hard, and Diff levels so you can study practical MySQL problems on skillzunos.com.
Open MySQL on Skill ZunoAlso see the MySQL interview questions.
MySQL is one of the most popular open-source relational databases and the default storage for many web applications. Its InnoDB engine provides ACID transactions, row-level locking and clustered primary keys. MySQL interviews cover SQL, indexing, EXPLAIN, transactions and isolation levels, locking, replication and performance tuning.
MySQL topics covered
- Data types, keys and constraints — Choosing column types, and enforcing integrity with primary and foreign keys.
- Joins, subqueries, GROUP BY and window functions — Combining and summarising data, and ranking rows with window functions.
- InnoDB: clustered indexes and secondary indexes — How InnoDB lays out data, and why primary key choice matters.
- Reading query plans with EXPLAIN — Understanding type, key, rows and Extra to find slow queries.
- Transactions, isolation levels and MVCC — How MySQL isolates concurrent transactions with multiversion concurrency control.
- Row locks, gap locks and deadlocks — How InnoDB locks rows, why gap locks exist, and diagnosing deadlocks.
- Replication: binary log, replicas and GTIDs — Copying data to replicas for read scaling and failover.
- Normalisation, partitioning and performance tuning — Designing tables well, splitting big tables, and tuning the buffer pool.
What you can learn
- MySQL tutorial for beginners and experienced developers
- Level-based practice: New, Easy, Medium, Hard, and Diff
- Fullstack topics alongside MySQL on skillzunos.com