# 1. Prerequestics

### Test Database

- Download sakila db  
    ```
    https://dev.mysql.com/doc/index-other.html
    ```
- Extract the installation archive to a temporary location
- Connect to the MySQL server ```bash
    mysql -uroot -p
    ```
- Execute the sakila-schema.sql script to create the database structure, and execute the sakila-data.sql script ```mysql
    SOURCE /home/<usr>/Downloads/sakila-db/sakila-schema.sql;
    SOURCE /home/<usr>/Downloads/sakila-db/sakila-data.sql;
    ```