Complete Learning Series
Structured multi-lesson courses, taken in order, each ending with a final project.
Learning series
Articles in Complete Learning Series (page 1 of 10)
- RAG Knowledge Base Freshness: Staleness and Incremental Updates — A RAG system is only as current as its index. This guide covers detecting changes, updating incrementally, handling deletions, measuring staleness and telling users honestly when an answer may be out of date.
- Re-Embedding Migrations: How to Change Embedding Models Safely — Vectors from different embedding models cannot be compared, so switching models means re-embedding everything. Here is a migration plan with versioned storage, backfill, evaluation before cutover, a rollback path and a cost estimate.
- pgvector HNSW vs IVFFlat: Index Tuning for RAG in Postgres — An exact vector scan works until it does not. Then you must pick an approximate index and tune it. This guide compares HNSW and IVFFlat in pgvector, explains the knobs that trade recall for speed, and shows how to measure the result on your own data.
- Regex Text Preprocessing and ReDoS Safety for AI Automation — Cheap deterministic preprocessing improves accuracy and cuts token cost, but one careless regex can freeze a worker on hostile input. This guide covers practical patterns, redaction limits, ReDoS causes and defences, and how to test them.
- How to Price AI Automation Projects: A Guide for Freelancers and Agencies — Underpricing is the most common way automation builders lose money. This guide compares hourly, fixed, phased and value-informed pricing, shows how to estimate honestly, handle model usage costs and scope changes, and structure the contract.
- Normalizing Phone Numbers, Addresses and Names Before AI Automation — Messy contact data makes automations create duplicates, mis-greet customers and route wrongly. This guide covers safe normalisation of emails, phones, names and addresses, conservative matching, and where a language model helps or gets in the way.
- Dates, Times and Time Zones in AI Automation: Bugs and Fixes — Reports that are off by a day, reminders at the wrong hour and duplicates at daylight-saving changes all come from the same handful of mistakes. This guide shows how to store, convert, parse and test dates and time zones correctly.
- SQL for Automation Builders: Joins, Aggregates and Safe Writes — Automation builders hit databases constantly, often with just enough SQL to be dangerous. This guide covers the queries you actually need: joins, aggregates, upserts, transactions and the habits that stop a bad write from becoming an incident.
- JSON, JSONPath and jq for Automation Builders — Nearly everything an automation touches is JSON, and most silent failures are a missing key, a null or an array of the wrong length. This guide teaches the reading, reshaping and validating skills with jq and JSONPath recipes.
- Maintenance Retainers and SLA Design for AI Automation (Part 12 of 20) — Part 12 of the AI Automation Business series. Automations decay quietly. Define what maintenance includes, offer clear tiers, promise only service levels you can meet, price for risk and availability, and keep boundaries with fair-use rules.
- Monitoring Client Automations: Alerts and Incident Response (Part 13 of 20) — Part 13 of the AI Automation Business series. Watch three layers: is it running, is it right, does it pay. Design alerts that get action, keep runbooks and kill switches ready, and handle incidents calmly with clear communication.
- Testing and Client Acceptance for AI Automation Projects (Part 11 of 20) — Part 11 of the AI Automation Business series. Test at every level, evaluate AI steps on held-out data, run UAT, triage feedback into defects and changes, launch in shadow mode and close with a signed acceptance that starts the warranty.
- Documenting and Handing Over AI Automation Projects (Part 10 of 20) — Part 10 of the AI Automation Business series. Documentation is part of the deliverable. Learn the documentation set, how to document AI behaviour, write runbooks, run training and complete a handover that leaves the client in control.
- Building a Repeatable AI Automation Delivery Process (Part 9 of 20) — Part 9 of the AI Automation Business series. Stages, artefacts and checklists that make good work the default: design before build, error handling and logging by default, versioned prompts, quality gates and a reusable toolkit.
- AI Automation Contracts: Liability, IP and Data Clauses (Part 7 of 20) — Part 7 of the AI Automation Business series. What each clause is for: scope and acceptance, IP with carve-outs, data protection and sub-processors, responsibility for AI outputs, liability caps and exit. General information, not legal advice.
- Writing AI Automation Proposals and Statements of Work (Part 6 of 20) — Part 6 of the AI Automation Business series. A proposal must show you listened, explain the solution plainly, fix scope and price, reduce perceived risk and make the decision easy. Includes structure, pricing presentation and follow-up.
- Managing Client API Keys, Costs and Usage Billing (Part 14 of 20) — Part 14 of the AI Automation Business series. Client-owned accounts, one key per purpose, budget alerts and workflow caps, measured cost forecasts and honest billing options, plus rotation and offboarding so nothing lingers.
- Scoping AI Automation Projects and Preventing Scope Creep (Part 5 of 20) — Part 5 of the AI Automation Business series. What a scope contains, how to define done for probabilistic AI behaviour, how to estimate honestly, phase the work, and run change control so extra requests never quietly eat your margin.
- Process Mapping and Automation Opportunity Scoring (Part 4 of 20) — Part 4 of the AI Automation Business series. Turn a vague description into a validated process map, capture exceptions and volumes, spot waste to fix first, and score opportunities so you automate what is worth automating.
- Discovery Calls for AI Automation Projects: Questions to Ask (Part 3 of 20) — Part 3 of the AI Automation Business series. A discovery call is mostly listening. Get the agenda, the questions for problem, process, systems, data, people and budget, the red flags to watch for, and how to close with a dated next step.
- Choosing an AI Automation Niche and Ideal Client (Part 2 of 20) — Part 2 of the AI Automation Business series. A niche is who, what problem, what outcome and what mechanism. Learn to score candidates, validate demand before committing, write an ideal client profile and decide whom to decline.
- Multimodal RAG: Scanned PDFs, Charts and Page Images — Plain text extraction fails on scans, charts and complex tables, so RAG answers quietly go wrong. This guide compares OCR, layout parsing and vision models, explains page-image retrieval, and shows how to test the whole pipeline.
- OAuth for Automation Builders: Scopes, Refresh Tokens and Why Connections Break — Workflows that worked for weeks suddenly fail with 401 errors, and the cause is usually an OAuth detail nobody explained. This guide covers flows, scopes, refresh tokens, expiry and revocation, plus how to build automations that survive them.
- API Pagination Patterns for Automation Builders: Offset, Cursor and Beyond — Most APIs return data in pages, and most automation bugs here are silent: missed rows, duplicates, or a loop that never ends. This guide covers each pagination style, safe loop design, rate limits, checkpoints and how to test.