0Pricing
SQL Academy · Lesson

What an RDBMS Is and Why Tables Matter

Learn what a relational database management system is, how it differs from a spreadsheet or file, and why structured tables are the foundation of every business application.

What an RDBMS Is and Why Tables Matter is a free SQL Academy lesson on CoddyKit — lesson 1 of 4. You can read the complete lesson below for free — then practise it hands-on in the browser with a built-in code editor and a 24/7 AI tutor. It is part of the SQL Academy learning path, one of 4 lessons in the course, and your progress syncs across the web and the CoddyKit app.

What Is a Database?

A database is an organised collection of data that you can read, write and query reliably from many programs at once.

  • Data is stored on disk, survives restarts
  • Many users can read and write concurrently
  • You query it with a language — for relational databases, that language is SQL

What Is a Relational Database (RDBMS)?

A relational database stores data in tables made of rows and columns.

  • Each table represents one kind of thing: users, orders, products
  • Each row is one record
  • Each column is one attribute with a fixed type

Common RDBMSs: PostgreSQL, MySQL, SQLite, SQL Server, Oracle.

A Table Looks Like a Spreadsheet — But Stricter

A table is like a spreadsheet, but:

  • Every cell in a column must match the column's declared type
  • You cannot rearrange columns by accident
  • The database enforces rules (no duplicates, no missing required fields)
  • You query with SQL, not with manual scrolling

Creating Your First Table

You create a table with CREATE TABLE. Each column gets a name and a type.

CREATE TABLE users (
  id        BIGSERIAL PRIMARY KEY,
  email     VARCHAR(255) NOT NULL UNIQUE,
  full_name VARCHAR(100),
  is_active BOOLEAN NOT NULL DEFAULT true,
  created_at TIMESTAMP NOT NULL DEFAULT NOW()
);

Inserting Rows

Once the table exists, you add rows with INSERT:

INSERT INTO users (email, full_name)
VALUES ('alice@example.com', 'Alice Adams'),
       ('bob@example.com',   'Bob Brown');

Reading Rows Back

You read data with SELECT:

SELECT id, email, full_name
FROM users
WHERE is_active = true
ORDER BY created_at DESC;

Tables Are Sets, Not Lists

An important mental model: a SQL table is an unordered set of rows.

  • Without ORDER BY, the database may return rows in any order
  • Two queries can return the same rows in different orders
  • Always specify ORDER BY if order matters

Schemas, Databases, and Tables

A single PostgreSQL server hosts many databases. Each database contains schemas (usually public), and each schema contains tables, views, functions, and types.

-- Fully qualified name
SELECT * FROM mydb.public.users;

-- Inside the database, you usually write:
SELECT * FROM users;       -- public.users
SELECT * FROM billing.invoices;

Why Tables Matter

Tables matter because they give you:

  • Structure — every row has the same shape, so analysis is reliable
  • Integrity — constraints stop bad data from being saved
  • Speed — indexes find rows in milliseconds even at billion-row scale
  • Shared truth — many apps can read and write the same tables safely

SQL Is Declarative

You describe what you want, not how to compute it. The database planner figures out the most efficient path.

-- Declarative: "give me active users from Berlin"
SELECT email FROM users
WHERE is_active = true AND city = 'Berlin';

-- The planner decides: index scan? sequential scan? hash? merge?

A Note on Standards and Dialects

Core SQL is standardised, but every database adds its own dialect.

  • PostgreSQL: BIGSERIAL, RETURNING, JSONB
  • MySQL: AUTO_INCREMENT, backticks
  • SQL Server: IDENTITY, square brackets

This course focuses on standard SQL with PostgreSQL examples.

Recap

You now understand:

  • A relational database is a set of tables
  • Each table has rows (records) and columns (attributes)
  • SQL is the declarative language you use to query and modify data
  • Tables give you structure, integrity, speed, and a shared source of truth

Quick Check

Which statement best describes a row in an SQL table?

Frequently asked questions

Is the “What an RDBMS Is and Why Tables Matter” lesson free?

Yes — the full text of “What an RDBMS Is and Why Tables Matter” is free to read here on the web, and the SQL Academy course includes 4 lessons in total. To practise it interactively (a built-in code editor and a 24/7 AI tutor) and unlock the rest of the SQL Academy course, upgrade to CoddyKit PRO.

What will I learn in “What an RDBMS Is and Why Tables Matter”?

Learn what a relational database management system is, how it differs from a spreadsheet or file, and why structured tables are the foundation of every business application. You practise SQL Academy with hands-on code you run directly in the browser, and a 24/7 AI tutor answers your questions as you work through the lesson.

Do I need any experience to start SQL Academy?

No prior experience is required. SQL Academy on CoddyKit is structured for beginners through advanced learners; this is — lesson 1 of 4, so you can start here or from the beginning and move at your own pace.

How long does the “What an RDBMS Is and Why Tables Matter” lesson take?

Most CoddyKit lessons take about 5–10 minutes. Each one is bite-sized and interactive, so you make steady progress and pick up exactly where you left off across the web and the app.

Can I write and run code in this SQL Academy lesson?

Yes. Every SQL Academy lesson includes a built-in code editor, so you write and run real code right in your browser and get instant AI feedback — no local setup required.

All lessons in this course

  1. What an RDBMS Is and Why Tables Matter
  2. Primary Keys and Uniqueness
  3. NULL: The Third Truth Value
  4. Data Types Overview: INT VARCHAR DATE BOOLEAN
← Back to SQL Academy