Database Exercises
Sakila database

To complete these exercises you will need the Sakila database. Installation instructions can be found at https://dev.mysql.com/doc/sakila/en/sakila-installation.html

You can install the Sakila database as follows:

  1. Download the Sakila.Zip file from https://dev.mysql.com/doc/index-other.html
  2. Extract the file
  3. Start MySQL and open a connection with Workbench
  4. Select Server->Data import->self contained file and find sakila-schema.sql->Start Import
  5. Select Server->Data import->self contained file and find sakila-data.sql and select sakila as Target Schema->Start Import
Now you should have the Sakila database and can complete the exercises.



Toggle Menu