Domain: BigQuery

BigQuery

GoogleSQL query reference across fundamentals, advanced patterns, and engineering — from schema exploration through partitioning strategies.

mindmap
  ((BigQuery))
    (fundamentals)
    (advanced patterns)
    (engineering)

BigQuery Fundamentals

• Schema exploration
• Aggregation and GROUP BY
• JOINs across medallion layers
• Window functions
• CTEs and subqueries
• Data quality checks

BigQuery Advanced

• Advanced window functions
• Recursive CTEs
• Pivot and unpivot
• MERGE upsert
• Grouping sets and rollup
• NULL handling patterns

BigQuery Engineering

• Views
• Stored procedures
• Indexes
• Slowly changing dimensions
• Execution plans and optimization
• Partitioning strategies