Skip to content
Library

All Guides

Every free guide on AI, data engineering, data science, SQL and Python, newest first.

SQL LEFT JOIN, RIGHT JOIN and FULL OUTER JOIN 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
Python Lists and List Methods: Indexing, Slicing, Sorting and Copying 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 INNER JOIN Explained 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 Order of Execution: Why Aliases and Aggregates Fail in WHERE 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 GROUP BY and HAVING 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 Aggregate Functions: COUNT, SUM, AVG, MIN and MAX 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 CASE WHEN, CAST and Common String and Date Functions 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 ORDER BY: Sorting, NULLS FIRST/LAST and Paging with LIMIT/OFFSET 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 NULL Values: IS NULL, COALESCE and Three-Valued Logic 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 WHERE Clause: Filter Rows with AND, OR, IN, BETWEEN and LIKE 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 SELECT Statement: Columns, Aliases, DISTINCT and LIMIT 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
Install PostgreSQL and Load a Sample Database for SQL Practice 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