Traversy Media provides a a beginner-based crash course on working with MySQL with the Python programming language.
Here’s a great tutorial for beginners (or refresher for seasoned pros) on the basics of SQL Joins (Inner, Left, Right, Full Join).