SQL JOINS: A Beginner Guide to Data Analysis using SQL
Nowadays companies often produce a tremendous amount of data and mashing up this data to get a clear picture of the business is a fundamental part of the whole data analysis process. To be able to compare and combine data from different tables or data sources like databases, CSV Files, CRM systems or Web Analytics we need to JOIN these tables. SQL Joins are an instruction to a database to combine data from more than one table. As different SQL JOIN types are an integral part to perform useful and meaningful SQL data analysis we want take a closer look at the commonly used types and provide some practical tips for you.