SQL SQL LEFT JOIN, RIGHT JOIN and FULL OUTER JOIN
Learn SQL LEFT JOIN, RIGHT JOIN and FULL OUTER JOIN with real examples: keep unmatched rows, count them correctly, fix the ON…
November 9, 2026 · 14 min read
Library
All Guides
Every free guide on AI, data engineering, data science, SQL and Python, newest first.
Python Python Lists and List Methods: Indexing, Slicing, Sorting and Copying
Python list methods for beginners: create, index and slice lists, append vs extend, insert, remove, pop, sort vs sorted, and the copy…
November 9, 2026 · 12 min read
SQL SQL INNER JOIN Explained
Learn SQL INNER JOIN with real PostgreSQL examples: match rows with ON, use table aliases, join three or four tables, and avoid…
November 8, 2026 · 13 min read
SQL SQL Order of Execution: Why Aliases and Aggregates Fail in WHERE
The SQL order of execution explained: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY, LIMIT. See why aliases and aggregates fail in…
November 8, 2026 · 11 min read
SQL SQL GROUP BY and HAVING
Learn SQL GROUP BY and HAVING with real PostgreSQL examples: group by several columns, fix the "must appear in the GROUP BY…
November 8, 2026 · 11 min read
SQL SQL Aggregate Functions: COUNT, SUM, AVG, MIN and MAX
Learn SQL aggregate functions COUNT, SUM, AVG, MIN and MAX: COUNT(*) vs COUNT(DISTINCT), NULL handling, COALESCE and FILTER, with real PostgreSQL output.
November 7, 2026 · 11 min read
SQL SQL CASE WHEN, CAST and Common String and Date Functions
Learn SQL CASE WHEN, CAST and the string and date functions you use daily (UPPER, TRIM, ||, EXTRACT, date_trunc, AGE), with real…
November 7, 2026 · 14 min read
SQL SQL ORDER BY: Sorting, NULLS FIRST/LAST and Paging with LIMIT/OFFSET
Learn SQL ORDER BY: sort by several columns, place NULLs with NULLS FIRST/LAST, and page with LIMIT/OFFSET without losing rows. Plus TOP…
November 7, 2026 · 13 min read
SQL SQL NULL Values: IS NULL, COALESCE and Three-Valued Logic
SQL NULL explained with real PostgreSQL outputs: why = NULL fails, IS NULL, three-valued logic, the NOT IN trap, COALESCE, NULLIF and…
November 6, 2026 · 13 min read
SQL SQL WHERE Clause: Filter Rows with AND, OR, IN, BETWEEN and LIKE
Learn the SQL WHERE clause with real PostgreSQL outputs: comparison operators, AND/OR precedence, IN, BETWEEN, LIKE and ILIKE, plus MySQL and SQLite…
November 6, 2026 · 12 min read
SQL SQL SELECT Statement: Columns, Aliases, DISTINCT and LIMIT
Learn the SQL SELECT statement: pick columns, name them with AS, remove duplicates with DISTINCT and limit rows with LIMIT, with real…
November 6, 2026 · 11 min read
SQL Install PostgreSQL and Load a Sample Database for SQL Practice
Install PostgreSQL on Windows, macOS or Linux, then load a sample database with createdb and psql -f. Includes the full practice script…
November 5, 2026 · 17 min read