Company: Linkedin Learning Author: Amihai Levin Full Title: First Look: MySQL 8 For Developers Year: 2019 Language: English Genre: Educational: Programming Languages Skill Level: Intermediate Price: €34.99 - Files: MP4 (+ Exercise Files) Time: 02:08:32 Video: AVC, 1280 x 720 (1.778) at 30.000 fps, 200 kbps Audio: AAC at 128 Kbps, 2 channels, 48.0 KHz 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: 01. Aggregate, ranking, analytic, and offset window functions 02. Using common table expressions (CTE) 03. The benefits of lateral derived tables 04. InnoDB latest enhancements 05. Using security roles 06. Enhancements to password and encryption management 07. Improving query performance with new index types Our members see more. Join us! ------------- Our members see more. Join us!