MySQL Fundamentals

Databases, Tables, and SQL

A database is just a very organized set of spreadsheets, and SQL is the language you use to ask it questions and give it instructions.

Creating Tables & Choosing Data Types

Before a table can hold any data, CREATE TABLE has to define its columns up front — including what TYPE of value each column is allowed to hold.

Inserting & Querying Data

INSERT is how you add new rows to a table, and SELECT is how you read them back — with WHERE to narrow down which rows you want, and ORDER BY to put them in a sensible order.

Updating & Deleting Data

UPDATE changes existing rows and DELETE removes them entirely — both are permanent the instant they run, and both are genuinely dangerous without a WHERE clause.

Relating Tables with JOIN

Real-world data almost never fits in one giant table — JOIN is how you pull matching rows from two separate, related tables back together into a single result.

Aggregate Functions & GROUP BY

COUNT, SUM, AVG and friends squash many rows down into a single summary number — GROUP BY simply runs that same summary separately for each distinct category instead of for the whole table at once.

Indexes and Why They Matter

An index lets MySQL find rows without scanning the entire table one row at a time — the same trick as a book's index letting you jump straight to a page instead of reading it cover to cover.

JOIN Types in Depth: INNER, LEFT, and RIGHT

The earlier JOIN lesson showed matching rows from two tables — but what happens to rows that DON'T have a match on the other side depends entirely on which type of JOIN you choose.

Transactions: COMMIT and ROLLBACK

A transaction groups several SQL statements into one all-or-nothing unit — either every single one of them succeeds together, or none of them take effect at all, which matters enormously the moment money or related records are involved.

Views: Saving a Query as a Virtual Table

A VIEW lets you save a complicated SELECT under a simple name and query it as though it were an ordinary table — the query itself only has to be written once, correctly, and then reused everywhere.

Database Normalization Basics: 1NF, 2NF, 3NF

Normalization is a set of practical guidelines for splitting data into well-organized tables so nothing gets duplicated and nothing gets stuck in an inconsistent state — 1NF, 2NF and 3NF are just three checkpoints along that path, each building on the one before.