Joins in SQL

Through my stint as a backend - primarily database developer, I have observed Joins by far to be one of the most used and one of the least understood features of SQL. While the use of joins is imperative in a traditional RDBMS where tables are norma...