Day20

Day 20: SQL Fundamentals

📘 Topics Covered

• SQL domains: DDL, DML, DCL, TCL
• Core CRUD: CREATE, SELECT, UPDATE, DELETE
• Schema operations: ALTER, DROP, TRUNCATE
• Transactions and control: COMMIT, ROLLBACK, SAVEPOINT, SET
• Constraints: PRIMARY KEY, FOREIGN KEY

🗂️ Cheat Sheet

• DDL: CREATE, ALTER, DROP, TRUNCATE
• DML: INSERT, SELECT, UPDATE, DELETE
• DCL: GRANT, REVOKE
• TCL: COMMIT, ROLLBACK, SAVEPOINT, SET

🔗 References

• SQL Tutorial: https://www.sqltutorial.org/
• PostgreSQL Docs (SQL): https://www.postgresql.org/docs/current/sql-commands.html
• SQLite SQL Reference: https://www.sqlite.org/lang.html