Easier to read with cream paper, a tint, more contrast or larger text? Choose your colours and text, once, for every page.

Free module

Databases

Learn relational databases and SQL hands on: tables and keys, queries, joins, changing data, normal forms and a web API.

6 lessons330 min lessonCore computer science

The lessons

Each lesson is free to read in full. Create a free account to run its commands in a live lab and to sit its quizzes and tasks.

  1. 1 · Container lab

    Tables and keys

    I can make tables with keys in a relational database.

    Read the lesson

  2. 2 · Container lab

    Asking for the rows you need

    I can ask a database for the rows I need.

    Read the lesson

  3. 3 · Container lab

    Joining and summarising tables

    I can combine tables and summarise them.

    Read the lesson

  4. 4 · Container lab

    Changing data safely

    I can add, change and remove rows safely.

    Read the lesson

  5. 5 · Container lab

    Designing tables that avoid repetition

    I can split a flat table into a design that avoids repetition.

    Read the lesson

  6. 6 · Container lab

    Reading and writing rows over HTTP

    I can read and write rows over HTTP.

    Read the lesson

Worked in a real lab

Every lesson of this module is worked in a lab started for you alone. The labs it uses:

Teaching a class? Set this module for your students with a teacher guide, marked assignments and a lab for every student.