🕒 3-Hour SQL Crash Course

⏳ Hour 1: SQL Basics & Data Retrieval

🔹 Introduction to SQL

What is SQL?

Databases, Tables, and Schema

Types of SQL Commands: DDL, DML, DQL, DCL, TCL

🔹 Basic SQL Queries

SELECT statement

WHERE clause (filtering data)

ORDER BY (sorting data)

LIMIT (restricting results)

🔹 Basic Aggregation & Grouping

COUNT(), SUM(), AVG(), MIN(), MAX()

GROUP BY and HAVING

⏳ Hour 2: SQL Joins & Subqueries

🔹 Joins (Combining Multiple Tables)

INNER JOIN

LEFT JOIN

RIGHT JOIN

FULL JOIN

CROSS JOIN

🔹 Subqueries & Common Table Expressions (CTEs)

Basic Subqueries (SELECT inside SELECT)

Correlated Subqueries

Using CTEs (WITH clause)

🔹 Advanced Filtering

IN, NOT IN

EXISTS, NOT EXISTS

CASE statement

⏳ Hour 3: SQL Data Manipulation & Optimization

🔹 Modifying Data (DML Commands)

INSERT INTO

UPDATE

DELETE

🔹 Database Modifications (DDL Commands)

CREATE TABLE

ALTER TABLE

DROP TABLE

🔹 Indexes & Performance Optimization

Creating Indexes (CREATE INDEX)

When to use Indexes?

Query Optimization Basics

🔹 Transactions & ACID Properties

BEGIN TRANSACTION

COMMIT & ROLLBACK

---

💡 Final Notes:

Hands-on exercises after every topic.

Provide a mini project or real-world dataset for practice.