In this lesson we will go over some powerful and important features in MySQL. We will first go over some aggregate functions that allow you to create meaningful statistics and provide analytical insights into the data. Through some examples we will try out how this works, get some good experience in not only using aggregate functions, but also combining it with all the other techniques within SQL we’ve learned so far. As we advance our knowledge and usage of databases, the proper use and execution of changes become critical, especially if there are multiple programs and users accessing the database. We will learn how to set up transactions, why this is crucial, and practice some examples together.