← 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
08 Topic Glossary
| ENGLISH TERM | 中文 | SIMPLE ENGLISH | 中文小白理解 |
| Database | 数据库 | A system used to store and organize application data. | 用来保存和组织应用数据的系统。 |
| Data | 数据 | Information stored or processed by software. | 软件保存或处理的信息。 |
| Table | 表 | A structure that stores one type of data in rows and columns. | 数据库中按行和列保存某一类数据的结构。 |
| Row | 行 | One complete record in a database table. | 数据表中的一条完整记录。 |
| Column | 列 | One type of information stored in a table. | 数据表中保存某一类信息的字段。 |
| Record | 记录 | A collection of related data about one item. | 描述一个对象的一组完整数据。 |
| Query | 查询 | A request to read or change database data. | 向数据库发出的查询或数据操作指令。 |
| SQL | 结构化查询语言 | A language used to work with relational databases. | 用来查询和修改关系型数据库数据的语言。 |
| Read | 读取 | Getting existing data from a database. | 从数据库中获取已有数据。 |
| Write | 写入 | Saving or changing data in a database. | 向数据库保存或修改数据。 |
| Transaction | 事务 | A group of database operations treated as one unit. | 作为一个整体执行的一组数据库操作。 |
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