SQL Basics: A Real-World Guide to Databases and Queries

Harshitha Madhavarapu — Thu, 03 Sep 2026 14:20:10 +0000

If you’ve come across the word “SQL” and were not sure about it, you’re in the right place. This guide explains SQL in simple language. No prior technical knowledge is needed.

What is a Database?

Every time you order food through an app like Swiggy or Zomato, a lot happens behind the scenes. Your name, address, phone number, order history, and information related to your payments all need to be stored somewhere safe and organized. That somewhere is a database.

A database is a structured way to store information, organized into tables with rows and columns, similar to how you’d arrange data in Excel.

Here’s what a simple customer table in a food delivery app might look like:

Each row is one customer. Each column holds one detail about them. Clean, organized, and easy to search, even with millions of customers.

Almost every app you use daily — food delivery, banking, shopping — runs on a database.

What is SQL?

SQL stands for Structured Query Language. It is the language used to communicate with a database to fetch information, add new records, update existing ones, or delete data you no longer need.

If the database is where information lives, SQL is how you interact with it. You write a simple instruction, and the database responds instantly, even across millions of records.

SQL is pronounced either “S-Q-L” or “sequel”.

What makes SQL approachable is how close it reads to plain English. Even someone who has never written code before can look at a SQL statement and understand roughly what it does.

The 4 Basic SQL Commands

Almost everything you do in a database comes down to four commands. Let’s walk through each one using a food delivery orders table as our example.

Here’s the data we’ll be working with:

1. SELECT — Retrieve Data

SELECT is used to fetch data from a table. It is the most commonly used SQL command.

Want to see all orders placed on the app?

SELECT * FROM orders;

Want only the customer names and their cities?

SELECT CustomerName, City FROM orders;

The * means fetch everything. You can also pick just the columns you need.

2. INSERT — Add New Data

INSERT is used to add a new record.

When a customer places a fresh order on a food delivery app, it gets added to the database instantly.

INSERT INTO orders (OrderID, CustomerName, City, Item, Amount, Status)
VALUES (505, 'Priya Iyer', 'Mumbai', 'Pav Bhaji', 150, 'Pending');

Priya’s order now appears as a new row in the orders table.

3. UPDATE — Modify Existing Data

UPDATE is used to change an existing record.

Vikram’s order was pending. It just got delivered and needs to be updated.

Now imagine running this:

UPDATE orders SET Status = 'Delivered';

Every single order in the table — including the ones still being prepared — would be marked as Delivered. That's a problem.

This is the right way:

UPDATE orders SET Status = 'Delivered' WHERE OrderID = 503;

Now only Vikram's order gets updated. Everything else stays exactly as it was.

4. DELETE — Remove Data

DELETE is used to remove a record.

Imagine an order was added to the database by mistake, and you want to remove that order.

Running this would be a disaster:

DELETE FROM orders;

The entire orders table, all records gone in one second. No warning, no undo.

The correct way:

DELETE FROM orders WHERE OrderID = 505;

Only that order gets removed. Everyone else’s order is safe.

How a Food Delivery App Could Use SQL Behind the Scenes

Imagine a food delivery app built on SQL. Every time you open the app and check your order history, a SELECT fetches your past orders. When you place a new order, an INSERT adds it to the database. When the delivery partner picks it up, an UPDATE changes the status from Pending to Out for Delivery. And if an order needs to be removed from the database, a DELETE can remove that specific record.

All of that could happen in seconds, powered entirely by SQL working behind the scenes.

This is how real applications use SQL every day — fetching records, adding new data, updating statuses, and keeping everything accurate across millions of users at once.

Why SQL is Worth Learning

SQL is used across almost every industry — banking, healthcare, retail, logistics, and tech. If a business stores data, SQL is involved somewhere.

It is one of the most beginner-friendly technical skills because it reads close to plain English. And once you know SQL, it opens up roles in data analysis, database administration, backend development, and cloud platforms like Microsoft Azure — all of which can benefit from a strong understanding of SQL.

Conclusion

SQL is simply a way to talk to a database. The four commands — SELECT, INSERT, UPDATE, and DELETE — are the foundation, and everything else builds on top of them. Once these feel familiar, working with real databases becomes a lot simpler than it sounds.

DEV Community: Harshitha Madhavarapu