Introduction to Database

A Database is an organized system for storing, managing, and retrieving data. Without a database, our application would forget all its data every time it is restarted.

RDBMS (Relational Database)

The most popular type of database is the Relational Database (such as PostgreSQL, MySQL, SQL Server). Data is stored in the form of Tables (rows and columns), similar to Excel but much more powerful.

RDBMS Illustration

Key Concepts

Table: Where data is stored (e.g., users table).

Row (Record): A single specific piece of data (e.g., a user named "Raffi").

Column (Field): A data attribute (e.g., email, password).

Primary Key: A unique ID for each row (cannot be duplicated).