Mo Tianlun openGauss free online SQL test virtual machine

Motianlun online training platform V1.0 is released. It provides a deployed database online environment for free. You can open the browser for learning anytime and anywhere and connect to the Linux WEB terminal with one click. At present, it supports Oracle, MySQL, Redis, PostgreSQL, openGauss and MogDB.

Adhering to the vision of knowing and enjoying together, we are now open to technology lovers to apply for free for 90 days: ink Sky Wheel - > cloud market - > cloud resources https://www.modb.pro/marketlist?type=1

The following is the openGauss training environment. You can use the chrome browser to connect to the command line terminal of the underlying operating system, learn the operating system commands, and connect to the database for any operation, test and experiment.

At the same time, Oracle's classic HR learning example Schema is adapted to all databases. After rapid initialization, you can learn relevant object design and SQL. Refer to HR Schema for openGauss for detailed initialization script https://www.modb.pro/db/100652

omm=# \d
                                List of relations
 Schema |       Name       |   Type   | Owner |             Storage              
--------+------------------+----------+-------+----------------------------------
 public | countries        | table    | omm   | {orientation=row,compression=no}
 public | departments      | table    | omm   | {orientation=row,compression=no}
 public | departments_seq  | sequence | omm   | 
 public | emp_details_view | view     | omm   | 
 public | employees        | table    | omm   | {orientation=row,compression=no}
 public | employees_seq    | sequence | omm   | 
 public | job_history      | table    | omm   | {orientation=row,compression=no}
 public | jobs             | table    | omm   | {orientation=row,compression=no}
 public | locations        | table    | omm   | {orientation=row,compression=no}
 public | locations_seq    | sequence | omm   | 
 public | regions          | table    | omm   | {orientation=row,compression=no}
(11 rows)

omm=# select count(*) from employees;
 count 
-------
   107
(1 row)

omm=# 

Please use it. If you need other resources, you can leave comments. We will give priority to support. Motianlun online training platform V1.0 is released. It provides a deployed database online environment for free. You can open the browser for learning anytime and anywhere and connect to the Linux WEB terminal with one click. At present, it supports Oracle, MySQL, Redis, PostgreSQL, openGauss and MogDB.

Adhering to the vision of knowing and enjoying together, we are now open to technology lovers to apply for free for 90 days: ink Sky Wheel - > cloud market - > cloud resources https://www.modb.pro/marketlist?type=1

The following is the openGauss training environment. You can use the chrome browser to connect to the command line terminal of the underlying operating system, learn the operating system commands, and connect to the database for any operation, test and experiment.

At the same time, Oracle's classic HR learning example Schema is adapted to all databases. After rapid initialization, you can learn relevant object design and SQL. Refer to HR Schema for openGauss for detailed initialization script https://www.modb.pro/db/100652

omm=# \d
                                List of relations
 Schema |       Name       |   Type   | Owner |             Storage              
--------+------------------+----------+-------+----------------------------------
 public | countries        | table    | omm   | {orientation=row,compression=no}
 public | departments      | table    | omm   | {orientation=row,compression=no}
 public | departments_seq  | sequence | omm   | 
 public | emp_details_view | view     | omm   | 
 public | employees        | table    | omm   | {orientation=row,compression=no}
 public | employees_seq    | sequence | omm   | 
 public | job_history      | table    | omm   | {orientation=row,compression=no}
 public | jobs             | table    | omm   | {orientation=row,compression=no}
 public | locations        | table    | omm   | {orientation=row,compression=no}
 public | locations_seq    | sequence | omm   | 
 public | regions          | table    | omm   | {orientation=row,compression=no}
(11 rows)

omm=# select count(*) from employees;
 count 
-------
   107
(1 row)

omm=# 

Please use it. If you need other resources, you can leave comments. We will give priority to support.

Tags: Database SQL

Posted on Wed, 27 Oct 2021 23:35:23 -0400 by McChicken