Why databases over files in SQL

Introduction

Databases help organize and find data quickly. They keep data safe and easy to update, unlike simple files.

When you have lots of data that needs to be searched fast.

When many people need to use or change the data at the same time.

When you want to keep data safe and avoid losing it.

When you want to easily add, update, or delete data without mistakes.

When you want to connect different types of data together.

Syntax

SQL

-- No specific code for this concept, but here is a simple example of creating a table in a database:
CREATE TABLE users (
  id INT PRIMARY KEY,
  name VARCHAR(100),
  email VARCHAR(100)
);

Databases use tables to store data in rows and columns, unlike files which store data as plain text or binary.

SQL commands help manage and retrieve data efficiently.

Examples

This creates a table named products to store product details.

SQL

CREATE TABLE products (
  product_id INT PRIMARY KEY,
  product_name VARCHAR(100),
  price DECIMAL(10,2)
);

This adds a new product to the products table.

SQL

INSERT INTO products (product_id, product_name, price) VALUES (1, 'Pen', 1.50);

This finds all products that cost more than $1.00.

SQL

SELECT * FROM products WHERE price > 1.00;

Sample Program

This example creates a table for employees, adds three employees, and then shows all of them.

SQL

CREATE TABLE employees (
  id INT PRIMARY KEY,
  name VARCHAR(50),
  department VARCHAR(50)
);

INSERT INTO employees (id, name, department) VALUES
(1, 'Alice', 'Sales'),
(2, 'Bob', 'HR'),
(3, 'Charlie', 'IT');

SELECT * FROM employees;

Important Notes

Files are simple but slow when data grows big or many people use it.

Databases handle many users and keep data safe from errors.

Using databases helps keep data organized and easy to find.

Summary

Databases store data in tables for easy searching and updating.

They support many users working at the same time safely.

Databases protect data better than simple files.