Introduction to Databases

Introduction

A database is an organized collection of data that a program can read, write and search efficiently. Think of it as a super-powered Excel sheet that thousands of users can read and update at the same time without losing or corrupting any data.

Beginner analogy: imagine a giant library. The database is the library. Each table is a shelf. Each row is a book. Each column is a piece of information about that book — title, author, year. SQL is the librarian who instantly finds what you ask for.

Understanding the topic

Core concepts to understand:

• Database = persistent, structured storage with concurrent access.
• DBMS = the software that manages the database (Postgres, MySQL...).
• Relational DB = data in tables with rows and columns, linked by keys.
• NoSQL DB = document, key-value, graph or column stores for flexible data.
• Databases give you durability, concurrency, integrity and queryability.

Syntax reference

Visual workflow / architecture:

┌──────────────────────────────────────┐
│        Application (Web/API)         │
└──────────────┬───────────────────────┘
               │ SQL over TCP
        ┌──────▼───────┐
        │     DBMS     │  ← Postgres / MySQL
        ├──────────────┤
        │  Tables      │
        │  Indexes     │
        │  Constraints │
        │  Transactions│
        └──────┬───────┘
               │
        ┌──────▼───────┐
        │  Disk Files  │  (durable storage)
        └──────────────┘

Real-world use

Every Uber ride, Amazon order, Netflix watch and bank transfer is recorded in a database. The world runs on a few thousand engineers who know how to design and query databases well.

Best practices

• Pick one database (Postgres recommended) and learn it deeply before exploring others.
• Always think about durability — data loss is unacceptable in production.
• Model the real-world entities first, then design the tables.

Hands-on exercise

Interview preparation — practice these questions:

• Q1. What is a database?
• Q2. Difference between a database and a DBMS.
• Q3. Give three examples of relational and three NoSQL databases.
• Q4. Why do we need databases instead of just files?
• Q5. What are the four guarantees a DBMS gives you?