Name: A complete set of MySQL tutorials - MySQL hot interview questions
Uploaded: 2022-03-29T16:18:12+8:00
Duration: 791 min

Chapter1Course introduction and mysql installation: Course content introduction
02 minutes30 seconds; Install mysql on linux
08 minutes46 seconds; Start and log in to mysql
06 minutes33 seconds
Chapter2mysql index: Index overview
13 minutes09 seconds; Advantages and disadvantages
02 minutes36 seconds; data structure
02 minutes25 seconds; Data structure-BTREE
23 minutes47 seconds; Data structure-B+TREE
05 minutes53 seconds; Index classification
02 minutes07 seconds; Index syntax
10 minutes45 seconds; Index design principles
05 minutes01 seconds
Chapter3view: Overview
03 minutes00 seconds; Create and modify views
06 minutes20 seconds; View and delete views
02 minutes35 seconds
Chapter4stored procedure: Stored procedures overview
02 minutes20 seconds
Chapter5grammar: Create call query delete syntax
10 minutes08 seconds; variable
08 minutes39 seconds; if judgment
07 minutes29 seconds
Chapter6Input and output parameters: Input parameters
04 minutes10 seconds; Output parameters
05 minutes54 seconds
Chapter7case structure and loop: case structure
07 minutes37 seconds; while loop
05 minutes52 seconds; repeat loop
04 minutes11 seconds; loop loop
06 minutes10 seconds
Chapter8cursor: Cursor introduction
03 minutes58 seconds; Basic cursor operations
09 minutes18 seconds; Loop to get cursor
06 minutes44 seconds
Chapter9Functions and triggers: function
06 minutes35 seconds; Introduction to triggers
03 minutes47 seconds; Trigger creation and application
20 minutes30 seconds; View and delete triggers
02 minutes21 seconds; Content summary
01 minutes44 seconds
Chapter10Architecture and Storage Engine: Architecture
10 minutes11 seconds; Storage engine overview
04 minutes45 seconds; Storage engine features
02 minutes06 seconds; InnoDB characteristics
12 minutes05 seconds; MyISAM features
04 minutes33 seconds; Memory and Merge features
05 minutes35 seconds; Storage engine selection principles
02 minutes40 seconds
Chapter11Optimize SQL steps: SQL execution frequency
08 minutes27 seconds; Locate inefficient SQL
08 minutes21 seconds; Introduction to explain command
03 minutes52 seconds; explain id
08 minutes05 seconds; explain之select_type
08 minutes21 seconds; explain之table type
09 minutes32 seconds; key rows extra
07 minutes07 seconds; show profile
07 minutes37 seconds; trace tool
04 minutes21 seconds
Chapter12Use of index: Verify index to improve query efficiency
05 minutes10 seconds; Match all values
04 minutes05 seconds; leftmost prefix rule
07 minutes45 seconds; Failure conditions (range query, field operation)
05 minutes58 seconds; covering index
05 minutes30 seconds; Index failure
02 minutes18 seconds; like fuzzy matching
03 minutes59 seconds; Full table scan is faster
04 minutes16 seconds; Judgment of NULL value
06 minutes09 seconds; in和not in
01 minutes19 seconds; Single column index and compound index selection
07 minutes19 seconds; View index usage
01 minutes06 seconds
Chapter13SQL optimization: Insert data in bulk
08 minutes23 seconds; insert optimization
02 minutes02 seconds; orderby optimization
13 minutes32 seconds; group by optimization
04 minutes11 seconds; subquery optimization
03 minutes35 seconds; or optimize
07 minutes13 seconds; limit optimization
08 minutes27 seconds; index hint
09 minutes16 seconds; Content summary
01 minutes46 seconds
Chapter14Application optimization: Application optimization
07 minutes22 seconds; Query caching-overview and process
03 minutes20 seconds; Query cache-configuration parameters
07 minutes15 seconds; Query cache-enable query cache
06 minutes17 seconds; Query cache—SELECT options
05 minutes34 seconds; Query cache - failure scenario
08 minutes17 seconds
Chapter15Memory optimization: Optimization principles
02 minutes59 seconds; MyISAM memory optimization
04 minutes07 seconds; InnoDB memory optimization
06 minutes08 seconds
Chapter16mysql concurrency parameter adjustment: Concurrency parameter adjustment
10 minutes23 seconds
Chapter17mysql lock problem: Overview and classification of locks
04 minutes02 seconds; mysql support for locks
02 minutes30 seconds; MyISAM table lock-read lock
07 minutes55 seconds; MyISAM table lock - write lock
04 minutes11 seconds; Summary of MyISAM table locks
02 minutes43 seconds; MyISAM table lock-view lock contention
04 minutes22 seconds; InnoDB row lock-introduction and background knowledge
07 minutes14 seconds; InnoDB row lock-type
02 minutes04 seconds; InnoDB row lock-basic demo
08 minutes54 seconds; InnoDB row lock-row lock upgraded to table lock
05 minutes59 seconds; InnoDB row lock-gap lock hazards
05 minutes54 seconds; InnoDB row lock-contention view
02 minutes09 seconds; InnoDB row lock-summary
03 minutes27 seconds
Chapter18Common SQL skills: SQL execution order and regular expressions
05 minutes58 seconds; Numeric and string functions
07 minutes28 seconds; Date functions and aggregate functions
03 minutes04 seconds; Course content
01 minutes19 seconds; Commonly used tools mysql
03 minutes38 seconds; Commonly used tools-mysqladmin
03 minutes29 seconds; Commonly used tools-mysqlbinlog and mysqldump
10 minutes51 seconds; Commonly used tools-mysqlimport and source
02 minutes30 seconds; Commonly used tools mysqlshow
03 minutes00 seconds
Chapter19mysql log: error log
03 minutes31 seconds; Binary log
08 minutes29 seconds; Binary log (row and log deletion)
08 minutes40 seconds; Query log
04 minutes23 seconds; Slow query log
09 minutes15 seconds
Chapter20mysql copy: Copy principle
05 minutes28 seconds; Cluster construction
11 minutes28 seconds
Chapter21Comprehensive case: Requirements and environment preparation
06 minutes31 seconds; Basic project import
08 minutes28 seconds; AOP logging
14 minutes35 seconds; Log query backend - mapper interface
14 minutes18 seconds; Log query backend——Service
11 minutes04 seconds; Log query - front end
23 minutes55 seconds; System performance optimization analysis
04 minutes26 seconds; System performance optimization - paging optimization
16 minutes17 seconds; System performance optimization - index optimization
11 minutes48 seconds; Read-Write Separation Overview
04 minutes36 seconds; Data source configuration
12 minutes39 seconds; System performance optimization - AOP switching data source
08 minutes23 seconds; System performance optimization - AOP switching data source 2; System performance optimization - application optimization
04 minutes32 seconds

部分浏览器不支持，请下载APP观看

Next Section： MyISAM表锁小结879 plays

A complete set of MySQL tutorials - MySQL hot interview questions

部分浏览器不支持，请下载APP观看

Next Section： MyISAM表锁小结879 plays

A complete set of MySQL tutorials - MySQL hot interview questions

Allpost a note