Getting started with PL/SQL
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:
Download Docker.
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!