07_SQL_basic_commands.md

SELECT

SELECT name, age FROM Students;

INSERT

INSERT INTO Students (id, name, age) VALUES (1, 'Shiwans', 20);

UPDATE

UPDATE Students SET age = 21 WHERE id = 1;

DELETE

DELETE FROM Students WHERE id = 1;

USE CASES OF DBMS

• RDBMS (Relational) → For structured data (banking, e-commerce).
• NoSQL DBMS → For unstructured/large-scale data (social media, big data).

Popular DBMS

• MySQL
• PostgreSQL
• MongoDB
• SQLite