---
metadata:
  - name: generator
    content: Diplodoc Platform v5.50.4
alternate:
  - https://ydb.tech/docs/en/dev/yql-tutorial.md
  - https://ydb.tech/docs/ru/dev/yql-tutorial.md
sourcePath: en/core/dev/yql-tutorial/index.md
---
> **Documentation Index:** Fetch the complete configuration index at https://ydb.tech/docs/en/llms.txt


<!-- source: en/dev/yql-tutorial/_includes/index/intro.md -->
# YQL Tutorial - Overview

From this tutorial, you will learn how to perform basic operations with data in YDB and get familiar with the YQL syntax. A detailed description of this syntax is also available in the [YQL reference documentation](https://ydb.tech/docs/en/yql/reference/index.md).
<!-- endsource: en/dev/yql-tutorial/_includes/index/intro.md -->

<!-- source: en/dev/yql-tutorial/_includes/index/steps.md -->
The tutorial consists of 15 steps:

1. [Creating a table](https://ydb.tech/docs/en/dev/yql-tutorial/create_demo_tables.md)
1. [Adding data to a table](https://ydb.tech/docs/en/dev/yql-tutorial/fill_tables_with_data.md)
1. [Selecting data from all columns](https://ydb.tech/docs/en/dev/yql-tutorial/select_all_columns.md)
1. [Selecting data from specific columns](https://ydb.tech/docs/en/dev/yql-tutorial/select_specific_columns.md)
1. [Sorting and filtering](https://ydb.tech/docs/en/dev/yql-tutorial/basic_filter_and_sort.md)
1. [Data aggregation](https://ydb.tech/docs/en/dev/yql-tutorial/basic_aggregation.md)
1. [Additional selection criteria](https://ydb.tech/docs/en/dev/yql-tutorial/conditional_values.md)
1. [Joining tables with JOIN](https://ydb.tech/docs/en/dev/yql-tutorial/join_tables.md)
1. [Inserting and updating data with REPLACE](https://ydb.tech/docs/en/dev/yql-tutorial/replace_into.md)
1. [Inserting and updating data with UPSERT](https://ydb.tech/docs/en/dev/yql-tutorial/upsert_into.md)
1. [Inserting data with INSERT](https://ydb.tech/docs/en/dev/yql-tutorial/insert_into.md)
1. [Updating data with UPDATE](https://ydb.tech/docs/en/dev/yql-tutorial/update.md)
1. [Deleting data](https://ydb.tech/docs/en/dev/yql-tutorial/delete.md)
1. [Adding and deleting columns](https://ydb.tech/docs/en/dev/yql-tutorial/alter_table.md)
1. [Deleting a table](https://ydb.tech/docs/en/dev/yql-tutorial/delete_table.md)
<!-- endsource: en/dev/yql-tutorial/_includes/index/steps.md -->