SQL
COUNT, SUM, AVG, MIN and MAX
The five aggregate functions that collapse many rows into one value, the three forms of COUNT, and what each one does with NULL.
SQL
A complete SQL path: fundamentals, DDL and DML, querying, joins, subqueries, CTEs, window functions, design, indexing, transactions, performance and security.
91 notes in 31 topics
Topics in SQL
SQL Basics 6
DDL 3
DML 3
SELECT 3
WHERE 3
Functions 4
NULL and Logic 2
Aggregate Functions 2
GROUP BY 3
JOIN 5
Subqueries 4
Set Operations 2
CTEs 2
Constraints 3
Keys 2
Relationships 2
Database Design 2
Normalisation 3
Views 2
Window Functions 4
Advanced SQL 6
Procedures and Functions 2
Triggers 2
Temporary Tables 2
Transactions 2
Isolation and Locking 3
Indexes 3
Query Performance 3
SQL Security 2
SQL Dialects 2
Practical SQL 4
Notes
SQL
Aggregates, NULL and Aggregate Expressions
Aggregating an expression rather than a column: weighted totals, conditional counts and the difference between counting rows and counting facts.
SQL
GROUP BY Fundamentals
GROUP BY collapses rows into one row per distinct key. Learn the single rule that governs the select list and how NULLs are grouped.
SQL
HAVING, and WHERE vs HAVING
HAVING filters groups after aggregation, WHERE filters rows before it. Learn when each applies, why using both is usually correct, and which is faster...
SQL
Multi Column Grouping and Grouping Rules
Grouping by several columns, grouping by expressions, and the totals features - ROLLUP, CUBE and GROUPING SETS - that add subtotal rows.
SQL
INNER JOIN Explained
INNER JOIN keeps only rows that match on both sides. Learn the syntax, how the join condition works, and why unmatched rows silently disappear.
SQL
LEFT JOIN and RIGHT JOIN
Outer joins keep unmatched rows and fill the missing side with NULL. Learn LEFT and RIGHT JOIN, and the one mistake that silently turns an outer join...
SQL
FULL OUTER JOIN, CROSS JOIN and SELF JOIN
The three joins people meet last: keeping unmatched rows from both sides, deliberate Cartesian products, and joining a table to itself.
SQL
Multiple Joins, Join Conditions and Aliases
Building queries across four or more tables: reading a join chain, non equality conditions, join order, and keeping a long query readable.
SQL
Duplicate Rows from Joins and Finding Unmatched Records
Why a join multiplies rows, how to detect it, and the anti join patterns that answer "which rows have no match at all".
SQL
Subquery Basics: Scalar and Single Row Subqueries
A query inside a query. Learn where a subquery may appear, what each position requires it to return, and the error a scalar subquery raises when it re...
SQL
Multi Row Subqueries: IN, ANY and ALL
Subqueries that return a list of values, and the three operators that consume them - including the NULL trap that makes NOT IN return nothing.