Skip to main content
Go back
ARISE
← All assessments
Data & AnalyticsIntermediate

SQL & Relational Databases

The SQL every data, backend and analyst interview tests — filtering, joins, aggregation, window functions and design.

20multiple-choice questions
25 mintimed attempt
70%pass mark
2attempts included

SQL is the most requested skill across data analyst, data engineer, backend and BI job listings. This assessment checks that you can predict what a query returns and choose the right construct: NULL behaviour, every join type, GROUP BY and HAVING, subqueries, CTEs and window functions, plus the keys, normalisation, indexes and transactions behind a sound schema.

What it measures

Querying & Filtering

SELECT, WHERE, NULL logic, DISTINCT, ordering and logical query order.

Joins

Inner, left, cross and anti-joins, and where join conditions belong.

Aggregation & Grouping

COUNT/SUM/AVG semantics, GROUP BY and HAVING.

Subqueries & Window Functions

Correlated subqueries, CTEs, ranking and running totals.

Design & Integrity

Keys, normalisation, indexes and ACID transactions.

Who it's for

  • Aspiring data analysts, BI developers and data engineers
  • Backend developers who write queries daily
  • Graduates preparing for SQL interview rounds

How the test works

  • 20 questions drawn at random from a larger bank, balanced across every skill area above.
  • Answer options are shuffled for each candidate, and the timer keeps running once you start.
  • Your answers save automatically. If your connection drops, reopen your link to continue.
  • Score 70% or more to earn a verifiable ARISE certificate. You get 2 attempts.

Try a sample question

Table t has x values 1, 2 and NULL. What does this return?

SELECT COUNT(x) FROM t;

FAQ

Questions about this assessment.