Overview

From this tutorial, you will learn how to perform basic operations with data in YDB and get familiar with the YQL syntax. Create a database and follow all the steps in the management console, copying the YQL instructions to the Query field.

The tutorial consists of 15 steps:

1. Creating a table
2. Adding data to a table
3. Selecting data from all columns
4. Selecting data from specific columns
5. Sorting and filtering
6. Data aggregation
7. Additional selection criteria
8. Joining tables by JOIN
9. Data insert and update by REPLACE
10. Data insert and update by UPSERT
11. Data insert by INSERT
12. Data update by UPDATE
13. Deleting data
14. Adding and deleting columns
15. Deleting a table