Increase Your SQL Power to OVER 9000!!
When I need to obtain a better understanding of a certain topic in SQL, the first place I tend to visit is YouTube. Rightfully so too, because if you do a quick search for SQL you will easily be overwhelmed by the number of videos out there.
I want to help you avoid being overwhelmed by so many choices that I have curated a list of 5 channels to follow to learn all about SQL and take you from beginner to advanced.
Now, if you are like me, when you watch a YouTube video, you skip through the video to…
A quick intro into SQL data types
There are many flavors of SQL — Oracle, SQL Server, MySQL, BigQuery, PostgreSQL — and just like that there are various version of SQL for each flavor. This isn’t about what is different though, this is about SQL data types and what to do if you need to make change types on the fly.
Let’s dive right in!
Like I said above there are many flavors of SQL and there is a long list of things that are very similar in each of these, but there is also just as long a list that is different between them.
I have…
Because not all data is stored in the same spot.
For me joins in SQL were one of those things that was difficult to understand, but is super important to understand. After some practice and this article, hopefully the confusion will subside.
Like the headline says there are at least 6 ways to join data in SQL. Previously I wrote about the foundational SQL skills to learn. You can read the article here.
Foundational SQL Know-How. Enough To Be Dangerous. | by Scott Fiene | CodeX | Medium
You can also find all the code used on my GitHub.
Let’s take a look at the tables we will be using…
CODEX
Enough To Be Dangerous.
I recently began learning SQL not to long ago by being thrown in to the fire. I decided that it would be a good idea dive into the fundamentals to have a more solid foundation. This is the beginning of my journey.
Creating Database and Tables
Note: I will be using PostgreSQL 13 and pgAdmin 4 to run the code. For the most part everything can be used across databases. If I use something specific to PostgreSQL then I will make it known.
Creating the Database
To create a database is simple with one line of SQL. Now is a good time to mention some SQL grammar…
CODEX
About a week ago I decided I wanted do more with SQL than what I was using at work. I came across this a book from Packt Publishing called The Applied SQL Data Analytics Workshop that I decided to purchase. It seems to have everything that I was wanting in a tutorial.
At work we use Microsoft SQL Server and SQL Server Management Studio, which there is nothing wrong with in my honest opinion. However, this book utilizes PostgreSQL and pgAdmin4 so there is a little bit of a learning curve right in the beginning.
Challenge accepted!
Turns out that…
