What is SQL?

SQL stands for Structured Query Language. It is a standard language used to communicate with databases. SQL is used to store, retrieve, update, and delete data in relational databases like MySQL, PostgreSQL, SQL Server, Oracle, and others.

Why Use SQL?

SQL helps you:

• Create and manage database structures (tables, views, etc.)
• Insert, update, and delete data
• Retrieve specific data using queries
• Control access to the database

🧩 Basic SQL Commands with Examples

1. CREATE TABLE – Make a new table

CREATE TABLE Students (
    ID INT,
    Name VARCHAR(100),
    Age INT
);

2. INSERT INTO – Add data into a table

INSERT INTO Students (ID, Name, Age)
VALUES (1, 'Alice', 20);

3. SELECT – Get data from a table

SELECT * FROM Students;
-- Shows all students

SELECT Name, Age FROM Students WHERE Age > 18;
-- Shows students older than 18

4. UPDATE – Change existing data

UPDATE Students
SET Age = 21
WHERE ID = 1;

5. DELETE – Remove data from a table

DELETE FROM Students
WHERE ID = 1;

6. DROP TABLE – Delete a table completely

DROP TABLE Students;

Summary

• SQL is the language of databases.
• It works with tables to manage structured data.
• It uses commands like SELECT, INSERT, UPDATE, DELETE, CREATE, and DROP.

Would you like to try writing some SQL queries yourself or want more practice examples?