(self plug) for coursework on the read-only SQL side, you might want to give http://pgexercises.com a try. I have ambitions to expand it to include arrays and json, but alas haven't found the time so far...