Skip to content
Library

All Guides

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

Python Functions: def, return, Parameters and Docstrings 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
SQL Upsert: INSERT … ON CONFLICT and MERGE 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 List, Dict and Set Comprehensions with if, else and Nested Loops 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 INSERT, UPDATE and DELETE: Change Data Safely with RETURNING 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 CREATE TABLE: Data Types and Constraints 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 String Methods and Slicing: split(), join(), strip() and Reversing Strings 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 UNION vs UNION ALL, INTERSECT and EXCEPT 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 List vs Tuple vs Set vs Dict: Which One to Use 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 Sets: add(), discard(), Union, Intersection and Removing Duplicates 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 Dictionary: Keys, Values, get() and Looping with items() 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 Self Join, CROSS JOIN, Semi-Joins and Anti-Joins 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 Tuples and Unpacking: One-Item Tuples, Star Unpacking and Swapping 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