Skip to content
Library

All Guides

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

PostgreSQL vs MySQL vs SQLite vs SQL Server: Which SQL to Learn First SQL PostgreSQL vs MySQL vs SQLite vs SQL Server: Which SQL to Learn First PostgreSQL vs MySQL vs SQLite vs SQL Server for beginners: licences, how each runs, dialect differences like LIMIT, TOP and ILIKE, and… November 5, 2026 · 12 min read
What Is a Relational Database? Tables, Rows, Columns and Keys SQL What Is a Relational Database? Tables, Rows, Columns and Keys What is a relational database? Learn tables, rows, columns, primary keys and foreign keys with real PostgreSQL examples from a small online… November 5, 2026 · 12 min read
Python Exercises for Beginners: Level 1 Practice Set and Number Guessing Game Python Python Exercises for Beginners: Level 1 Practice Set and Number Guessing Game Python exercises for beginners with solutions: 10 graded tasks on input, numbers, strings, if, for and while, plus a number guessing game… November 4, 2026 · 13 min read
Python while Loops, break and continue: Infinite Loops and Input Checks Python Python while Loops, break and continue: Infinite Loops and Input Checks Python while loop for beginners: counters, input validation, infinite loops and Ctrl+C, break, continue, while True and while-else, with real terminal runs. November 4, 2026 · 10 min read
Python for Loops and range(): Lists, Strings and enumerate() Python Python for Loops and range(): Lists, Strings and enumerate() Python for loop tutorial for beginners: loop over lists and strings, use range(start, stop, step), enumerate(), nested loops and for-else, with real… November 4, 2026 · 10 min read
Python if, elif and else Statements (and match) Python Python if, elif and else Statements (and match) Python if else explained for beginners: if, elif and else, nested if, truthiness, the one-line conditional expression and match/case, with real outputs. November 4, 2026 · 12 min read
Python input() Function: Read User Input and Print Output Python Python input() Function: Read User Input and Print Output How to use the Python input function: read user input, convert it with int() and float(), fix ValueError and EOFError, and control… November 4, 2026 · 10 min read
Python Operators: Comparison, Logical, is vs == and Precedence Python Python Operators: Comparison, Logical, is vs == and Precedence Python operators for beginners: comparison, and/or/not with short-circuit, in and not in, is vs ==, assignment shortcuts and operator precedence explained. November 4, 2026 · 9 min read
Python Type Conversion: Booleans, None, int() and str() Python Python Type Conversion: Booleans, None, int() and str() Python type conversion for beginners: int(), float(), str() and bool() with real outputs, True and False, truthiness, None, and how to fix… November 4, 2026 · 10 min read
Python Strings and f-Strings: Quotes, Escapes and Formatting Python Python Strings and f-Strings: Quotes, Escapes and Formatting Python f-string and string basics for beginners: quotes, escape sequences, raw strings, joining, len() and indexing, plus format specs like .2f and… November 4, 2026 · 11 min read
Python Numbers: int, Float vs Decimal and Rounding Python Python Numbers: int, Float vs Decimal and Rounding Python float vs Decimal for beginners: why 0.1 + 0.2 is not 0.3, how int, /, // and % work, how round()… November 4, 2026 · 8 min read
Python Variables: Naming Rules and Examples Python Python Variables: Naming Rules and Examples Python variables explained for beginners: how = assignment and dynamic typing work, naming rules and PEP 8 style, multiple assignment and NameError… November 4, 2026 · 10 min read