Using MySQL's JSON Data Type

MySQl 5.7 features a new native JSON data type! This means you can put a valid JSON formatted document into a column of a table in a MySQL relational data base.  You will learn how MySQL internally otimizes the data for storage, the limits of JSON storage, the supporting functions for using JSON, how to properly encode your data with PHP's or MySQL's functions, how to use generated columns to extract JSON data to build Structured Query Language (SQL) indexes for fast searches, and best use cases for using JSON data.  So now you can have both NoSQL and SQL at the same time from one server.  Plenty of coding examples in PHP so that you will fully know how to use this new data type at the end of the session.