Fullstack > 🗄️ SQL

---

Table of Contents

1. Introduction to SQL
   • What is SQL?
   • Importance of SQL in Full Stack Development
2. Database Concepts
   • Relational Databases
   • Tables, Rows, and Columns
   • Primary and Foreign Keys
3. SQL Commands
   • DDL (Data Definition Language)
     • CREATE
     • ALTER
     • DROP
   • DML (Data Manipulation Language)
     • SELECT
     • INSERT
     • UPDATE
     • DELETE
   • DCL (Data Control Language)
     • GRANT
     • REVOKE
   • TCL (Transaction Control Language)
     • COMMIT
     • ROLLBACK
     • SAVEPOINT
4. DQL (Data Query Language)
   • SELECT
   • WHERE Clause
   • ORDER BY
   • GROUP BY
   • HAVING
   • LIKE
5. Aggregations & Subqueries
   • Aggregate Functions
   • Subqueries
6. Joins
   • INNER JOIN
   • LEFT JOIN
   • RIGHT JOIN
   • FULL JOIN
   • CROSS JOIN
   • Self Join
7. Indexes and Optimization
   • Indexes in SQL
   • Query Optimization
8. Advanced SQL Concepts
   • Stored Procedures
   • Functions
   • Triggers

---

This guide provides an overview of essential SQL topics for full-stack developers.