SQL Test
Beginner, Intermediate, Advanced or Expert, scored across four sections rather than one overall guess. Filtering and NULL semantics, joins and set operations, aggregation and subqueries, or window functions/CTEs/transactions/constraints. Fixed score ranges on 30 query-reading questions, so Advanced means the same thing every time the test is taken.
What You'll Discover
🗄️Your SQL level
Beginner, Intermediate, Advanced or Expert, scored across four sections rather than one overall guess
🧩Where the gap actually is
Filtering and NULL semantics, joins and set operations, aggregation and subqueries, or window functions/CTEs/transactions/constraints
🎯What separates the tiers
Fixed score ranges on 30 query-reading questions, so Advanced means the same thing every time the test is taken
Sample Result
🔬 Research & Sources
Job postings ask for SQL experience without saying what that means, and self-rating against nothing is not a measurement. The 30 questions are query-reading, output-prediction and bug-spotting scenarios grouped into the four areas that actually separate skill levels — filtering and NULL semantics, joins and set operations, aggregation and subqueries, and window functions/CTEs/transactions/constraints — and the four tier boundaries are fixed score ranges, so Advanced means the same thing every time the test is taken. No query is written or executed; every question shows a query and asks what it returns, what it does, or what is wrong with it.
Frequently Asked Questions
What does the SQL test cover?
Four areas: filtering and NULL semantics, joins and set operations, aggregation and subqueries, and window functions/CTEs/transactions/constraints. Every question is a short query followed by a question about what it actually returns when it runs, rather than a syntax-recall question.
How is my level determined?
Every question is scored against a single correct answer, and the total places you in one of four tiers: beginner, intermediate, advanced or expert. You also get a per-area breakdown, so a strong overall score still shows you which of the four areas is weaker.
How long does it take?
About 6 minutes. There are 30 questions and no per-question timer, so you can read each query properly. Your result appears the moment you finish.
Do I need to write or run any queries?
No. Every question is read-and-predict — you are shown a query and pick what it actually returns, the same way a senior engineer reviews a pull request. Nothing here requires a database or a query editor.
Do I need a specific SQL dialect?
No. The questions are written against standard SQL behaviour that is shared across PostgreSQL, MySQL, SQL Server and SQLite, so the answer does not change with your specific database engine.
Can employers use this for hiring?
Yes. Strong SQL is one of the most common requirements in engineering, data and analytics postings and one of the least defined, so a scored breakdown by area is more useful than a line on a CV. Employers can send this test to candidates from the JobCannon for business page.