Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm looking for beginner and intermediate level SQL puzzles, that I can point trainees at for practice.

I'm aware of http://sqlzoo.net/ which is a great resource - is there anything else out there that you could suggest?

share|improve this question
add comment

7 Answers 7

up vote 28 down vote accepted

Joe Celko's books and newsgroup posts are a good source of puzzles (with a variety of answers). They might be a bit more intermediate/advanced and not MySQL-specific, but are easy to follow and generally come from practical real-world situations.

Particularly, hunt down a copy of Joe Celko's SQL Puzzles and Answers (link to Google preview), it's a compilation of some of the best.

The SQLTeam forums occasionally have some interesting problems too, but generally focused on MS SQL Server.

share|improve this answer
    
+1 for very cool answer. –  Soner Gönül Dec 18 '12 at 22:55
add comment

There are lots of interesting puzzles and contests in BeyondRelational.Com

TSQL Challenges
TSQL Beginners Challenge

share|improve this answer
    
Are solutions posted anywhere for the beginners challenges? –  Gabe Feb 21 '11 at 0:38
add comment

SQL Server Central has some quizzes here:

http://www.sqlservercentral.com/tags/T-SQL/SQL+Puzzles/

There's also SQL Quiz, which is more like quiz questions rather than puzzles:

http://www.sqlquiz.com/

And Lessthandot has some general programmer puzzles:

http://forum.lessthandot.com/viewforum.php?f=102

share|improve this answer
add comment

You can sign up for SQLServerCentral's Newsletter and receive a Question of the Day (among other news and articles) in your mailbox daily.

One thing to note is that in addition to SQL, the questions also focus on database administration. They are pretty challenging though.

share|improve this answer
add comment

Practical skills of SQL language has a good collection of exercises for beginners as well as for experienced programmers.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.