The demo data for the SQL Tutorial represents an extremely basic hotel administration system with information on the hotel’s visitors, location, vacancies, room prices, and so on. The basic demo data is sufficient for you to understand all the examples in this SQL Tutorial.
Note
You can change the basic demo data to suit your needs. However, your results may then deviate from the example results given in this tutorial.
Install the database software and tools. To do so, proceed as described in your installation documentation. For more information, see Glossary, Installation.
Create the demo database DEMODB. Do NOT load all of the demo data. You can use Database Studio or Installation Manager to create the demo database (See also: Glossary, Installation Manager).
Database Studio, Creating the Database
Database Administration, Creating and Configuring a Database
You can use a number of tools to execute the SQL statements (Database Studio, SQLCLI, Loader etc.).
The following sections describe how to enter the SQL statements for creating the database user MONA with the Database Studio.
Log on to the demo database DEMODB as a database system administrator using the Database Studio (Logging on to a Database). If you transferred the default values when creating the demo database DEMODB, the database system administrator will contain the following user data: name of the database system administrator: DBADMIN, password: SECRET
Use the Database Studio to create the database user MONA with the following SQL statement (Working with SQL Statements: Overview):
CREATE USER mona PASSWORD red DBA NOT EXCLUSIVE
The following sections explain how to execute the SQL statements specified for the HOTEL demo schema for creating the database objects and their contents (basic demo data) with the Database Studio.
Log on to the demo database DEMODB as the database user MONA with the password RED using the Database Studio (Logging on to a Database).
Create the HOTEL demo schema and the required tables and fill these with values using the Database Studio (Entering and Executing SQL Statements). Use the SQL statements as specified in SQL Statements for the HOTEL Demo Schema to create the basic demo data.
The database user MONA has been created in the demo database DEMODB as a database administrator (DBA) with the password RED. The database administrator MONA can open several database sessions at once (NOT EXCLUSIVE). The HOTEL demo schema has been created. A series of simply-structured tables have been assigned to the HOTEL demo schema. The tables are filled with basic demo data.
Note
If you want to learn to administer databases using the DEMODB or test SQL statements or Loader commands using existing demo data, you can load the complete set of demo data into the database DEMODB by executing specified scripts. To load the complete demo data in this case, select the corresponding Load Tutorial option when creating a database in the Installation Manager or in the Database Studio.
Explanation of the Tables in the HOTEL Demo Schema
Concepts of the Database System, Demo Database, Objects in the HOTEL Schema