Sql syntax reference
https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax
functions reference
https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators
best practices next talk
https://www.youtube.com/watch?v=ZVgt1-LfWW4
query optimization
https://cloud.google.com/bigquery/docs/best-practices-performance-compute
clustering and partitioning
https://cloud.google.com/bigquery/docs/clustered-tables
Query plan like explain statement
https://cloud.google.com/bigquery/docs/query-plan-explanation
Detailed use-case articles