How SQL and Python Work Together in Data Analysis

Beginner guide to how SQL and Python fit together in real analyst work: what each tool is actually for, the collect-analyze-present pipeline, a real example with a live API and SQLite, and which one to learn first.