A complete set of MySQL tutorials - MySQL hot interview questions-Free online video tutorial-php.cn

Community Learn Tools Library Leisure

English

A complete set of MySQL tutorials - MySQL hot interview questions

MySQL is one of the most popular relational databases and is widely used in various fields. This course mainly explains the common objects in MySQL, and explains the optimization strategies in detail, and uses cases to give us an in-depth understanding of SQL optimization strategies. After studying this course, we can independently complete various SQL optimizations and improve the performance of the system.

Intermediate

mysql

Hotspot

interview

123326 person learning

122class hour

13 hours 11 minutes 00 secondsTotal course duration

2022-03-29update

王林

Gold lecturer

A total of 180 courses Student180304 Lecturer rating5.4

有朋自远方来，虽远必诛！More>>

Course Introduction Course Outline Data Download Other Courses

You will learn：

MySQL is one of the most popular relational databases and is widely used in various fields. This course mainly explains the common objects in MySQL, and explains the optimization strategies in detail, and uses cases to give us an in-depth understanding of SQL optimization strategies. After studying this course, we can independently complete various SQL optimizations and improve the performance of the system.

A complete set of MySQL tutorials - MySQL hot interview questions

Chapter1 Course introduction and mysql installation
expand retract

Section1 Course content introduction
duration： 02 minutes 30 seconds

Section2 Install mysql on linux
duration： 08 minutes 46 seconds

Section3 Start and log in to mysql
duration： 06 minutes 33 seconds
Chapter2 mysql index
expand retract

Section1 Index overview
duration： 13 minutes 09 seconds

Section2 Advantages and disadvantages
duration： 02 minutes 36 seconds

Section3 data structure
duration： 02 minutes 25 seconds

Section4 Data structure-BTREE
duration： 23 minutes 47 seconds

Section5 Data structure-B+TREE
duration： 05 minutes 53 seconds

Section6 Index classification
duration： 02 minutes 07 seconds

Section7 Index syntax
duration： 10 minutes 45 seconds

Section8 Index design principles
duration： 05 minutes 01 seconds
Chapter3 view
expand retract

Section1 Overview
duration： 03 minutes 00 seconds

Section2 Create and modify views
duration： 06 minutes 20 seconds

Section3 View and delete views
duration： 02 minutes 35 seconds
Chapter4 stored procedure
expand retract

Section1 Stored procedures overview
duration： 02 minutes 20 seconds
Chapter5 grammar
expand retract

Section1 Create call query delete syntax
duration： 10 minutes 08 seconds

Section2 variable
duration： 08 minutes 39 seconds

Section3 if judgment
duration： 07 minutes 29 seconds
Chapter6 Input and output parameters
expand retract

Section1 Input parameters
duration： 04 minutes 10 seconds

Section2 Output parameters
duration： 05 minutes 54 seconds
Chapter7 case structure and loop
expand retract

Section1 case structure
duration： 07 minutes 37 seconds

Section2 while loop
duration： 05 minutes 52 seconds

Section3 repeat loop
duration： 04 minutes 11 seconds

Section4 loop loop
duration： 06 minutes 10 seconds
Chapter8 cursor
expand retract

Section1 Cursor introduction
duration： 03 minutes 58 seconds

Section2 Basic cursor operations
duration： 09 minutes 18 seconds

Section3 Loop to get cursor
duration： 06 minutes 44 seconds
Chapter9 Functions and triggers
expand retract

Section1 function
duration： 06 minutes 35 seconds

Section2 Introduction to triggers
duration： 03 minutes 47 seconds

Section3 Trigger creation and application
duration： 20 minutes 30 seconds

Section4 View and delete triggers
duration： 02 minutes 21 seconds

Section5 Content summary
duration： 01 minutes 44 seconds
Chapter10 Architecture and Storage Engine
expand retract

Section1 Architecture
duration： 10 minutes 11 seconds

Section2 Storage engine overview
duration： 04 minutes 45 seconds

Section3 Storage engine features
duration： 02 minutes 06 seconds

Section4 InnoDB characteristics
duration： 12 minutes 05 seconds

