)
I started an amazing course over on Udemy presented by Jose Protilla called “The complete SQL bootcamp – From Zero to Hero”. The main reason I started this was because of a class I started at my new semester at WGU and yes, you guessed correctly: A SQL class. Aside from learning the fundamentals about SQL, I also wanted to do some supplementary learning revolving it and thanks to Mr Protilla I am learning a lot.
In the beginning, I was required to installed two things: PostSQL and PGAdmin. PostSQL is described, from the official site https://www.postgresql.org/about/, as “PostgreSQL is a powerful, open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads”.
PGAdmin is the GUI, graphical user interface, of your input/output as shown here. It did not take long at all to install and the setup was easy and he has very helpful videos on how to set them up.
After I installed what I needed, I began the course. It is well structured and rewarding. My favorite part have been the “Challenges” videos. Essentially, you will learn from videos then put those into practice and also get hints on the way to go about it before the actual input/answer was given.
These are some of the earlier snippets I grabbed. On the left screen I had pgAdmin running and on the right screen I had the videos pulled up with the challenge sections. Right now, I have 3 hours left in the course. It’s 9 hours all together. I will do more this weekend and am aiming to finish it. I’m having a great time with this course and I highly recommend it if you have the time and are curious about SQL.
Credit to the course/material goes to: Jose Portilla