Leigh Tami created a graphic involving a person and a coat to explain data set joins.
Scaling it down won’t do it justice here so see the original.
Preview any data science book with this image in mind. If it doesn’t match or exceed this explanation of joins, pass it by.