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.
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
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 …...
I Vibe Coded a Local AI-Powered Promo Generator
Every Monday, I publish a blog post. Then I write five slightly different versions of “hey, I wrote a thing” for LinkedIn, Twitter, Bluesky, and Mastodon. Each platform has different character limits, …...
ORDER BY: Sorting Your Results
We now have a firm grasp on how to use SELECT: Choosing Your Columns and FROM: Where Your Data Lives to tell the database where to find data and how to format the columns when it returns it. With this …...