For learning a bit more about SQL, I'm a big fan of Philip Greenspun's SQL for Web Nerds. It may be written in terms of Oracle, but the earlier chapters are fairly generic across different SQL dialects and I found it very well written.

The chapter which covers simple queries up to joins is here.