# For Users

- [Query](/release-0.12.1/users/user-guide-query.md): Learn how to query Apache Pinot using SQL or explore data using the web-based Pinot query console.
- [Querying Pinot](/release-0.12.1/users/user-guide-query/querying-pinot.md): Learn how to query Pinot using SQL
- [Aggregation Functions](/release-0.12.1/users/user-guide-query/supported-aggregations.md)
- [Transformation Functions](/release-0.12.1/users/user-guide-query/supported-transformations.md): This document contains the list of all the transformation functions supported by Pinot SQL.
- [User-Defined Functions (UDFs)](/release-0.12.1/users/user-guide-query/scalar-functions.md)
- [Grouping Algorithm](/release-0.12.1/users/user-guide-query/grouping-algorithm.md)
- [Query Options](/release-0.12.1/users/user-guide-query/query-options.md): This document contains all the available query options
- [Cardinality Estimation](/release-0.12.1/users/user-guide-query/how-to-handle-unique-counting.md)
- [Lookup UDF Join](/release-0.12.1/users/user-guide-query/lookup-udf-join.md)
- [Querying JSON data](/release-0.12.1/users/user-guide-query/json-queries.md)
- [Filtering with IdSet](/release-0.12.1/users/user-guide-query/filtering-with-idset.md): Learn how to write fast queries for looking up ids in a list of values.
- [Explain Plan](/release-0.12.1/users/user-guide-query/explain-plan.md)
- [GapFill Function For Time-Series Dataset](/release-0.12.1/users/user-guide-query/gap-fill-functions.md)
- [APIs](/release-0.12.1/users/api.md)
- [Broker Query API](/release-0.12.1/users/api/querying-pinot-using-standard-sql.md)
- [Query Response Format](/release-0.12.1/users/api/querying-pinot-using-standard-sql/response-format.md)
- [Controller Admin API](/release-0.12.1/users/api/pinot-rest-admin-interface.md)
- [Controller API Reference](/release-0.12.1/users/api/controller-api-reference.md): All user APIs available in Pinot
- [External Clients](/release-0.12.1/users/clients.md)
- [JDBC](/release-0.12.1/users/clients/jdbc.md)
- [Java](/release-0.12.1/users/clients/java.md)
- [Python](/release-0.12.1/users/clients/python.md)
- [Golang](/release-0.12.1/users/clients/golang.md): Pinot Client for Golang
- [Tutorials](/release-0.12.1/users/tutorials.md)
- [Use OSS as Deep Storage for Pinot](/release-0.12.1/users/tutorials/use-oss-as-deep-storage-for-pinot.md): Configure AliCloud Object Storage Service (OSS) as Pinot deep storage
- [Ingest Parquet Files from S3 Using Spark](/release-0.12.1/users/tutorials/ingest-parquet-files-from-s3-using-spark.md)
- [Creating Pinot Segments](/release-0.12.1/users/tutorials/create-pinot-segments.md)
- [Use S3 as Deep Storage for Pinot](/release-0.12.1/users/tutorials/use-s3-as-deep-store-for-pinot.md)
- [Use S3 and Pinot in Docker](/release-0.12.1/users/tutorials/use-s3-and-pinot-in-docker.md)
- [Batch Data Ingestion In Practice](/release-0.12.1/users/tutorials/batch-data-ingestion-in-practice.md)
- [Schema Evolution](/release-0.12.1/users/tutorials/schema-evolution.md)