A relational database stores data in tables with rows and columns, and relates tables using keys. SQL is the language used to define, query, and manage that data. MySQL is a popular relational database system used in web apps, SaaS products, and internal tools.
Module 3 — Database Design, Integrity, and Transactions
Normalization reduces duplication and prevents update anomalies. You’ll learn how to split data into well-structured tables while still keeping querying practical.
Module 4 — Performance, Administration, and Advanced Patterns
Indexes speed up reads by allowing MySQL to find rows without scanning entire tables. You’ll learn the basics of B-tree indexes, what to index, and common mistakes (like indexing everything)
