SQL
SELECT Basics: Columns, SELECT * and Aliases
The statement you will write more than all the others combined. Choose columns, alias them, and learn why SELECT * belongs in the console and not in c...
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
Expressions, Calculated Columns and DISTINCT
Compute values in the select list, build derived columns from existing ones, and use DISTINCT correctly - including what it does across several column...
SQL
ORDER BY, LIMIT and Pagination
Sorting on one or many columns, NULL placement, and the four dialect specific ways to fetch page two of a result set - including why OFFSET gets slow.
SQL
WHERE and Comparison Operators
WHERE decides which rows survive. Learn the comparison operators, how conditions are evaluated per row, and why a function around a column kills an in...
SQL
AND, OR, NOT and Operator Precedence
Combining conditions correctly. Precedence between AND and OR, what NOT does to a NULL, and how to keep complex filters readable and index friendly.
SQL
IN, BETWEEN, LIKE and IS NULL
The four filtering shortcuts you will use constantly: set membership, ranges, pattern matching with wildcards, and the only correct way to test for NU...
SQL
SQL String Functions
Concatenating, trimming, slicing, replacing and searching text - and which of these functions changes name in every dialect.
SQL
SQL Numeric Functions
Rounding, truncating, absolute values, modulo and integer division - and the rounding rules that decide whether your invoice totals balance.
SQL
SQL Date and Time Functions
Current date and time, adding and subtracting intervals, differences between dates, extracting parts, and formatting - the least portable corner of SQ...
SQL
CASE, COALESCE, NULLIF and Conversion Functions
Conditional logic inside a query, NULL substitution, safe division and explicit type conversion - four tools that remove most procedural code from SQL...
SQL
What NULL Really Means
NULL is not zero, not an empty string and not equal to itself. Learn what it represents, how it spreads through expressions and how to handle it delib...
SQL
Three Valued Logic: TRUE, FALSE and UNKNOWN
SQL conditions return three results, not two. Learn the AND, OR and NOT truth tables, why NOT IN breaks on NULL, and the NULL safe comparison operator...