First Look: MySQL 8 for Developers
First Look: MySQL 8 for Developers
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 2h 8m | 259 MB
Instructor: Amihai Levin
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 2h 8m | 259 MB
Instructor: Amihai Levin
Looking to make the jump to MySQL 8? In this course, get a first look at all that MySQL 8 has to offer. Instructor Ami Levin highlights the new capabilities introduced in MySQL 8, showing how to leverage these enhancements to build robust, elegant, performant, scalable, and secure applications in less time and with drastically reduced costs. Learn about common table expressions (CTE) and how to use them to make your queries more concise. Explore window functions and how they impact query processing. Plus, learn how to work with lateral derived tables to solve real-world SQL challenges, leverage InnoDB enhancements, and work with features that make it easier to tighten security and boost performance.
Topics include:
Aggregate, ranking, analytic, and offset window functions
Using common table expressions (CTE)
The benefits of lateral derived tables
InnoDB latest enhancements
Using security roles
Enhancements to password and encryption management
Improving query performance with new index types
First Look: MySQL 8 for Developers
