Skip to content
Library

All Guides

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

Python Course: Learn Python From Beginner to Advanced Python Python Course: Learn Python From Beginner to Advanced Free Python course for beginners: short lessons from installing Python to functions, files, OOP and testing, each with tested code, exercises and… November 4, 2026 · 5 min read
Python Indentation and Syntax: Blocks, Comments and Common Errors Python Python Indentation and Syntax: Blocks, Comments and Common Errors Python indentation explained for beginners: how blocks work, the 4-space rule, real IndentationError and TabError fixes, comments, docstrings and long lines. November 4, 2026 · 10 min read
How to Run a Python Script: the REPL, .py Files and VS Code Python How to Run a Python Script: the REPL, .py Files and VS Code How to run a Python script from the terminal or VS Code: use the >>> REPL, run .py files with python3, exit… November 4, 2026 · 9 min read
How to Install Python on Windows, macOS and Linux Python How to Install Python on Windows, macOS and Linux How to install Python on Windows, macOS and Linux: pick the right version, use the official installers, add Python to PATH, and… November 4, 2026 · 9 min read
What Is Python Used For? A Simple Introduction for Beginners Python What Is Python Used For? A Simple Introduction for Beginners What is Python used for? Learn the real uses of Python, why beginners pick it, what it is not good at, and… November 4, 2026 · 9 min read
Image Classification vs Object Detection vs Segmentation, Explained With Python Computer Vision Image Classification vs Object Detection vs Segmentation, Explained With Python Image classification vs object detection vs segmentation explained with Python: real model outputs, semantic vs instance masks, and IoU and mAP by… November 4, 2026 · 23 min read
NLP vs LLM: What Is the Difference and When to Use Each NLP NLP vs LLM: What Is the Difference and When to Use Each NLP vs LLM explained: LLMs are one family of models inside NLP. See a real test plus a when-to-use table on cost,… November 4, 2026 · 22 min read
How to Build a Data Analyst Portfolio That Gets Interviews (Checklist and Sample Project) Career Advice How to Build a Data Analyst Portfolio That Gets Interviews (Checklist and Sample Project) Build a data analyst portfolio that gets interviews: a sourced checklist of what reviewers look for, plus a sample SQL and Python… November 4, 2026 · 20 min read
What Is MLOps? One Model Taken From Notebook to Production MLOps What Is MLOps? One Model Taken From Notebook to Production What is MLOps? Learn the MLOps lifecycle and how it differs from DevOps, then take one model from notebook to production with… November 4, 2026 · 17 min read
Supervised vs Unsupervised Learning: One Dataset, Solved Both Ways (Python) Machine Learning Supervised vs Unsupervised Learning: One Dataset, Solved Both Ways (Python) Supervised vs unsupervised learning explained with one real dataset solved both ways in Python: 98.3% accuracy vs clustering, plus the scaling trap. November 4, 2026 · 14 min read
How Large Language Models Work: One Prompt, Step by Step Language Models How Large Language Models Work: One Prompt, Step by Step Learn how large language models work by following one prompt through tokens, embeddings, attention and next-token prediction, plus how LLMs are trained. November 3, 2026 · 16 min read
SQL SQL Window Functions: 15 Practice Problems with Answers 15 SQL window function practice problems with ready-to-run answers: ROW_NUMBER, RANK, SUM OVER, LAG, LEAD, NTILE. Learn by doing. November 2, 2026 · 2 min read