The following article explains the differences between, inner joins, outer joins, exclusion joins and so on.
The following article list numerous resources on data science.
Easy to follow, very practical, suited to people with limited or zero Python experience. Free version of book available online.
Natural language processing with Python
All the examples are in Python and the NLTK package but the general ideas may be of interest to users of R.