Train with MySQL database

There is a database in The MySQL dump format (the total database size is about 10 GB). I need to make selections from this database:
by city/street.
Since such samples will have to be done often, I myself want to learn how to do them. Not only that, in 2015 I installed Denver and queried (via select) for a similar task, but now Ive forgotten.

Algorithm of work:
1. I throw you the database and write examples of requests that will need to be made
2. You do it at home
3. You throw me what software I need to install and make a plan for our online call
4. I install the software
5. Calling in Zoom/Discord
6. Show the basic functions of the program and how to make the necessary requests.
For all the work, I assume, it will take you no more than 2 hours.

In the comments please write:
- your experience with the database
- what software do you recommend to work with the database
- your pre-teaching abilities (in this case, it is important that you are able to explain) - perhaps you recorded some training videos or taught.
I will consider only comments with answers to these three questions.