Section5 MyISAM features
duration： 04 minutes 33 seconds

Section6 Memory and Merge features
duration： 05 minutes 35 seconds

Section7 Storage engine selection principles
duration： 02 minutes 40 seconds
Chapter11 Optimize SQL steps
expand retract

Section1 SQL execution frequency
duration： 08 minutes 27 seconds

Section2 Locate inefficient SQL
duration： 08 minutes 21 seconds

Section3 Introduction to explain command
duration： 03 minutes 52 seconds

Section4 explain id
duration： 08 minutes 05 seconds

Section5 explain之select_type
duration： 08 minutes 21 seconds

Section6 explain之table type
duration： 09 minutes 32 seconds

Section7 key rows extra
duration： 07 minutes 07 seconds

Section8 show profile
duration： 07 minutes 37 seconds

Section9 trace tool
duration： 04 minutes 21 seconds
Chapter12 Use of index
expand retract

Section1 Verify index to improve query efficiency
duration： 05 minutes 10 seconds

Section2 Match all values
duration： 04 minutes 05 seconds

Section3 leftmost prefix rule
duration： 07 minutes 45 seconds

Section4 Failure conditions (range query, field operation)
duration： 05 minutes 58 seconds

Section5 covering index
duration： 05 minutes 30 seconds

Section6 Index failure
duration： 02 minutes 18 seconds

Section7 like fuzzy matching
duration： 03 minutes 59 seconds

Section8 Full table scan is faster
duration： 04 minutes 16 seconds

Section9 Judgment of NULL value
duration： 06 minutes 09 seconds

Section10 in和not in
duration： 01 minutes 19 seconds

Section11 Single column index and compound index selection
duration： 07 minutes 19 seconds

Section12 View index usage
duration： 01 minutes 06 seconds
Chapter13 SQL optimization
expand retract

Section1 Insert data in bulk
duration： 08 minutes 23 seconds

Section2 insert optimization
duration： 02 minutes 02 seconds

Section3 orderby optimization
duration： 13 minutes 32 seconds

Section4 group by optimization
duration： 04 minutes 11 seconds

Section5 subquery optimization
duration： 03 minutes 35 seconds

Section6 or optimize
duration： 07 minutes 13 seconds

Section7 limit optimization
duration： 08 minutes 27 seconds

Section8 index hint
duration： 09 minutes 16 seconds

Section9 Content summary
duration： 01 minutes 46 seconds
Chapter14 Application optimization
expand retract

Section1 Application optimization
duration： 07 minutes 22 seconds

Section2 Query caching-overview and process
duration： 03 minutes 20 seconds

Section3 Query cache-configuration parameters
duration： 07 minutes 15 seconds

Section4 Query cache-enable query cache
duration： 06 minutes 17 seconds

Section5 Query cache—SELECT options
duration： 05 minutes 34 seconds

Section6 Query cache - failure scenario
duration： 08 minutes 17 seconds
Chapter15 Memory optimization
expand retract

Section1 Optimization principles
duration： 02 minutes 59 seconds

Section2 MyISAM memory optimization
duration： 04 minutes 07 seconds

Section3 InnoDB memory optimization
duration： 06 minutes 08 seconds
Chapter16 mysql concurrency parameter adjustment
expand retract

Section1 Concurrency parameter adjustment
duration： 10 minutes 23 seconds
Chapter17 mysql lock problem
expand retract

Section1 Overview and classification of locks
duration： 04 minutes 02 seconds

Section2 mysql support for locks
duration： 02 minutes 30 seconds

Section3 MyISAM table lock-read lock
duration： 07 minutes 55 seconds

Section4 MyISAM table lock - write lock
duration： 04 minutes 11 seconds

Section5 Summary of MyISAM table locks
duration： 02 minutes 43 seconds

Section6 MyISAM table lock-view lock contention
duration： 04 minutes 22 seconds

Section7 InnoDB row lock-introduction and background knowledge
duration： 07 minutes 14 seconds

Section8 InnoDB row lock-type
duration： 02 minutes 04 seconds

Section9 InnoDB row lock-basic demo
duration： 08 minutes 54 seconds

