In class we go through a few examples using SQL in various ways. Assignments let you practice a bit, but to really learn something, you need to work with it a bit. Even better if it's fun!
SQL games:
- https://mystery.knightlab.com/ (SQL Murder Mystery)
- https://sql-island.informatik.uni-kl.de/ (SQL Island, in german, but menu let's you change language, 4th button down)
- https://www.sqlnoir.com/ (SQL Noir)
- https://datalemur.com/sql-game (SQL Squid Game)
- https://sqlpd.com/ (SQL Police Department, $$ but try for free)
- https://lost-at-sql.therobinlord.com/ (Lost at SQL)
- https://schemaverse.com (Space strategy game)
- https://codepip.com/games/querymon/ (Pokemon themed)
Not games but things to try:
- https://datalemur.com/sql-interview-questions
- Claims to be real interview questions from various companies that require you to write SQL code
- https://selectstarsql.com
- Leads you through scenarios
- https://www.codingame.com/learn/sql
- A couple of SQL puzzles and a lot of other coding puzzles
- https://www.w3schools.com/sql/sql_exercises.asp
- Various SQL exercises. Lots of other SQL resources too.