Step 1 of 9
A table: rows and columns
Data in a database lives in tables. A table looks like a spreadsheet:
- each row is one thing — here, one song;
- each column is one fact about every thing — its title, its year, its plays.
Try it: tap a few cells, then press Run. SELECT * FROM songs; is your first SQL query: "show everything in the songs table".
The chips under the editor show the order SQL works through a query. This query lights up two of them; each step of the lesson adds one more.