I signed up for the Database Design course at my university, the courses are great but the practical laboratories are not, it’s just a bunch of tiresome SQL queries and incomplete instructions. If you too have to do a lot of tiresome SQL queries I suggest the following setup:

  1. Download Docker.
  2. Download any Intellij IDE (if you’re a student you can get it for free). Preferably DataGrip.

After you installed the aforementioned tools you start with a some docker commands:

Instructions here, if you want to explore on your own.

docker pull wnameless/oracle-xe-11g
docker run -d -p 49161:1521 wnameless/oracle-xe-11g

Now, open DataGrip, add a new data source, select Oracle and use the following settings:

hostname: localhost
port: 49161
sid: xe
username: system
password: oracle

Do not bother with the official docker images from Oracle, they usually don’t work.

Thank you for reading!