Tables and First Queries

Relational tables

Understand rows, columns, keys, and relationships.

8 minutes - Absolute beginner

What this means

A relational table stores one kind of entity. Columns define attributes, rows hold records, and keys give records stable identity.

In beginner terms, this topic answers one practical question: "What should I write, and why does React care about it?" Do not try to memorize the syntax first. First understand the idea, then connect the syntax to that idea.

Why it matters

Clear table boundaries prevent duplicated and contradictory data.

When you build real React screens, this idea helps you decide where data should live, what the user should see, and what should happen after an interaction. That is why this lesson is part of the main path instead of being an optional detail.

Step by step

1. Notice the UI problem this topic solves. 2. Look at the smallest possible example. 3. Change one value and predict what should appear. 4. Run the example and compare the result with your prediction. 5. Use the practice task before moving on.

Small example

CREATE TABLE lessons (id INT PRIMARY KEY, title STRING, minutes INT);

Common mistake

Do not copy relational tables syntax without explaining what problem it solves and checking the result.

Practice task

Change one part of the example, predict the result, run it, and explain the result in your own words.

Remember this

A table should model one coherent kind of thing.

try.it

Examples

Try it: Relational tables

Edit this focused SQL example and run it in the browser preview.

Queries run against a temporary in-browser SQL database, never the application database.

sql

editor

preview

Preparing preview...

practice.next

Practice before moving on

check.understanding

Lesson quiz

Login to save progress

You can read lessons without an account, but progress requires login.

Login