BigQuery

1. What is BigQuery

   Serverless data warehouse architecture and capabilities.

2. Storage Overview

   Columnar storage, Capacitor and storage billing.

3. Datasets and Tables

   Datasets, tables, views and table types.

4. Loading Data

   Batch loading, streaming and the Storage Write API.

5. Running Queries

   Query jobs, interactive versus batch, and GoogleSQL.

6. Partitioned Tables

   Time-unit, ingestion-time and integer-range partitioning.

7. Clustered Tables

   Clustering to prune data and speed queries.

8. Materialized Views

   Precomputed views with smart tuning.

9. Slots and Reservations

   On-demand versus capacity-based compute pricing.

10. Query Performance Best Practices

    Reducing bytes scanned and optimizing queries.

11. Cost Controls

    Estimating and controlling query and storage costs.

12. Access Control

    IAM roles, row and column-level security.

13. BigQuery ML

    Creating and using ML models with SQL.

14. Quotas and Limits

    Job, query and API quotas.

Each section links to the official page. Titles and summaries by Extra Credit; the docs belong to their authors.