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-11gdocker run -d -p 49161:1521 wnameless/oracle-xe-11gThis container uses the default system / oracle credentials and publishes the database port. Keep it on a trusted machine; for a local-only setup, bind the port to 127.0.0.1.
Now, open DataGrip, add a new data source, select Oracle and use the following settings:
hostname: localhostport: 49161sid: xeusername: systempassword: oracleDo not bother with the official docker images from Oracle, they usually don’t work.
Thank you for reading!