Section10 InnoDB row lock-row lock upgraded to table lock
duration： 05 minutes 59 seconds

Section11 InnoDB row lock-gap lock hazards
duration： 05 minutes 54 seconds

Section12 InnoDB row lock-contention view
duration： 02 minutes 09 seconds

Section13 InnoDB row lock-summary
duration： 03 minutes 27 seconds
Chapter18 Common SQL skills
expand retract

Section1 SQL execution order and regular expressions
duration： 05 minutes 58 seconds

Section2 Numeric and string functions
duration： 07 minutes 28 seconds

Section3 Date functions and aggregate functions
duration： 03 minutes 04 seconds

Section4 Course content
duration： 01 minutes 19 seconds

Section5 Commonly used tools mysql
duration： 03 minutes 38 seconds

Section6 Commonly used tools-mysqladmin
duration： 03 minutes 29 seconds

Section7 Commonly used tools-mysqlbinlog and mysqldump
duration： 10 minutes 51 seconds

Section8 Commonly used tools-mysqlimport and source
duration： 02 minutes 30 seconds

Section9 Commonly used tools mysqlshow
duration： 03 minutes 00 seconds
Chapter19 mysql log
expand retract

Section1 error log
duration： 03 minutes 31 seconds

Section2 Binary log
duration： 08 minutes 29 seconds

Section3 Binary log (row and log deletion)
duration： 08 minutes 40 seconds

Section4 Query log
duration： 04 minutes 23 seconds

Section5 Slow query log
duration： 09 minutes 15 seconds
Chapter20 mysql copy
expand retract

Section1 Copy principle
duration： 05 minutes 28 seconds

Section2 Cluster construction
duration： 11 minutes 28 seconds
Chapter21 Comprehensive case
expand retract

Section1 Requirements and environment preparation
duration： 06 minutes 31 seconds

Section2 Basic project import
duration： 08 minutes 28 seconds

Section3 AOP logging
duration： 14 minutes 35 seconds

Section4 Log query backend - mapper interface
duration： 14 minutes 18 seconds

Section5 Log query backend——Service
duration： 11 minutes 04 seconds

Section6 Log query - front end
duration： 23 minutes 55 seconds

Section7 System performance optimization analysis
duration： 04 minutes 26 seconds

Section8 System performance optimization - paging optimization
duration： 16 minutes 17 seconds

Section9 System performance optimization - index optimization
duration： 11 minutes 48 seconds

Section10 Read-Write Separation Overview
duration： 04 minutes 36 seconds

Section11 Data source configuration
duration： 12 minutes 39 seconds

Section12 System performance optimization - AOP switching data source
duration： 08 minutes 23 seconds

Section13 System performance optimization - AOP switching data source 2
duration：In calculation

Section14 System performance optimization - application optimization
duration： 04 minutes 32 seconds

Data Name operate
[must see]MySQL full set of tutorial related courseware Download

王林 Lecturer Other Courses

ElementaryComplete collection of interview questions in front-end disciplines (Season 1)

22827
Collection
ElementaryFlexible box + responsive page layout practice

8831
Collection
ElementaryMake a responsive website from scratch—Grid layout

17317
Collection
ElementaryThe most easy-to-understand HTML+CSS course in 9 days

43831
Collection
ElementaryBasic tutorial for getting started with Web front-end

235993
Collection
ElementaryWeb front-end development-Zero Basic Programming Admission Guide

65610
Collection
ElementaryFront-end basic HTML5+CSS3 from entry to proficiency (full version)

295376
Collection
ElementaryThe latest CSS3 tutorial is quick and easy to understand

22151
Collection
ElementaryCSS3 Flex flexible box model makes layout fly

27988
Collection
ElementaryLearn DIV+CSS layout in one day (five practical exercises)

10841
Collection
ElementaryHTML5+CSS practice project [Hand Knock Onmyoji official website]

10597
Collection
ElementaryMobile layout: HTML5+CSS3 advanced and enhanced version

120553
Collection

Start Learning

This course includes：

13 hours 11 minutes 00 seconds Watch videos anytime

1 Download Resources

Popular courses Latest courses

More>