MySQL Visual Learner

Introduction to MySQL SQL Basics Data Types & NULLs B-Tree Indexing Execution Order JOIN Types

Join Types & Patterns Cardinality & Keys EXPLAIN Analysis WHERE vs HAVING Index Types Normalization Data Layout & Index Structure

Subqueries Query Optimization Transactions & Locking CTEs (Common Table Expressions) Window Functions InnoDB Internals

Playground Portfolio

Normalization

Learn 1NF, 2NF, 3NF and when to denormalize. See how to eliminate data redundancy.

Enter SQL Query

Try:

Enter a query above to see the visualization

MySQL Visual Learner - Learn database concepts interactively