SQL Arena
Track · Analyst

BigQuery for analysts

The BigQuery dialect: arrays and structs instead of plain rows, partitioning that decides what a query costs, and window functions on top.

32 tasks~10 h4 modules

Track program

4 modules
  1. 1
    Module 1

    First queries

    8 tasks
  2. 2
    Module 2

    Aggregates and grouping

    8 tasks
  3. 3
    Module 3

    Arrays, JSON and structs

    8 tasks
  4. 4
    Module 4

    Partitioning and windows

    8 tasks

Who it's for

A track for data analysts. Tasks run from the basics to the advanced, grading is automatic, and both PostgreSQL and MySQL are supported.

Back to tracks