10 days of SQL
10 days of SQL
Courses
📘 Day 1–3: SQL Foundations & Joins
- CREATE, SELECT, WHERE, and LIKE statements
- Sorting and filtering data
- Aggregations with GROUP BY and HAVING
- Inner, Left, Right, and Full Joins—understanding relationships in data!
🧠Day 4–6: Advanced Queries & Set Ops
- Self Joins, Subqueries, and Cross Joins
- Set operations like UNION, INTERSECT, EXCEPT
- String manipulation and advanced aggregates like GROUP_CONCAT, PERCENTILE_CONT, and ROLLUP
📊 Day 7–8: Window Functions & Query Optimization
- ROW_NUMBER, RANK, LEAD, LAG, and NTILE
- Recursive CTEs, WITH clause mastery
- Indexing strategies and analyzing query plans for faster performance
🔒 Day 9: Transactions & Concurrency
- ACID properties and isolation levels
- Locking mechanisms and concurrency control
- Real-world use of aggregates, joins, and nested queries
🧱 Day 10: Data Modeling & Normalization
- Conceptual, logical, and physical data models
- 1NF, 2NF, 3NF, and BCNF—clean and efficient schema design!
$20$36