{"id":2068,"date":"2020-04-05T19:17:34","date_gmt":"2020-04-06T02:17:34","guid":{"rendered":"https:\/\/sqltutorial.org\/?page_id=2068"},"modified":"2020-04-05T19:54:44","modified_gmt":"2020-04-06T02:54:44","slug":"sql-sample-database","status":"publish","type":"page","link":"https:\/\/www.sqltutorial.org\/sql-sample-database\/","title":{"rendered":"SQL Sample Database"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn about a SQL Sample Database called HR that manages the HR data of the small businesses.<\/p>\n\n\n\n

The following database diagram illustrates the HR sample database:<\/p>\n\n\n\n

\"SQL<\/figure>\n\n\n\n

The HR sample database has seven tables:<\/p>\n\n\n\n

  1. The employees<\/code> table stores the data of employees.<\/li>
  2. The jobs<\/code> table stores the job data including job title and salary range.<\/li>
  3. The departments<\/code>\u00a0table stores department data.<\/li>
  4. The dependents<\/code> table stores the employee’s dependents.<\/li>
  5. The locations<\/code> table stores the location of the departments of the company.<\/li>
  6. The countries<\/code> table stores the data of countries where the company is doing business.<\/li>
  7. The regions<\/code> table stores the data of regions such as Asia, Europe, America, and\u00a0the Middle East and Africa. The countries are grouped into regions.<\/li><\/ol>\n\n\n\n

    The following picture shows the table names and their records.<\/p>\n\n\n\n

    Table<\/th>Rows<\/th><\/tr><\/thead>
    employees<\/td>40<\/td><\/tr>
    dependents<\/td>30<\/td><\/tr>
    departments<\/td>11<\/td><\/tr>
    jobs<\/td>11<\/td><\/tr>
    locations<\/td>7<\/td><\/tr>
    countries<\/td>25<\/td><\/tr>
    regions<\/td>4<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

    Typically, you need to install a Relational Database Management System (RDBMS) to work with SQL.<\/p>\n\n\n\n

    If you have worked with an RDBMS such as MySQL, PostgreSQL, Oracle Database, and SQL Server, you can use the following script to create the sample database in one of these databases.<\/p>\n\n\n\n

    In case you don’t have a database system to practice, you can quickly use our SQL online tool to execute the SQL statements in your web browser.<\/a><\/p>\n\n\n\n

    MySQL #<\/a><\/h2>\n\n\n\n

    The following SQL script creates the HR sample database in MySQL:<\/p>\n\n\n\nCreate HR Sample Database in MySQL<\/a>\n\n\n\n

    The following script allows you to insert data into the tables in MySQL:<\/p>\n\n\n\nLoad HR Data in MySQL<\/a>\n\n\n\n

    PostgreSQL #<\/a><\/h2>\n\n\n\n

    The following script creates the HR sample database structure in PostgreSQL.<\/p>\n\n\n\nCreate HR Sample Database in PostgreSQL<\/a>\n\n\n\n

    The following script allows you to insert data into the tables in PostgreSQL:<\/p>\n\n\n\nLoad HR Data in PostgreSQL<\/a>\n\n\n\n

    Microsoft SQL Server #<\/a><\/h2>\n\n\n\n

    The following script creates the HR sample database structure in Microsoft SQL Server.<\/p>\n\n\n\nCreate HR Sample Database in SQL Server<\/a>\n\n\n\n

    The following script allows you to insert data into the tables:<\/p>\n\n\n\nLoad HR Data in SQL Server<\/a>\n\n\n\n

    Oracle Database (>12c) #<\/a><\/h2>\n\n\n\n

    The following script creates the HR sample database structure in Oracle Database 12c.<\/p>\n\n\n\nCreate HR Sample Database in Oracle<\/a>\n\n\n\n

    The following script inserts data into the tables in the Oracle database:<\/p>\n\n\n\nLoad HR Data in Oracle Database<\/a>\n\n\n\n

    SQLite #<\/a><\/h2>\n\n\n\n

    The following script creates the HR sample database structure in SQLite.<\/p>\n\n\n\nCreate HR Sample Database in SQLite<\/a>\n\n\n\n

    The following script inserts data into the tables in the SQLite:<\/p>\n\n\n\nCreate HR Sample Database in SQLite<\/a>\n\n\n\n

    Removing tables #<\/a><\/h2>\n\n\n\n

    The following is the script that drops all tables in case you want to refresh the sample database.<\/p>\n\n\n\nDrop All Tables<\/a>\n

    \n\t
    \n\t\t
    Was this tutorial helpful ?<\/div>\n\t\t
    \n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
    \n\t\t
    \n\t\t\t
    <\/div>\n\t\t\t\n\t\t\t