If you want to data on a particular ShowType then it's just a matter of JOINing the relevant tables.
The query below returns some basic data for every Show that is of ShowType XXX, where XXX represents the ShowTypeID of the required ShowType . The ShowTypeID has been used but the Show.TypeName could be used but would require a further JOIN using the ShowType table.
An ID field is typically used in a link (which display the actual name) or in a search form listing the different ShowTypes.
FROM Show AS S INNER JOIN
(Artist AS A INNER JOIN ArtistShow AS [AS] ON A.ArtistID = [AS].ArtistID)
ON S.ShowID = AS.ShowID
WHERE S.ShowTypeID = XXX;
Attached is the db diagram.
As for DB courses, I think if you can find a decent one it'd be worth it (here's the one I took). Having said that many of the people I work with haven't any formal DB design training but are very knowledgable and skilled. Experience counts for a lot.