Lesson 1 of 3 · 8 min

Tables, rows & columns

Relational databases store data in tables: rows are records, columns are fields.

A primary key uniquely identifies each row — like a student ID.

Practice

Design a table for a library: what columns would a books table need?

Optional resources

No purchase or partner signup is required to complete this course or earn quiz points.

These are official product links, not active affiliate links. Learnly does not currently earn a commission from them.

Try table designs and queries with fictional sample data.

Browser SQL playground; never paste private or personal data.