Intermediate · 4h 20m · lessons

Databases

Store, model, and query data with confidence using SQL.

Start course

What you'll learn

  • ✦Explain what a database is and when to reach for one instead of files or spreadsheets
  • ✦Model data with tables, rows, columns, appropriate data types, and primary keys
  • ✦Write SELECT queries with WHERE, ORDER BY, and LIMIT to pull exactly the rows you need
  • ✦Aggregate data with COUNT(*) and reason about how summaries work
  • ✦Connect tables with foreign keys and combine them using INNER and LEFT JOIN
  • ✦Apply basic normalization and add indexes to keep queries fast
  • ✦Change data safely with INSERT, UPDATE, DELETE, and transactions
  • ✦Summarize data with GROUP BY, handle NULL, and know when NoSQL fits

Syllabus

Module 1
Foundations Free
Module 2
Querying with SQL Locked
Module 3
Relationships & performance Locked
Module 4
Changing data Locked
Module 5
Grouping & growing Locked