Summary
By now, you have learned the different database engines available in MySQL 8 and their applications. We established how to create tables, modify existing tables, and how to add/remove columns from an existing table. We also understood how to drop tables and databases. We learned in detail about different filter criteria available in MySQL. After that, we explored the different joins available in MySQL 8 and how to use joins in a query to fetch meaningful data from the database in a single query. We explored how database transactions work in MySQL and the importance of transactions in real-life scenarios. Lastly, we understood how to use aggregate functions in MySQL and learned the usage of different aggregate functions such as group by, having, min(), max(), avg(), sum(), and count(), and how to store JSON information in the database.
In the next chapter, you will learn how indexing works in MySQL 8, the new features introduced related to indexing, different types of indexing, and...