# Guides

These guides complete concrete tasks with CoordinatorDB syntax and examples. They cover data exchange, schema choices, arrays and joins, partial aggregation and query observation.

Use the [reference](https://coordinatordb.com/docs/reference/home) for exact grammar, value ranges, format settings and error contracts. Each guide states the source files, tables or interface it needs.

## Guides

::: cards

* [Data formats](https://coordinatordb.com/docs/guides/clickhouse/data-formats/intro)
* [Data modelling](https://coordinatordb.com/docs/guides/clickhouse/data-modelling)
* [Performance & monitoring](https://coordinatordb.com/docs/guides/clickhouse/performance-and-monitoring/query-optimization)
* [Aggregate combinator examples](https://coordinatordb.com/docs/guides/clickhouse/examples/aggregate-function-combinators/avg-if)
  :::