Some simple queries to get you started

Some pattern matching queries

In which we query the World country profile table.

Additional practice of the basic features using a table of Nobel Prize winners.

In which we form queries using other queries.

In which we apply aggregate functions. more the same

In which we join two tables; game and goals. previously music tutorial

In which we join actors to movies in the Movie Database.

In which we look at teachers in departments. previously Scottish Parliament

In which we look at a survey and deal with some more complex calculations.

In which we examine UK general election results.

In which we measure the impact of COVID-19

In which we join Edinburgh bus routes to Edinburgh bus routes.

Test your knowledge with multiple choice quizzes

Creating a database

Instructions on how to import data and analyse it in mysql