SQL Fundamentals · Database Basics · Lesson 1 of 17
What is a Relational Database?
Concept
What is a Relational Database?
A relational database organizes data into tables made of rows and columns, with relationships between tables linked by shared keys.
By the end of this lesson
- Explain the core idea behind What is a Relational Database?.
- Predict output before running a change.
- Test one realistic and one unusual input.
- Use the result to make the next decision.
How to study this page
- 1. Read one concept.
- 2. Change the example.
- 3. Run, compare, and explain.
- 4. Complete the challenge below.
ExampleRunnable
-- A table stores rows of structured data
-- students(id, name, age)
-- courses(id, title, level)Self-check before continuing
Without looking at the example, describe what changes when you modify one input in What is a Relational Database?. Then reopen the editor and prove your explanation with a small test.
You are ready to continue when you can predict, test, and explain the result.
Your turn
Sketch, as a comment, the columns you would need for an orders table.
Loading editor…
Console