232 pages · 30 days · 50–90 min/day

Learn how databases store information and how SQL lets you search, organize, and analyze that data. The course begins visually with tables, rows, columns, and relationships before introducing SQL commands.

You’ll learn SELECT, WHERE, ORDER BY, aggregate functions, GROUP BY, HAVING, JOINs, NULL, CASE, subqueries, CTEs, INSERT, UPDATE, DELETE, keys, normalization, indexes, transactions, views, and window functions.

Instead of memorizing queries, you’ll learn what each query is actually asking the database to do.

Included: 232-page PDF, database diagrams, result-table examples, practice queries, JOIN visuals, debugging exercises, quizzes, full solutions, and database-design projects.

Final project: Build a small-business database and create useful reporting queries for customers, products, and orders.

Prerequisite: None.