English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 2h 08m | 261 MB
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
Table of Contents
1 Better applications with MySQL 8
2 What you should know
3 Windows and the OVER clause
4 Window frames
5 Rows vs. range
6 Aggregate window functions
7 Ranking window functions
8 Offset window functions
9 Analytic window functions
10 Challenge Window functions
11 Solution Window functions
12 Derived tables, views, and common table expressions (CTEs)
13 CTE demo
14 Recursive CTE
15 Challenge Use CTEs
16 Solution Use CTEs
17 SQL joins
18 Lateral derived tables
19 Challenge Use lateral derived tables
20 Solution Use lateral derived tables
21 Changes to AUTO INCREMENT
22 Data dictionary and atomic DDL
23 MySQL Document Store
24 Structured vs. unstructured data
25 Using roles
26 Password and encryption enhancements
27 Descending order indexes
28 Invisible indexes
29 Functional key indexes
30 Resource management
31 Next steps
Resolve the captcha to access the links!