Tags
Language
Tags
March 2024
Su Mo Tu We Th Fr Sa
25 26 27 28 29 1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31 1 2 3 4 5 6

First Look: MySQL 8 for Developers

Posted By: IrGens
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

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