MySQL Advanced Advanced Video Tutorial-Free online video tutorial-php.cn

Community Learn Tools Library Leisure

English

MySQL Advanced Advanced Video Tutorial

MySQL advanced advanced video tutorial, explaining the advanced core functions of MySQL database. Mysql advanced courses mainly focus on how to choose its storage engine, how to diagnose and optimize mysql queries, what is the mechanism of mysql locks, how to reduce lock conflicts, improve concurrency, etc. Problem-solving methods and ideas, as well as mysql The understanding of PHP is introduced to help PHP students quickly master relevant knowledge.

Advanced

mysql advanced advanced video tutorial

118971 person learning

38class hour

08 hours 38 minutes 47 secondsTotal course duration

2023-05-22update

-

Gold lecturer

A total of 43 courses Student53536 Lecturer rating5.8

More>>

Course Introduction Course Outline Other Courses

You will learn：

MySQL advanced advanced video tutorial, explaining the advanced core functions of MySQL database. Mysql advanced courses mainly focus on how to choose its storage engine, how to diagnose and optimize mysql queries, what is the mechanism of mysql locks, how to reduce lock conflicts, improve concurrency, etc. Problem-solving methods and ideas, as well as mysql The understanding of PHP is introduced to help PHP students quickly master relevant knowledge.

MySQL Advanced Advanced Video Tutorial

Chapter1 MySQ Advanced Advanced Video Tutorial
expand retract

Section1 mysql encoding settings 1
duration： 13 minutes 52 seconds

Section2 mysql encoding setting 2
duration： 14 minutes 19 seconds

Section3 Session variables and global variables
duration： 13 minutes 31 seconds

Section4 Stored procedure 1
duration： 12 minutes 59 seconds

Section5 Stored procedure 2 (definition of variables)
duration： 14 minutes 40 seconds

Section6 Stored procedure 3 (parameter type)
duration： 13 minutes 23 seconds

Section7 Flow control statement selection statement 1
duration： 12 minutes 35 seconds

Section8 Process control (select statement case branch)
duration： 16 minutes 23 seconds

Section9 Process control (while loop statement)
duration： 13 minutes 33 seconds

Section10 Process control (loop repeat and loop statements)
duration： 12 minutes 43 seconds

Section11 Define conditions and processing [vxia.net]
duration： 14 minutes 30 seconds

Section12 Stored procedure management
duration： 11 minutes 23 seconds

Section13 Creation of functions
duration： 14 minutes 50 seconds

Section14 View creation 1
duration： 14 minutes 40 seconds

Section15 View management
duration： 16 minutes 30 seconds

Section16 Application of trigger 1
duration： 14 minutes 57 seconds

Section17 Trigger application 2
duration： 12 minutes 23 seconds

Section18 My ISAM table lock (shared read lock)
duration： 12 minutes 56 seconds

Section19 My ISAM table lock (exclusive write lock)
duration： 10 minutes 31 seconds

Section20 MyISAM table lock (concurrent insert)
duration： 11 minutes 41 seconds

Section21 Application of business 1
duration： 13 minutes 44 seconds

Section22 Application of business 2.
duration： 14 minutes 01 seconds

Section23 Slow query 1 (see slow query)
duration： 13 minutes 16 seconds

Section24 Slow query 2 (slow query configuration)
duration： 11 minutes 47 seconds

Section25 Index 1 (category of index)
duration： 14 minutes 01 seconds

Section26 Index 2 (full text index)
duration： 14 minutes 21 seconds

Section27 Optimize SQL with indexes
duration： 15 minutes 31 seconds

Section28 Table optimization
duration： 13 minutes 26 seconds

Section29 Partition 1 of the table (Range partition)
duration： 13 minutes 53 seconds

Section30 Partition 2 of the table (List partition, Hash, Keys partition)
duration： 14 minutes 45 seconds

Section31 Mysql memory optimization
duration： 13 minutes 51 seconds

Section32 mysql application optimization
duration： 14 minutes 28 seconds

Section33 mysql account permission grant
duration： 15 minutes 56 seconds

Section34 mysql account permission management
duration： 12 minutes 38 seconds

Section35 mysql monitoring
duration： 14 minutes 54 seconds

Section36 mysql scheduled maintenance [vxia.net]
duration： 13 minutes 13 seconds

Section37 mysql backup and restore
duration： 14 minutes 20 seconds

Section38 mysql advanced project
duration： 08 minutes 23 seconds

- Lecturer Other Courses

ElementaryHTML front-end basics Part 6

344476
Collection
IntermediateHTML5 development practice: front-end production of Baidu takeout mobile website

65508
Collection
ElementaryFrom scratch to WEB responsive layout

163235
Collection
ElementaryGet started quickly with HTML5

55564
Collection
ElementaryGet started quickly with CSS3

79392
Collection
Intermediatetouch video tutorial

83465
Collection
IntermediateWeb front-end development hybrid development video tutorial

31163
Collection
IntermediateHTML5 Canvas animation practical tutorial

58244
Collection
Elementarybootstrap3 series (English) + Twitter Bootstrap101 series

48536
Collection
ElementaryBrothers Zhang Cheng UI tutorial Bootstrap video tutorial

44361
Collection
ElementaryBacking Network BootStrap video tutorial

43472
Collection
ElementaryBootstrap responsive web layout

191267
Collection

Start Learning

This course includes：

08 hours 38 minutes 47 seconds Watch videos anytime

0 Download Resources

Popular courses Latest courses

More>