Before you learn SQL, you need to understand how data is stored in a database.

Many beginners think a database is one big file where everything is placed together. But that is not how most databases work.

In most SQL databases, data is organized in a clear structure using tables, rows, and columns.

Once you understand this structure, SQL becomes much easier.

In this article, we will explain how data is stored in a database.

What Is Data in a Database?

Data is information.

It can be anything that a system needs to remember.

For example:

• Customer names
• Phone numbers
• Email addresses
• Product prices
• Order dates
• Payment amounts
• Student marks
• Employee salaries
• Stock quantities

A database stores this information in an organized way so that it can be found, updated, deleted, and analyzed later.

The Basic Structure of a Database

Most beginner SQL learners start with a relational database.

A relational database stores data in tables.

A table is like a neatly arranged list.

It has:

• Columns
• Rows
• Records
• Fields

The easiest way to understand this is to compare it with Excel.

A database is like an Excel workbook.

A table is like a worksheet.

A column is like a vertical category.

A row is like one full record.

A cell is like one small piece of data.

What Is a Table?

A table is where related data is stored.

For example, a business may have a table called Customers.

That table stores customer information.

Example:

customer_id	name	phone	city
1	Mary	0712345678	Nairobi
2	John	0798765432	Mombasa
3	Amina	0722000111	Kisumu

This table stores details about customers.

Each customer has an ID, name, phone number, and city.

What Is a Column?

A column stores one type of information.

In the customers table, these are columns:

• customer_id
• name
• phone
• city
• Each column has a purpose.

The name column stores names.

The phone column stores phone numbers.

The city column stores locations.

The customer_id column stores a unique number for each customer.

Columns help keep data organized.

Without columns, the database would not know what each piece of information means.

What Is a Row?

A row stores one complete record.

In the customers table, this is one row:

customer_id	name	phone	city
1	Mary	0712345678	Nairobi

This row contains all the details for one customer.

Another row contains details for another customer.

So, if a table has 100 customers, it usually has 100 rows.

What Is a Field?

A field is one single piece of data inside a row.

For example, in this row:

customer_id	name	phone	city
1	Mary	0712345678	Nairobi

• The value Mary is one field.
• The value Nairobi is another field.
• The phone number is another field.

A field is like one cell in Excel.

What Is a Record?

A record is a complete set of information about one item, person, or event.

In many cases, a record is the same as a row.

For example, this is one customer record:

• Customer ID: 1
• Name: Mary
• Phone: 0712345678
• City: Nairobi

All these pieces of information together describe one customer.

How Tables Store Different Types of Data

A database usually has many tables.

Each table stores a different type of data.

For example, a small shop database may have these tables:

• Customers
• Products
• Sales
• Suppliers
• Payments
• Employees

Each table has its own columns.

Example 1: Customers Table

customer_id	name	phone	city
1	Mary	0712345678	Nairobi
2	John	0798765432	Mombasa

This table stores customer details.

Example 2: Products Table

product_id	product_name	price	quantity
1	Running Shoes	3500	10
2	Leather Shoes	5000	5
3	Sandals	1200	20

This table stores product details.

Example 3: Sales Table

sale_id	customer_id	product_id	quantity_sold	sale_date
1	1	2	1	2026-06-12
2	2	3	2	2026-06-12

This table stores sales details.

Notice something important.

The sales table does not store the full customer name or full product name.

Instead, it stores:

• customer_id
• product_id

These IDs connect the sale to the customer and product.

This is one of the most important ideas in databases.

Why Databases Use IDs

Databases often use IDs to identify records.

For example:

• customer_id
• product_id
• sale_id
• order_id
• employee_id

An ID helps the database know exactly which record you are talking about.

Two customers can have the same name.

For example, you may have two customers called John.

But they should not have the same customer ID.

Example:

customer_id	name	city
1	John	Nairobi
2	John	Mombasa

Both customers are called John, but their IDs are different.

This prevents confusion.

What Is a Primary Key?

A primary key is a column that uniquely identifies each row in a table.

For example, in a customers table, the primary key may be:

customer_id

In a products table, the primary key may be:

product_id

In a sales table, the primary key may be:

sale_id

A primary key should be unique.

This means no two records should have the same primary key.

Example:

customer_id	name	city
1	Mary	Nairobi
2	John	Mombasa
3	Amina	Kisumu

Here, each customer has a different customer_id.

That customer_id is the primary key.

What Is a Foreign Key?

A foreign key is a column that connects one table to another table.

Example:

In the sales table, customer_id can connect a sale to a customer.

sale_id	customer_id	product_id	quantity_sold
1	1	2	1

Here, customer_id is used to find the customer in the customers table.

If customer_id is 1, the database can check the customers table and find Mary.

This means:

Mary bought product number 2.

Foreign keys help connect related data.

How Tables Are Connected

