> Are fixtures really games?
Yes, they are real games from the English Premier League.
> I can definitely help you out in terms of queries. I need some time to make up some data, unless you want to send over your database.
I have uploaded the DB to Dropbox with the changes you suggested to the schema.
> Questions: What database are you using? What courses have you tried so far? What's been the most frustrating thing?
I am using SQLite.
I completed Using Databases with Python course from University of Michigan. This was a great course for the basics and there was a few practical examples that helped put some stuff together.
I had dabble in some of the codeacademy SQL courses many years ago, but they just left me confused at the time. I would possibly fair better if I returned to them now.
As I have not done massive amount of courses with SQL with Python, so my experience is limited, but I have found it frustrating that I haven't seen much beyond the basic Read, Write and Update files. What I am really finding frustrating is trying to find something that explains the building blocks of queries and how I should look to go about building them. But that might be more my fault at the moment. I will take a nose at the links that you have sent along and see what I can get from them.
EDIT: I have put together a simpler site using SQLite statements at https://github.com/spacedlevo/brewdog_untappd_app.git after following the Databases with Python course.