Install the textbook databases on your machine

I assiume that you are running XAMPP on Windows; the steps are similar for other setups

1. Download the "small databases" ZIP file (linked from schedule page) to your computer;
2. extract the three .sql files
3. Make sure that mySQL is running on your system (XAMPP control panel)
4. In a web browser, go to localhost/phpmyadmin
   (on some systems, phpMyAdmin)
5. If you wish, create a password for the root account (I'm not sure how to recover if you ever forget it)
6. Click Databases from the top of the page.
   • Under Create Database, type simpsons for the name, and click the Create button
   • Do the same for world and imdb_small
7. Populate the simpsons database
   • In the left column (Navigation frame), click simpsons
   • Click Import from the top of the page, then click Chhose File
   • Browse to where you extracted the files in step 1, then choose simpsons.sql
   • Click Go
   • You should see the four table names in the left column
   • Click one of those names to see its contents
8. Repeat the previous step for world and imdb_small
9. You should now be ready to do some queries:
   Choose the simpsons database again and click the Query Window icon at the top of the Navigation Frame