In this lesson, we will start from a project scenario, use an ER diagram to create tables, import data from files, and create joins and some useful aggregate functions. Then we will further utilize all the skills we’ve been learning to automate the database through creating functions and triggers. Afterwards we will take this a step further and create a connection with the MySQL database with Javascript and also create a display in an web application.