← Software Knowledge
MODULE 05 · DATABASE & SQL

Database

A structured place where an application stores, organizes, updates, and retrieves persistent data.

01 What is it?

A database is a structured place where an application stores, organizes, updates, and retrieves persistent data.

It keeps information available after the original request or session has finished.

Simple Definition: A database is where software keeps data it needs to remember.

02 Think of it like...

Think of a database as an organized storage room.

Different types of information have clear places, so software can find and change the right item.

Database
│
├─ Users├─ Orders├─ Products├─ Payments└─ Inventory

03 What does it do?

A database allows software to:

Store Data
Read Data
Update Data
Delete Data
Search Data

04 Where is it used?

Databases are used in almost every application that needs to remember information.

Users
Orders
Products
Payments
Settings
Inventory
Reports

05 Example

Saving an Order

User creates an order
Backend processes the request
Database saves the order
Order can be retrieved later

The database keeps the order after the original request is finished.

06 How it connects

Frontend
API
Backend
Business Logic
SQL / Query
Database
Data
Response

The backend uses the database to store and retrieve application data.

07 Do Not Confuse

Database

Stores and manages data.

SQL

A language used to work with relational database data.

Database = Where the data lives·SQL = How you work with the data

09 What to Remember

A database stores application data persistently.

Software can read, add, change, and remove data from a database.

SQL is commonly used to work with relational databases.

Backend→Database→Data
↑