Explore Yugabyte SQL
After creating a Sandbox cluster and connecting to the cluster using Cloud Shell, you can start exploring YugabyteDB's PostgreSQL-compatible, fully-relational Yugabyte SQL API.
When you connect to your cluster using Cloud Shell with the YSQL API, the shell window incorporates a quick start guide, with a series of pre-built queries for you to run.
Run the tutorial
After entering your password, do the following to start the tutorial (creating a database is optional):
Create a database
While optional, it's good practice to create separate databases for different applications.
To create a database, enter the following command:
yugabyte=> CREATE DATABASE yb_demo;
Next, connect to the new database using the ysqlsh \c
meta-command:
yugabyte=> \c yb_demo;
Create tables and insert data
Begin the tutorial by selecting the steps in the left navigation panel, then clicking the Run button for the corresponding SQL statements. The tutorial starts with the following tasks:
- Create a Table.
The tutorial database includes two tables:dept
for Departments, andemp
for Employees. The employees table references the departments table through a foreign key constraint. The employees table also references itself through a foreign key constraint to ensure that an employee's manager is in turn an employee themselves. The table uses these constraints to ensure integrity of data, such as uniqueness and validity of email addresses. - Insert Data.
Data is added to the tables using multi-value inserts to reduce client-server round trips.
After you create the tables and insert the data, click Let's get started with the tutorials to begin the tutorial scenarios.
Quick start scenarios
The quick start includes the following scenarios:
Scenario | Description |
---|---|
Basics | |
SQL Updates | Update the salary of all employees who are not managers and display the new results. |
Join | List all employees earning more than their managers using a self-join query. |
Prepared Statements | Get the salary for an employee using a prepared statement. |
Indexes | Create and analyze an index on the fly. |
Recursive Queries | List the manager hierarchy using a recursive query. |
Built-in Functions | |
Window Functions | Compare employee hiring time interval by department using an analytical window function. |
Regexp Matching | List all employees matching Gmail and org email domains using regular expressions for text pattern matching. |
Arithmetic Date Intervals | Find employees with overlapping evaluation periods using arithmetic date intervals. |
Crosstab view | Display the sum of salary per job and department as a cross table. |
ntile Function | Split e-mails into 3 groups and format them. |
Advanced Features | |
GIN Index | Query employee skills using a GIN index on a JSON document. |
Text Search Index | Create a GIN text search index on the description column and query for words. |
Stored Procedures | Transfer a commission from one employee to another using a stored procedure. |
Triggers | Record the last update time of each row automatically. |
Materialized Views | Pre-compute analytics for reporting using a materialized view. |
To run this tutorial from your desktop shell, refer to Explore Yugabyte SQL in the Core Quick Start.