Congrats on learning SQL on your own. I'm self-taught as well. I would add EXISTS/NOT EXISTS to your list of essentials. I use them all the time.