Python Python Functions: def, return, Parameters and Docstrings
Python functions for beginners: define with def, call, parameters vs arguments, return vs print, return several values, None and docstrings, with real…
November 13, 2026 · 11 min read
Library
All Guides
Every free guide on AI, data engineering, data science, SQL and Python, newest first.
SQL SQL Upsert: INSERT … ON CONFLICT and MERGE
Learn SQL upsert in PostgreSQL: INSERT ... ON CONFLICT DO NOTHING and DO UPDATE with EXCLUDED, why you need a unique constraint,…
November 13, 2026 · 12 min read
Python Python List, Dict and Set Comprehensions with if, else and Nested Loops
Python list comprehension for beginners: filter with if, use if else, build dict and set comprehensions, use nested loops, and know when…
November 12, 2026 · 12 min read
SQL SQL INSERT, UPDATE and DELETE: Change Data Safely with RETURNING
Learn SQL INSERT, UPDATE and DELETE in PostgreSQL: add rows, test the WHERE with SELECT first, use RETURNING, avoid changing every row,…
November 12, 2026 · 11 min read
SQL SQL CREATE TABLE: Data Types and Constraints
Learn SQL CREATE TABLE in PostgreSQL: data types, PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL, CHECK, DEFAULT and IDENTITY, with the real…
November 12, 2026 · 13 min read
Python Python String Methods and Slicing: split(), join(), strip() and Reversing Strings
Python string methods and slicing for beginners: slice with a step, reverse with [::-1], upper, lower, strip, replace, split, join, find, count…
November 11, 2026 · 11 min read
SQL SQL UNION vs UNION ALL, INTERSECT and EXCEPT
Learn SQL UNION vs UNION ALL, INTERSECT and EXCEPT with real examples: column rules, duplicates, ORDER BY, the errors you will see,…
November 11, 2026 · 14 min read
Python Python List vs Tuple vs Set vs Dict: Which One to Use
Python list vs tuple vs set vs dict: a comparison table, a real timeit test of in on a list vs a…
November 11, 2026 · 12 min read
Python Python Sets: add(), discard(), Union, Intersection and Removing Duplicates
Python sets for beginners: create a set, the set() vs {} trap, add, remove and discard, union, intersection and difference, remove duplicates…
November 10, 2026 · 13 min read
Python Python Dictionary: Keys, Values, get() and Looping with items()
Python dictionary tutorial for beginners: create a dict, get() vs [], KeyError, add, update and delete keys, loop with items(), order and…
November 10, 2026 · 11 min read
SQL SQL Self Join, CROSS JOIN, Semi-Joins and Anti-Joins
Learn the SQL self join, CROSS JOIN, semi-joins with EXISTS and anti-joins with NOT EXISTS, and see why NOT IN returns no…
November 10, 2026 · 13 min read
Python Python Tuples and Unpacking: One-Item Tuples, Star Unpacking and Swapping
Python tuple tutorial for beginners: create tuples, the one-item comma, why tuples cannot change, unpacking, star unpacking, swapping and returning values.
November 9, 2026 · 11 min read