Most posts here are part of a series, so if one is useful, the one before it probably is too. The SQL for Python Developers series is the place to start if you came for SQL; I Vibe Coded and Lived to Tell if you came for the AI stories.
SQL's SELECT is more than picking columns. Rename with AS, compute expressions, and use DISTINCT for unique values.
We write SELECT first, but FROM runs first. It's the `for item in collection` part of a Python loop: pick your data source before anything else.
The mental model that makes SQL click: describe what you want instead of looping row by row. Think in sets and the keywords become intuitive.
Your in-memory database disappears when Python exits. Let's fix that with a one-line change that saves everything to disk.
Real SQL practice needs real-looking data. Generate hundreds of customers with Python's Faker library without downloading a single CSV
Install DuckDB with pip, create your first table, insert data, and run a SQL query - all in Python, all in under 5 minutes, zero configuration required
Learning SQL makes you a better Python developer, even if you use pandas and ORMs. The first post in a series that teaches it with DuckDB and Python.
Five years of yearly goals in markdown, now with Claude in the loop. How I added AI to goal setting and review without losing the habit.
An update after a few weeks about learning agentic AI, it's been a fun journey and I've found some great resources
I took the DEA-C01 AWS Data Engineer Associate exam for the second time this morning. No results yet, but here are my thoughts on the attempt.