November 26
Common Table Expressions (CTEs) are one of the most useful, least understood features in SQL. Beginners often think they’re “just subqueries with a nicer syntax,” but CTEs are far more powerful than that. This article gives the clearest explanation of what a CTE truly is.
November 24
The Pagila sample database is a popular PostgreSQL training database modeled after a movie rental store. It includes tables for films, actors, customers, rentals, staff, payments, and more. This makes it perfect for learning PostgreSQL!
I’ve spent over 20 years optimizing databases and designing rock-solid data systems. Now I’m sharing what I’ve learned to help others build faster, smarter, and more reliable platforms.
