SQL practice
Comes up in: Backend design, Customer scenario, AI engineering
This concept is being written. It gets the full five steps — explanation, predict, interview angle, practice with tests, and review cards. Here is exactly what it will cover, so you can study it elsewhere in the meantime.
What it covers
- JOIN types
- GROUP BY and HAVING
- subqueries and CTEs
- window functions (ROW_NUMBER, RANK, running totals)
- NULL handling
- reading query plans (EXPLAIN) at a basic level
Words you will know
What you will practise
- 15 query problems on a sample schema (runs in SQLite in the browser)