The first thing to do is to create a test database. Let's say we own a movie store and we need to keep track of the titles we have available: we are going to create a "movie_store" database and a table to host information about the movie directors:
This is a companion discussion topic for the original entry at https://linuxconfig.org/introduction-to-database-joins-with-mariadb-and-mysql-join-examples