KNOWLEDGE YOU CAN PUT TO WORK
Practical Data Skills for the Real World
Practical guides, real-world lessons and interview preparation for Data Engineers, Analytics Engineers, BI Developers and Data Analysts.
FROM DATA TO DECISIONS
01 / Build the foundation
Data engineering
02 / Make it meaningful
Analytics engineering
03 / Turn it into insight
BI & analytics
Less theory in isolation. More understanding in practice.
Data in Practice HQ is a growing library of practical data knowledge. Explore how data systems, SQL, analytics and engineering concepts work in real-world situations and build the confidence to apply and explain what you know.
Featured Resources
WORKBOOK / INTERVIEW PREPARATION
SQL Interview Practice
50 real-world SQL challenges designed to help Data Engineers, Analytics Engineers, BI Developers and Data Analysts practise, reason through and explain SQL confidently in interviews.
50 real-world SQL challenges · Worked SQL solutions · Interview guidance · 20 quick-fire questions · PostgreSQL and Athena/Trino examples
Latest Articles
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