Skip to content

Tables, rows and columns

SQL · Free lesson · No account needed

Step 1 of 9 · Start here

Tables, rows and columns

Start here

A database keeps its data in tables. Each table holds one kind of thing: books, customers or orders.

  • A column is one detail, such as title or price. Every column has a type, such as text or number.
  • A row is one item: one book, with a value for every column.
  • A primary key is a column whose value is different in every row, so each row can be found exactly.

You’re trying a free lesson. Your progress saves on this device. Create a free account to keep it everywhere and ask the AI tutor.