Advanced SQL for analysts is different than advanced SQL for other tasks (like DBAs). I will be concentrating on SQL that will be useful to you as an analyst. This is not an exhaustive list of SQL functions and features, but ones that I have found useful in my work as an analyst.
With BigQuery, you can store data securely with high performance and nearly unlimited growth. It is perfect for data analysis.