Hi Amnol,
I'd disagree that functions like CAST and CONCAT are "advanced", I used this quite early and frequently in my own analytics career. One call out ;)
Otherwise, it's a great intro / summary of useful SQL functions. Where would you recommend readers go from here? (ie. next step / best references)
Cheers!
Magnus