Course 3 — Simple Ollama demos

Audience: anyone who has Ollama installed (or is willing to install it in 5 minutes) and wants small, runnable demos rather than a long course. Every demo is short, practical, and copy-paste friendly.

Level · Beginner → IntermediateFormat · Short standalone demosDemos · 1 (more coming)Stack · Ollama + Python (local only)

What this course is about

This course is not a long, linear lesson. It is a list of simple demos, each one a stand-alone, step-by-step tutorial you can finish in 15–30 minutes. The format is always the same:

1. A clear objective.
2. The exact commands to type (Windows PowerShell first, macOS/Linux noted).
3. A short Python script to copy-paste.
4. A few questions/tests to try.
5. A short “what just happened?” explanation.

Everything runs 100% locally with Ollama. No cloud, no API key, your data never leaves your machine.

The demos

#	Demo	Duration	What it teaches
01	CSV / SQL RAG with Ollama	~25 min	Ask natural-language questions about a CSV file. The LLM writes SQL, DuckDB runs it, the LLM explains the result.

More demos will be added here over time — each in the exact same simple style.

Prerequisites

• A terminal (PowerShell on Windows, or any shell on macOS/Linux).
• Ollama installed. Check with ollama --version.
• Python 3.10+ with pip.

If you have never used Ollama before, the gentle intro is Course 2 — Coding with a local LLM. Otherwise, jump straight into the first demo.

Start with Demo 01 →