Skip to main content

SQL for analysis for Data Analysts

SQL retrieves and summarises data from databases and is the most tested skill in analyst interviews.

Stage: Spreadsheets and SQL · Part of the Data Analyst roadmap · Last reviewed 19 November 2026

What to learn in SQL for analysis

SQL for analysis interview questions

What is a window function?

A function that calculates across a set of rows related to the current row without collapsing them, such as RANK or running totals.

Where SQL for analysis fits in the Data Analyst roadmap

SQL for analysis belongs to the Spreadsheets and SQL stage. The tools every analyst uses daily.

Back to the full Data Analyst roadmap