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 in Practice HQ

Practical data knowledge you can put to work.

© 2026 Data in Practice HQ