MySQL and JSON

MySQL 5.7 introduced a JSON data type that is fantastic, obviously, for JSON data.  But how do you use this new data type efficiently, what tools do you need to manipulate JSON data, when is it best to use a regular columns instead of JSON, and what magic new technology (generated columns) can you use to work with SQL indexes. So come learn how to use this new data type to become a rockstar developer. Lots of easy to follow code examples and best use practices.