Name: MySQL Optimization Video Tutorial—Boolean Education
Uploaded: 2022-04-24T15:59:31+8:00
Duration: 233 min 34 s
Description: "MySQL Optimization Video Tutorial - Boolean Education" MySQL is a relational database management system. A relational database stores data in different tables instead of putting all data in a large warehouse, which increases speed and improves efficiency. flexibility. The SQL language used by MySQL is the most commonly used standardized language for accessing databases.

"MySQL Optimization Video Tutorial - Boolean Education" MySQL is a relational database management system. A relational database stores data in different tables instead of putting all data in a large warehouse, which increases speed and improves efficiency. flexibility. The SQL language used by MySQL is the most commonly used standardized language for accessing databases.

Difficulty：Advanced

Total of24 chapters

65146 plays

Chapter1MySQL optimization tutorial: Be specific in your answer
04 minutes00 seconds; Table building principles
05 minutes36 seconds; Column type selection
06 minutes26 seconds; Index principle
07 minutes45 seconds; hash index
09 minutes55 seconds; Common misunderstandings about index building
07 minutes21 seconds; Index classic topics
07 minutes37 seconds; Index experiment
11 minutes53 seconds; Clustered index and non-clustered index
07 minutes13 seconds; Page split test
17 minutes56 seconds; Index coverage
06 minutes46 seconds; A classic topic on a forum
14 minutes09 seconds; ideal index
10 minutes48 seconds; Pseudo hash index
05 minutes49 seconds; Principles of multi-column indexes
04 minutes13 seconds; Indexing and sorting
09 minutes00 seconds; Duplicate and redundant indexes
03 minutes48 seconds; repair table
03 minutes18 seconds; Query general principles
10 minutes22 seconds; explain detailed explanation
34 minutes26 seconds; in type subquery trap
13 minutes21 seconds; Force the use of indexes
07 minutes19 seconds; count and union
07 minutes18 seconds; limit page turning optimization topic
17 minutes15 seconds

About Instructor

小云云: student

You will learn:: This video tutorial "MySQL Optimization Video Tutorial - Boolean Education" contains multiple contents, including table creation principles, column type selection, btree index principles, general query principles, indexing and sorting, detailed explanations and other related tutorials.

MySQL Optimization Video Tutorial—Boolean Education

About Instructor

php.cn