SQL Joins

@PythonPr Who even does right hand joins though?! 😜

@PythonPr What’s the point when everything is a Left join ?

SQL joins become much easier once you stop memorizing syntax and start thinking in sets. INNER = only matching rows LEFT = everything from left + matches RIGHT = everything from right + matches FULL = everything from both sides The real skill is knowing which missing data you want to keep.

Building AI at Scale: SemiAnalysis’s Dylan Patel in conversation with Supermicro CBO Vik Malyala

@PythonPr youtube.com/shorts/glNY5Nr…

@PythonPr Detailed explanation

@PythonPr Now draw a cartesian product.

@PythonPr Set theory in practice