Belajar SQL Sampai Analisis

Intro and SELECT

📌 relational model basics, SELECT, WHERE, ORDER BY, LIMIT, NULL handling

Aggregations & Grouping

📌 Topik seputar function : COUNT, SUM, AVG, GROUP BY, HAVING

Multi-Table Joins & Aliases

📌 Topik Seputar : INNER JOIN, LEFT JOIN, ON, Table & Column Aliases

Sub-query & CTEs

📌 Topik Seputar : scalar subqueries, IN/NOT IN/EXISTS, CTEs

Window Function

📌 Topik Seputar : ROW_NUMBER, RANK/DENSE_RANK, running totals, LAG

Clean SQL & Capstone

📌 CASE expressions, style/performance basics, capstone project