This included using various queries for exploring sakila database and creating stored procedures, stored functions and triggers.