33 SQL Interview Questions and How to Answer Them

33 SQL Questions and How to Answer Them is the result of almost a year of job-seeking, interviewing and facing technical assessments, plus twenty years in the industry working with SQL daily.

If you're on the lookout for a new role in data, there's a very high chance that they'll be asking for some level of SQL knowledge.

Whether that's a very basic level, intermediate or an advanced level depends on the role you're applying for. Will you need to know about performance, data management, database design & development, or will it just be extracting data from a database?

Had you even considered these questions before?

Well this guide which comes on the back of the most challenging year of my professional career, should help you prepare.

There are 33 (35 actually) questions ranging from the very simple, to some seriously advanced stuff, plus some non-SQL related logic questions. Almost all of these come from personal experience, so as well as the questions you're also learning...

• What they're hoping to learn about you from your answer
• The types of job that you're applying for which might prompt these questions
• The answers (or at least some good suggestions, where there could be multiple correct answers)

So if your goal over the coming months is to get a new job in data, downloading this could well be the best thing you do.

Best thing is, it's free for the first month, so get in there quickly and you can't lose.

Thanks,

Nick Holt, Feb 2026