As my journey in becoming a competent data analytics, my SQL knowledge continues to deepen and as a result, I also publish few things pick up through the process. couple of weeks back I published about SQL fundamentals, covering that is DDL , DML and Data Manipulation . Read more about SQL fundamentals from this link Click here to visit dev.to . Building on SQL skills and data analysis, I have come to know you can work on different tables at the same time through the help of SQL joins and SQL Functions . What is Join? A JOIN in SQL is used to link or combine rows from two or more tables based on related column between them and it is usually a Primary Key and Foreign Key . Think of it like, one table has students and another has scores, JOIN will help you see which student took which course. Types of Joins LEFT JOIN (LEFT OUTER JOIN) This type of returns all records from Left table and matching records from the right table Example: SELECT s . name , c . course_name FROM students s LEFT JOIN courses c ON s .…