What interviewers are testing
SQL rounds are rarely trivia. Interviewers want to see whether you can turn a business question into a correct query and explain the grain of the table.
Patterns that keep coming back
Practice these until you can write them without looking up syntax. Talk through the result as you type.
- Inner and left joins, and when a left join silently duplicates rows.
- GROUP BY with HAVING for thresholds such as customers above a spend.
- Window functions: running totals, rank within a category, and lag for period-over-period.
- CTEs to keep a multi-step question readable.
- A short note on NULL: filters and aggregates do not treat it like zero.
How to practise
Take one table from a portfolio project and rewrite the same metric three ways. In the Data Analytics Course, SQL practice is tied to the same datasets you later visualise, so the interview story and the project stay consistent.




