Over the course of the Boot Camp we have made use of MySql, Sqlite, and MongoDB. Each database has it own unique benefits and disadvantages. The right database all depends on what needs to be accomplished.

MySql is a great relational database for long-term, secure data storage. It is easy to use, cheap, and is widely used (coming with a lot of support), but this comes at a cost. It is said to have poor performance in scalability, and it relies on many add-ons. Either way, some of the largest companies in America use it and knowing how to query a MySql database is a must.

In the Film Analysis project, we made several queries on the sakila database provided. We added a table with several columns, performed joins, performed nested queries over multiple tables, and performed calculations.

Please click here to view the MySql queries on GitHub.