SQL Primary Key Explained
This tutorial is part of the SQL Made Easy series of posts. When first learning about SQL and relational databases… Read More »SQL Primary Key Explained
September 2020
SQL Operators Explained
In this simple guide, we are going to look at SQL Operators, explaining the concepts and use cases of logical,… Read More »SQL Operators Explained
SQL SELECT DISTINCT Explained
This tutorial is part of the SQL Made Easy series of posts. In this tutorial we will discuss: Why to… Read More »SQL SELECT DISTINCT Explained
How to easily merge data in Excel with a VLOOKUP
Working with multiple data sets in excel can be quite a time consuming and manual process. Depending on the complexity… Read More »How to easily merge data in Excel with a VLOOKUP
What exactly is SQL? A simple summary
If you are looking to start out a career in the world of data and analytics, or just want to… Read More »What exactly is SQL? A simple summary
Why Excel users should learn SQL
For many years my go to platform of choice for anything related to data was Microsoft Excel. Hours spent downloading… Read More »Why Excel users should learn SQL