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?
|
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? |
||||
|
|
|
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. |
||||
|
|
|
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: And Lessthandot has some general programmer puzzles: |
||||
|
|
|
There are lots of interesting puzzles and contests in BeyondRelational.Com |
||||
|
|
|
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. |
||||
|
|
|
Practical skills of SQL language has a good collection of exercises for beginners as well as for experienced programmers. |
||||
|
|
|
One that I've used before is: http://www.sql-tutorial.ru/en Has an interactive book with exercises (and tips) and solutions |
||||
|
|
|
Found these |
||||
|
|