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

Tables, keys, SQL queries, joins and designing a database without repeated data, worked in a MySQL lab.

6 lessons280 min lesson

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, records and primary keys

    I can design a table with a primary key.

    Read the lesson

  2. 2 · Container lab

    Finding the records you need (WHERE)

    I can find the records I need with a query.

    Read the lesson

  3. 3 · Container lab

    Linking two tables together (JOIN)

    I can join two tables to answer one question.

    Read the lesson

  4. 4 · Container lab

    Counting and totalling data (GROUP BY)

    I can summarise data with COUNT, SUM and GROUP BY.

    Read the lesson

  5. 5 · Container lab

    Removing repeated data (normalisation)

    I can remove repeated data from a table design.

    Read the lesson

  6. 6 · Container lab

    Changing data without losing it

    I can change data without losing any.

    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.