Tables are connected using IDs.

Let us use this simple example.

Customers Table

customer_id	name
1	Mary
2	John

Products Table

product_id	product_name
1	Running Shoes
2	Leather Shoes

Sales Table

sale_id	customer_id	product_id
1	1	2

The sales table says:

• customer_id = 1
• product_id = 2

When we check the other tables:

• customer_id 1 is Mary
• product_id 2 is Leather Shoes

So the sale means:

Mary bought Leather Shoes.

This is how databases connect information without repeating everything.

Why Databases Avoid Repeating Data

One major reason databases use many tables is to avoid repeating the same information again and again.

Imagine a customer buys 20 products.

If we stored the customer’s name, phone number, and city inside every sale, the same data would be repeated many times.

That can cause problems.

For example, if Mary changes her phone number, you would need to update it in many places.

But with a good database design, Mary’s phone number is stored once in the customers table.

The sales table only stores her customer_id.

This makes the database cleaner, safer, and easier to update.

What Are Data Types?

Every column in a database has a data type.

A data type tells the database what kind of value can be stored in that column.

Common data types include:

• Text
• Number
• Date
• Decimal
• Boolean

Examples of Data Types

Column	Example Value	Data Type
name	Mary	Text
price	3500	Number
sale_date	2026-06-12	Date
amount	2500.50	Decimal
is_active	Yes/No	Boolean

Data types help the database store information correctly.

For example, a price should be stored as a number, not as random text.

A date should be stored as a date, not as a sentence.

Why Data Types Matter

Data types are important because they help the database understand the data.

For example, if price is stored as a number, you can calculate totals.

SELECT price * quantity AS total_value
FROM products;

But if price is stored as text, calculations may not work properly.

Good data types help with:

• Accuracy
• Calculations
• Sorting
• Filtering
• Storage
• Performance

Database Storage vs Database Structure

There is one more thing to understand.

When someone asks how data is stored in a database, there are two possible meanings.

The first meaning is how data is logically organized.

This means tables, rows, columns, records, primary keys, and foreign keys.

The second meaning is how data is physically stored by the database system.

This means how the database engine saves the data on a computer disk or server.

For beginners, the most important thing is the logical structure.

That is what you need to understand first before learning SQL.

Where Is the Database Stored?

A database can be stored on:

• Your computer
• A company server
• A cloud server
• A web hosting account
• A mobile device

For example:

• A small SQLite database can be stored as a file on your computer or phone.
• A MySQL database may be stored on a web server.
• A PostgreSQL database may be stored in the cloud.
• A SQL Server database may be stored on a company server.

Even though the storage location can differ, the data is still organized using database structures like tables, rows, and columns.

Simple Database Example for Beginners

Let us create a simple mental picture.

Imagine a school database.

It may have these tables:

• Students
• Teachers
• Subjects
• Classes
• Marks

Students Table

student_id	student_name	class
1	Jane	Form 1
2	Peter	Form 2

Subjects Table

subject_id	subject_name
1	Mathematics
2	English

Marks Table

mark_id	student_id	subject_id	score
1	1	1	85
2	1	2	78

The marks table connects students and subjects.

It says:

Student 1 scored 85 in subject 1.

When we check the other tables:

Student 1 is Jane.

Subject 1 is Mathematics.

So the full meaning is:

Jane scored 85 in Mathematics.

This is how data can be stored separately but still connected.

Why This Structure Is Powerful

This structure is powerful because it allows the database to answer many questions.

For example:

• Which students are in Form 1?
• Which product has the lowest stock?
• Which customer bought the most items?
• How many sales happened today?
• Which employee handled the most orders?
• What was the total revenue this month?
• Which subjects did Jane take?

SQL helps you ask these questions and get answers from the stored data.

Beginner Mistakes to Avoid

When learning how data is stored, beginners should avoid these mistakes.

1. Putting Everything in One Table

Do not store all information in one huge table.

For example, do not put customers, products, and sales all in one table.

This makes the database messy.

2. Repeating the Same Data Too Much

Avoid storing the same customer name, phone number, or product details again and again.

Use IDs and connected tables instead.

3. Forgetting Primary Keys

Every important table should have a unique ID.

This makes each record easy to identify.

4. Using Wrong Data Types

Do not store prices as text.

Do not store dates as random words.

Use proper data types.

5. Deleting or Updating Without WHERE

When using SQL, be careful with UPDATE and DELETE.

Always use WHERE when targeting specific records.

Key Takeaways

• Data is stored in a database in an organized way.
• Most SQL databases store data in tables.
• Tables have rows and columns.
• A row is one complete record.
• A column is one type of information.
• A field is one single value.
• Primary keys identify records.
• Foreign keys connect tables.
• Data types define what kind of data a column can store.
• SQL is used to read, add, update, and delete stored data.