Oracle Get-Together: MySQL 8.0 New Features

MySQL 8.0 made its debut in 2018 and has added a lot of useful features that you may not know about. First is the data dictionary that keeps your meta data inside the database (Good news: You can now have millions of tables in a schema, bad news: You can now have millions of tables in a schema). We enhanced the SQL with windowing functions for analytics, lateral derived tables, Common Table Expressions, and more. There are dual passwords, histograms, the clone plug-in for ultra fast replication to a secondary machine, hash joins, and much more. But you have to know about them before you can use them. And this is you chance to learn about these features and more.