Beginner — Your SQL Skill Level
You can write a working SELECT, but NULL handling and join mechanics are the gap
Beginner is the band where writing a working SELECT statement and filtering on a few conditions already works, but the questions that get missed cluster around NULL handling and join mechanics rather than syntax.
Comparing a column to NULL with =, what LEFT JOIN actually preserves, how BETWEEN's boundaries work — none of that is about being bad at databases. These are the specific rules that trip up people who learned SQL by trial and error rather than from the standard, and they matter at work because each one is where a query returns a plausible-looking but wrong row count.
Strengths
- You can write a working SELECT statement and filter on a few conditions without hesitating.
- You read an existing query and can follow what it is doing, even without owning the schema behind it.
- The mistakes that remain are specific SQL rules, not a general difficulty reasoning about data.
- You have enough vocabulary to follow a query someone else wrote or a code review comment about one.
- The gap ahead is narrow and nameable, not a broad "learn databases from scratch" problem.
Growth Edges
- WHERE col = NULL is a live trap until you have seen it silently return zero rows once.
- INNER JOIN and LEFT JOIN look interchangeable in simple cases and are not — one drops unmatched rows, the other keeps them.
- BETWEEN's boundaries are inclusive on both ends, which is easy to get backwards under time pressure.
- Nothing yet distinguishes a query that returns the right rows from one that returns the right row COUNT, so silent row inflation is still a surprise.
- Reading an existing query is comfortable; writing a new multi-table report from a blank editor is a different, not-yet-practiced skill.
Career Matches
Compare
Frequently Asked Questions
What does a Beginner SQL result mean?
It means basic query-writing is already there, but a handful of specific rules — NULL comparisons, what LEFT JOIN preserves, BETWEEN's boundaries — are still catching you out.
What should I learn next from this band?
The shipped next steps, in order: why WHERE col = NULL never matches (IS NULL is required instead), how INNER JOIN drops unmatched rows while LEFT JOIN keeps them, and the exact boundaries BETWEEN includes.
Why does WHERE age = NULL return zero rows?
Comparing anything to NULL with = produces UNKNOWN, never TRUE — SQL treats NULL as "unknown value," not as a value you can equal. IS NULL is the operator built specifically to test for it.
What is the difference between INNER JOIN and LEFT JOIN?
INNER JOIN returns only rows with a match in both tables. LEFT JOIN returns every row from the left table, filling in NULLs for columns from the right table when there is no match — so the row counts can differ sharply on the same data.
How is the SQL Test scored?
30 scenario questions across four areas — filtering and NULL semantics, joins and set operations, aggregation and subqueries, and window functions, CTEs and constraints. Your band comes from the total, and the breakdown is shown by category.
Is this a certified SQL qualification?
No. This is a self-check that places you in one of four bands so you know what to learn next. It is not a certification and it is not a validated assessment instrument.
Explore all results in depth
Already taken the test, or just curious? Read the in-depth guide for any result — strengths, challenges, career matches, famous people, and FAQs.
Results Library content is educational, not a clinical assessment.