Master SQL from Zero to Pro

💡 What is SQL 📝 SQL Syntax

📊 SELECT

🔃 ORDER BY

✨ DISTINCT 🔢 LIMIT 📥 FETCH

📍 WHERE ➕ AND 🔀 OR ↔️ BETWEEN 📋 IN 🔤 LIKE ∅ IS NULL 🚫 NOT

🔗 INNER JOIN ⬅️ LEFT JOIN ➡️ RIGHT JOIN 🔄 FULL OUTER JOIN ✖️ CROSS JOIN 🪞 SELF JOIN

🗂️ GROUP BY 🎯 HAVING 🧩 GROUPING SETS 🔁 ROLLUP 🎲 CUBE

🔧 UNION ⚡ INTERSECT ➖ MINUS

📄 CREATE TABLE 🔑 PRIMARY KEY 🚫 NOT NULL 🗑️ DROP TABLE ➕ Add Column ➖ Drop Column 🔐 FOREIGN KEY ☝️ UNIQUE ✅ CHECK 🔧 ALTER TABLE

➕ INSERT ✏️ UPDATE 🗑️ DELETE ⚡ TRUNCATE TABLE

👁️ Views ⚡ Triggers

🔀 CASE 🔗 COALESCE ∅ NULLIF

📈 Aggregate Functions ➗ AVG 🔢 COUNT ➕ SUM ⬆️ MAX ⬇️ MIN

🪆 Subquery 🔄 Correlated Subquery ✅ EXISTS 🌐 ALL 🎯 ANY

🪟 Introduction to Window Functions 📦 OVER() Clause 🗂️ PARTITION BY Clause ↕️ ORDER BY in Window 🖼️ Window Frame (ROWS/RANGE) 1️⃣ ROW_NUMBER() 🏆 RANK() 🥇 DENSE_RANK() 📊 NTILE() ⏮️ LAG() ⏭️ LEAD() 🔝 FIRST_VALUE() 🔚 LAST_VALUE() 📉 PERCENT_RANK() 📈 CUME_DIST() ➕ SUM() OVER ➗ AVG() OVER 🔢 COUNT() OVER ⬇️ MIN() OVER ⬆️ MAX() OVER

➕ CONCAT() 🔗 CONCAT_WS() 🔡 LOWER() 🔠 UPPER() 🅰️ INITCAP() 📏 LENGTH() 📐 CHAR_LENGTH() ✂️ SUBSTRING() ⬅️ LEFT() ➡️ RIGHT() 📍 POSITION() 🔍 INSTR() 🔄 REPLACE() 🔁 TRANSLATE() ✂️ TRIM() ⬅️ LTRIM() ➡️ RTRIM() ⬆️ LPAD() ⬇️ RPAD()

📅 CURRENT_DATE 🕐 CURRENT_TIME ⏱️ CURRENT_TIMESTAMP 🕐 NOW() 🔍 EXTRACT() 📆 DATE_PART() ➕ DATE_ADD() ➖ DATE_SUB() ⏳ INTERVAL 🔄 TO_DATE() 🔤 TO_CHAR() ⚡ CAST() 📊 DATEDIFF() ✂️ DATE_TRUNC()

🔢 ABS() 🔄 ROUND() ⬆️ CEIL() ⬇️ FLOOR() ⚡ POWER() √ SQRT() 🎲 RANDOM() 📊 LOG() 📉 LN() 〰️ SIN() 〰️ COS() 〰️ TAN() ➗ MOD()

📦 Common Table Expressions (CTE) 🔁 Recursive CTE ↔️ Lateral Joins 🔄 Pivot / Unpivot 📑 Indexes 📋 Query Execution Plan ⚡ Query Optimization 📈 Running Totals 〰️ Moving Averages 📊 Percentiles 🗃️ JSON Functions 👁️ Materialized Views