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

  mysql -uroot -p

• Execute the sakila-schema.sql script to create the database structure, and execute the sakila-data.sql script

  SOURCE /home/usr/<usr>/Downloads/sakila-db/sakila-schema.sql;
  SOURCE /home/usr/<usr>/Downloads/sakila-db/sakila-data.sql;