Course

SQL

Learn to read and change real databases in 20 lessons: SELECT, filtering, joins, grouping, indexes and transactions, ending with a small library database you design yourself.

  • 20 lessons
  • 4 modules
  • Beginner
  • 2 h 35 min
  1. Module 1

    Reading Data

    What a relational database is, SELECT, WHERE, ORDER BY and LIMIT u2014 the four clauses that answer most questions.

    5 lessons, about 37 min

    1. What a relational database does 7 min
    2. SELECT: choosing columns 7 min
    3. WHERE: filtering rows 8 min
    4. ORDER BY and LIMIT 7 min
    5. NULL and types 8 min
  2. Module 2

    Summarising

    DISTINCT, COUNT, SUM, AVG, GROUP BY and HAVING: turning rows into answers.

    5 lessons, about 37 min

    1. DISTINCT: unique values 6 min
    2. COUNT, SUM, AVG and friends 8 min
    3. GROUP BY 8 min
    4. HAVING: filtering groups 7 min
    5. Reporting patterns that hold up 8 min
  3. Module 3

    Joining and Changing Data

    INNER and LEFT JOIN, subqueries, INSERT, UPDATE, DELETE, and creating your own tables.

    5 lessons, about 40 min

    1. INNER JOIN: combining tables 8 min
    2. LEFT JOIN: keeping unmatched rows 8 min
    3. Subqueries and CTEs 8 min
    4. INSERT, UPDATE and DELETE 8 min
    5. CREATE TABLE with sensible types 8 min
  4. Module 4

    Design and Safety

    Constraints, indexes, transactions, views, and a capstone library database with real queries.

    5 lessons, about 41 min

    1. Constraints that protect the data 8 min
    2. Indexes: making lookups fast 8 min
    3. Transactions and concurrency 8 min
    4. Views: naming a query 7 min
    5. Capstone: a library database 10 min

Check what stuck

One quiz per module, with an explanation after every answer.

Other tracks

Java

23 lessons · Beginner

NEW