Mastering Commonly Used SQL Joins: With Relatable Examples

Introduction SQL is a defacto language when it comes to interacting with data in Data Storage containers such as relational databases, data warehouses, data lakes etc. Whether you are professional such as a data engineer, analyst, scientist, analytics engineer or a motivated pal interested in tinkering with data, one needs to master SQL Joins. For SQL joins to work, a relationship needs to be identified in order to join data from different tables. This is achieved using foreign and primary keys.