Technical deep dives into SQL, Python, and AI development. I document what I learn building with data and language models.
Join Python developers learning SQL — new tutorial every Monday
Learning Paths
SQL for Python Developers Start Here
Learn SQL fundamentals using DuckDB and Python. A practical series for Python developers who want to level up their data skills.
I Vibe Coded and Lived to Tell
What happens when you build real AI tools with AI writing the code? Chaos mostly, but also hard-won lessons about what small models can and can't do.
AWS Data Engineer Associate Certification
My honest, unfiltered experience studying for and taking the AWS Certified Data Engineer – Associate exam. The wins, the setbacks, and everything I learned …
Latest Articles
HAVING: Filtering Grouped Results
When I first encountered HAVING, I thought, “Why do we need this? It’s just like WHERE.” Then I tried filtering on COUNT() and hit a strange error. That’s when it clicked: HAVING filters after …...
I trusted three local AI models, and Python had to clean up their mess
Previously, I reported that I vibe-coded a tool that reads a blog post I’ve written and generates platform-specific promo copy using a local Ollama model. I chose local models because I’m curious …...
T-SQL Tuesday #196 - What career risks have you taken?
Invitation from James Serra I found T-SQL Tuesday just in time for this first post, and I’m looking forward to participating. What career risks have you taken? The year was 1997. I was delivering …...
GROUP BY: Aggregating Your Data
Last week, we learned to use WHERE to efficiently return only the rows that we want from a database. But what if you want to summarize the data more efficiently? It turns out that you can have the …...
WHERE: Filtering Your Data
We have come a long way in the past couple of months, working through the core SQL keywords. So far, we can SELECT columns, specify FROM where our data lives, and ORDER BY to sort results. That is …...