[Yandex Cloud documentation](../../index.md) > [Yandex Query](../index.md) > Working with YQL > Overview

# Using Yandex Query Language syntax in Yandex Query

In this tutorial, you will learn how to use Yandex Query Language syntax and perform data operations in Yandex Query with [analytical](#analytical-query) and [streaming](#stream-query) query examples.

All examples use a ready-made dataset containing New York City taxi trips from 2019 to 2021.

{% note info %}

Yandex Cloud provides the **New York City taxi trips** dataset as is. Yandex Cloud makes no express or implied representations, warranties, or conditions pertaining to your use of the specified dataset. To the extent permitted by your local law, Yandex Cloud shall not be liable for any loss or damage, including direct, indirect, consequential, special, incidental, or punitive, resulting from your use of the dataset.

NYC Taxi and Limousine Commission (TLC):

The data was collected and provided to the NYC Taxi and Limousine Commission (TLC) by technology providers authorized under the Taxicab & Livery Passenger Enhancement Programs (TPEP/LPEP). The taxi trip data was not created by the TLC, and the TLC makes no representations whatsoever about the accuracy of this data.

Please review the dataset’s original [source](https://www1.nyc.gov/site/tlc/about/tlc-trip-record-data.page) and its [terms of use](https://www1.nyc.gov/home/terms-of-use.page).

{% endnote %}

## Analytical query example {#analytical-query}

To create an analytical query and get started:

1. In the [management console](https://console.yandex.cloud), select the folder where you want to create a connection.
1. In the list of services, select **Yandex Query**.
1. In the left-hand panel, select ![study](../../_assets/console-icons/graduation-cap.svg) **Tutorial**.
1. Click **Create connection**. In the Create connection section, all the parameter fields are pre-filled. Just enter an optional description and click **Create**. You will see the Create data binding screen.
1. Enter the optional data binding description and click **Create**. This will create the resources required for this tutorial.

From the list on the left-hand panel, select a tutorial section:

1. [Selecting all columns](select-all-columns.md).
1. [Selecting specific columns](select-specific-columns.md).
1. [Sorting and filtering](sort-filter.md).
1. [Data aggregation](basic-aggregation.md).
1. [Aggregation conditions](conditional-values.md).
1. [JSON](json.md).

## Streaming query example {#stream-query}

To create a streaming query and get started:

1. In the [management console](https://console.yandex.cloud), select the folder where you want to create a connection.
1. In the list of services, select **Yandex Query**.
1. In the left-hand panel, select ![study](../../_assets/console-icons/graduation-cap.svg) **Tutorial**.
1. Select `Streaming`.
1. Click **Create connection**. In the `create connection` section, some settings are pre-filled.
1. Select an existing database or create a new one.
1. Select an existing service account or create a new one.
1. Click **Create**. You will see the `create data binding` screen.
1. Select an existing data stream or create a new one.
1. Enter the optional data binding description and click **Create**. This will create the resources required for this tutorial.

From the list on the left-hand panel, select a tutorial section:

1. [Querying real-time data](streaming-query.md).

#### Useful links {#see-also}

[YQL syntax](https://ydb.tech/docs/en//yql/reference/syntax/)