{{ variable.name }}
Introduction Whether it is the powerful universal table expressions and window functions, the enhanced account security and convenient account management, or the extensive code refactoring, as well as the numerous enhancements to the InnoDB storage engine brought about by them, the improvements to various query optimizers, and the further support for NoSQL, all are reminding us that MySQL 8.0 is a highly milestone version. Good things, of course, should be shared by everyone, which is why this course came into being. This course is not only about concepts but also focuses on practical application. All the content includes actual operation. Welcome to come and have a look.
Chapter 1 Course Introduction
Introduction to the new features and functions of MySQL 8.0 version.
Course Introduction 1-1
Chapter 2 Accounts and Security
MySQL 8.0 makes your account more secure and easier to manage.
2-1 User Creation and Authorization
2-2 Certification Plugin Update
2-3 Password Management
2-4 Role Management
Chapter 3 Optimizer Index
Introduce three new indexing methods in MySQL 8.0: hidden index, descending index, and function index.
3-1 Hidden Index
3-2 Descending index
3-3 Function Index
Chapter 4 General Table Expressions
General table expressions make SQL different from now on.
4-1 Non-recursive CTE
4-2 Recursive CTE
4-3 Recursive restriction
4-4 CTE Summary
Chapter 5 Window Functions
MySQL finally has window functions. Come and experience the analysis capabilities of these functions.
5-1 Basic Concepts of Window Functions
5-2 Specialized Window Functions
5-3 Window Definition
Chapter 6 InnoDB Enhancements
Experience various powerful updates to the InnoDB storage engine in MySQL 8.0.
6-1 Integrated Data dictionary
6-2 atom DDL operation
6-3 Auto-increment column persistence
6-4 Deadlock Check Control
6-5 Lock statement options
6-6 Other improved functions
Chapter 7 JSON Enhancement
Introduce the newly added JSON functions and operators in MySQL 8.0 version.
7-1 Inline path operator
7-2 JSON Aggregation Function
7-3 JSON Practical Functions
7-4 JSON Merge Function
7-5 JSON Table Functions
Chapter 8 Course Summary
8-1 Course Summary