Hello everyone. Step right up and take the SQL Quiz challenge!
Click the above link to take the challenge; read below to review my notes and ramblings.
First, I’ve written hundreds of advanced SQL quiz questions that you can use in your learning adventure. This collection is a great asset for identifying gaps in your expertise, preparing for interviews, or sourcing new questions for your own interviews.
Please let me know if you find any bugs, misspellings, grammar issues, formatting problems, or if you disagree with a quiz question or answer. No detail is too small.
If you are on the hunt for genuine SQL or database certifications, be sure to check out my blog post here. There, I’ve compiled a comprehensive list of various certifications available in the field.
If you are looking for a collection of SQL puzzles to solve, I have a GitHub repository here.
For the provided quiz, there is a full-screen mode if you click on the icon in the upper right corner once you start a quiz. If you happen to retake the quiz and get the same question bank, try refreshing your webpage cache.
Also, each vendor has slightly different nuances to their SQL, and I’ve tried to make this as ANSI compliant as possible, but use your best judgment when reviewing the SQL statements. Different vendors treat the VALUES constructor differently, and some vendors require the use of a dummy table (like Oracle’s dual table), etc…
I’d like to thank db<>fiddle (dbfiddle.uk) for providing an excellent platform to execute statements across various databases to verify results.
Additionally, I administered my quiz to ChatGPT, which managed to answer the questions with an accuracy rate of 86%.
Lastly, I want to thank everyone for their help in creating this quiz. It certainly took me some time to write, edit, re-edit, figure out the Quizmaker app in WordPress, meta tag, re-edit, and overall get everything correct. Hope you enjoy taking the quiz as much as I enjoyed writing it.
Happy coding!