Overview
-
Get up and running with MySQL 8. Learn how to leverage its radical new capabilities to design and build robust, elegant, scalable, and secure applications in less time and effort.
Syllabus
-
Introduction
- Better applications with MySQL 8
- What you should know
- Windows and the OVER clause
- Window frames
- Rows vs. range
- Aggregate window functions
- Ranking window functions
- Offset window functions
- Analytic window functions
- Challenge: Window functions
- Solution: Window functions
- Derived tables, views, and common table expressions (CTEs)
- CTE demo
- Recursive CTE
- Challenge: Use CTEs
- Solution: Use CTEs
- SQL joins
- Lateral derived tables
- Challenge: Use lateral derived tables
- Solution: Use lateral derived tables
- Changes to AUTO_INCREMENT
- Data dictionary and atomic DDL
- MySQL Document Store
- Structured vs. unstructured data
- Using roles
- Password and encryption enhancements
- Descending order indexes
- Invisible indexes
- Functional key indexes
- Resource management
- Next steps
