Saturday, 30 May 2026
Databases
SQL & DBMS Tracker
Master relational databases and SQL queries for backend roles.
Phase 1: Foundation
Core SQL commands:
DDL (Create, Alter, Drop), DML (Insert, Update, Delete), DQL (Select).
Filtering & Sorting:
WHERE, ORDER BY, LIMIT, DISTINCT, LIKE.
Aggregations:
COUNT, SUM, AVG, MIN, MAX.
Grouping:
GROUP BY, HAVING. Know the difference between WHERE and HAVING.
Joins:
INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN.
Constraints:
Primary Key, Foreign Key, UNIQUE, NOT NULL, CHECK.
Phase 2: Elevation
Advanced Queries:
Subqueries vs. CTEs, Window Functions (RANK, LEAD, LAG).
DBMS Internals:
ACID Properties, Database Normalization (1NF to BCNF).
Indexing:
B-Trees, Clustered vs. Non-Clustered indexes.
Transactions & Concurrency:
Locks, Deadlocks, Isolation Levels.
Curated Summary
Copy Progress