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:

  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!

My Spring Boot notes

Lately I’ve been busy with university, work and learning something new. I’ve started my programming journey when I was in high school with Python, I didn’t have any informatics classes so I had to study on my own. I confess that I didn’t really understood how Python works, until I’ve tried Java. Python had a dynamic type system and it was very confusing for a newbie like me.

After finishing Introduction to Computing with Java course from HKUST on edX I started to get a better grasp on programming. After that I’ve started reading some java books like: Effective Java, Head First Java and some chapters from Intro to Java Programming, Comprehensive Version, which I consider to be the most complete and useful Java book ever made (if you do the exercises). Then I’ve abandoned Java because all I knew to do with it was console programs, I had no ideas about framework and all the possibilities, when I saw someone at Google giving a talk and demonstrating a browser game that ran Java in the backend I was like: “What is this magic?!”, back then I had no knowledge about networking and client-server architecture.

I’ve been doing Django lately and decided to learn something new: Spring Boot.

As I just finished the Spring Boot courses, I want to make my notes publicly available. The notes are not perfect and they have been written in a style that’s tailored for my own personal use, sorry if you don’t understand them :/.

The next steps are to write a simple pastebin clone in spring boot and to start a the spring microservices course.

The notes can be downloaded by following this link: SpringNotes-01