Beginner

Lessons at Beginner level, from every track. Each one stands alone, so you can read them out of order.

All courses

  1. Views: naming a query SQL 7 min
  2. Capstone: a library database SQL 10 min
  3. INSERT, UPDATE and DELETE SQL 8 min
  4. CREATE TABLE with sensible types SQL 8 min
  5. Constraints that protect the data SQL 8 min
  6. Indexes: making lookups fast SQL 8 min
  7. Transactions and concurrency SQL 8 min
  8. LEFT JOIN: keeping unmatched rows SQL 8 min
  9. Subqueries and CTEs SQL 8 min
  10. ORDER BY and LIMIT SQL 7 min