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.
Build a complete pipeline - fetch from an API, load into DuckDB, transform with SQL, export results. A capstone putting it all together.
Your AI writes Bash. If VS Code opens PowerShell, you translate every command by hand. Four clicks make Bash the default, and one command proves it worked.
Read EXPLAIN output to understand why queries are slow. Learn when to add indexes and when to stop worrying about performance.
INSERT, UPDATE, and DELETE with guardrails. Always use WHERE, test with SELECT first, and use transactions to undo mistakes.
Giving an LLM the keys to your wiki is not a dramatic handoff. It looks like maintenance done quietly, completely, every time.
One keystroke opens the VS Code terminal on every platform. That shortcut is the gap between what the AI said and knowing the code actually runs.
Map Python types to SQL types. Learn CREATE TABLE with primary keys, foreign keys, and constraints like NOT NULL and DEFAULT.
Calculate across rows without collapsing them. Running totals, rankings, and row comparisons that GROUP BY can't do.
An AI writes instructions for itself, backs up its own memory, and builds a tool to read articles on your behalf. It considers this progress.
Two sessions, two takeaways, and why you should not skip the training day at PyTexas.