RU

3. Database

Task

To kickstart your practical SQL querying assignments, you'll first need to set up your environment. This involves downloading and installing DBeaver Community Edition (CE), a powerful and free tool, then opening the database file carefully prepared by the RealBugs team.

Please follow the dedicated setup instructions provided below to install DBeaver and open your eldoria_v2.db database.

Once your database is ready, click the 'Let's go!' button and head over to the assignments page. There, you can start submitting your queries to the database and retrieve the required answers. Don't worry about accidentally deleting or modifying anything — you can always re-download the database file from the website if you need a fresh start!

Instructions

  1. Go to the official DBeaver website: www.dbeaver.io/download/
  2. On the download page, identify and select the latest DBeaver Community Edition (free version) installer that is compatible with your operating system.
  3. Install DBeaver: Execute the downloaded installer file. Follow the on-screen prompts to complete the installation process.
  4. Download the database file: eldoria_v2.db. This file contains all the tables and data you will need. Make sure to save it to a location you can easily access on your computer.
  5. Launch DBeaver.
  6. Open the downloaded database file in DBeaver:
    • In DBeaver, click on the 'File' 👉 'Open file'.
    • Choose the downloaded eldoria_v2.db file.
      *If prompted, accept the downloading of additional components.
    You should see the following tab:
    Database diagram
  7. Go to the 'SQL editor' 👉 'Open SQL Console'. Opening of the SQL console
  8. Run the query to check that everything works. select * from explorers;
    After entering the query, click on the 'Execute SQL query' (play) button on the left bar. The list of explorers should appear in the response.
    Successful request
  9. Click on the 'Let's go!' button below and try to send the queries described in the task.

Notice:

If the database does not open as described above, you may need to create a project or connect the database differently. There are many resources online to help you solve such issues. A good tester should be able to research and resolve these problems independently. 😉

Solutions and guiding queries are available within the tasks. We recommend that you first try to create your own query. Refer to the provided answers only if you're unable to progress after 10-15 minutes.