Ideas, explained in practice.
Practical articles on data engineering, analytics engineering, SQL, data modelling, BI, AWS/Athena, cloud tools and interview preparation.
From the library
SQL
ROW_NUMBER vs RANK vs DENSE_RANK: What’s the Difference?
Understand how the three SQL window functions behave, when to use each one, and the differences interviewers expect you to explain.
Read article
Data Engineering
SCD Type 2 for Data Engineers: How a Customer Tier Change Broke Historical Reporting
Learn how SCD Type 2 preserves customer history and fixes misleading reports, with practical PostgreSQL examples, point-in-time joins and tested SQL validation checks.
Read article