Oh there are definitely missing pieces! I tried to cover the "meaty middle" of what application developers usually need to know. I did not cover stored procedures and triggers.

I did cover CTEs and windows, which are not yet supported by PlanetScale. I also covered foreign key constraints, which are not yet supported by PlanetScale.

As far as charset and collation, I cover that a bit in the "strings" video of the "Schema" section.

Let me know if you have any other feedback!