Community
Articles
Topics
Q&A
Learn
Course
Programming Dictionary
Tools Library
Development tools
Website Source Code
PHP Libraries
JS special effects
Website Materials
Extension plug-ins
Leisure
Game Download
Game Tutorials
English
简体中文
English
繁体中文
日本語
한국어
Melayu
Français
Deutsch
Login
singup
Next Section: Commonly used tools-mysqlbinlog and mysqldump
(954 plays)
Next Section
Watch Again
ဆ
Chapter
Note
Ask
Courseware
Feedback
A complete set of MySQL tutorials - MySQL hot interview questions
Chapter1 Course introduction and mysql installation
1-1 Course content introduction
1-2 Install mysql on linux
1-3 Start and log in to mysql
Chapter2 mysql index
2-1 Index overview
2-2 Advantages and disadvantages
2-3 data structure
2-4 Data structure-BTREE
2-5 Data structure-B+TREE
2-6 Index classification
2-7 Index syntax
2-8 Index design principles
Chapter3 view
3-1 Overview
3-2 Create and modify views
3-3 View and delete views
Chapter4 stored procedure
4-1 Stored procedures overview
Chapter5 grammar
5-1 Create call query delete syntax
5-2 variable
5-3 if judgment
Chapter6 Input and output parameters
6-1 Input parameters
6-2 Output parameters
Chapter7 case structure and loop
7-1 case structure
7-2 while loop
7-3 repeat loop
7-4 loop loop
Chapter8 cursor
8-1 Cursor introduction
8-2 Basic cursor operations
8-3 Loop to get cursor
Chapter9 Functions and triggers
9-1 function
9-2 Introduction to triggers
9-3 Trigger creation and application
9-4 View and delete triggers
9-5 Content summary
Chapter10 Architecture and Storage Engine
10-1 Architecture
10-2 Storage engine overview
10-3 Storage engine features
10-4 InnoDB characteristics
10-5 MyISAM features
10-6 Memory and Merge features
10-7 Storage engine selection principles
Chapter11 Optimize SQL steps
11-1 SQL execution frequency
11-2 Locate inefficient SQL
11-3 Introduction to explain command
11-4 explain id
11-5 explain之select_type
11-6 explain之table type
11-7 key rows extra
11-8 show profile
11-9 trace tool
Chapter12 Use of index
12-1 Verify index to improve query efficiency
12-2 Match all values
12-3 leftmost prefix rule
12-4 Failure conditions (range query, field operation)
12-5 covering index
12-6 Index failure
12-7 like fuzzy matching
12-8 Full table scan is faster
12-9 Judgment of NULL value
12-10 in和not in
12-11 Single column index and compound index selection
12-12 View index usage
Chapter13 SQL optimization
13-1 Insert data in bulk
13-2 insert optimization
13-3 orderby optimization
13-4 group by optimization
13-5 subquery optimization
13-6 or optimize
13-7 limit optimization
13-8 index hint
13-9 Content summary
Chapter14 Application optimization
14-1 Application optimization
14-2 Query caching-overview and process
14-3 Query cache-configuration parameters
14-4 Query cache-enable query cache
14-5 Query cache—SELECT options
14-6 Query cache - failure scenario
Chapter15 Memory optimization
15-1 Optimization principles
15-2 MyISAM memory optimization
15-3 InnoDB memory optimization
Chapter16 mysql concurrency parameter adjustment
16-1 Concurrency parameter adjustment
Chapter17 mysql lock problem
17-1 Overview and classification of locks
17-2 mysql support for locks
17-3 MyISAM table lock-read lock
17-4 MyISAM table lock - write lock
17-5 Summary of MyISAM table locks
17-6 MyISAM table lock-view lock contention
17-7 InnoDB row lock-introduction and background knowledge
17-8 InnoDB row lock-type
17-9 InnoDB row lock-basic demo
17-10 InnoDB row lock-row lock upgraded to table lock
17-11 InnoDB row lock-gap lock hazards
17-12 InnoDB row lock-contention view
17-13 InnoDB row lock-summary
Chapter18 Common SQL skills
18-1 SQL execution order and regular expressions
18-2 Numeric and string functions
18-3 Date functions and aggregate functions
18-4 Course content
18-5 Commonly used tools mysql
18-6 Commonly used tools-mysqladmin
18-7 Commonly used tools-mysqlbinlog and mysqldump
18-8 Commonly used tools-mysqlimport and source
18-9 Commonly used tools mysqlshow
Chapter19 mysql log
19-1 error log
19-2 Binary log
19-3 Binary log (row and log deletion)
19-4 Query log
19-5 Slow query log
Chapter20 mysql copy
20-1 Copy principle
20-2 Cluster construction
Chapter21 Comprehensive case
21-1 Requirements and environment preparation
21-2 Basic project import
21-3 AOP logging
21-4 Log query backend - mapper interface
21-5 Log query backend——Service
21-6 Log query - front end
21-7 System performance optimization analysis
21-8 System performance optimization - paging optimization
21-9 System performance optimization - index optimization
21-10 Read-Write Separation Overview
21-11 Data source configuration
21-12 System performance optimization - AOP switching data source
21-13 System performance optimization - AOP switching data source 2
21-14 System performance optimization - application optimization
Previous section
Next Section
Tutorial List
get help
Course Recommendations
Courseware download
Elementary
Imperial CMS enterprise imitation website tutorial
3048 people are watching
Elementary
Newbies with zero foundation in WordPress build personal blogs and corporate websites
6743 people are watching
Elementary
Ultimate CMS zero-based website building instruction video
2724 people are watching
Elementary
Front-end project-Shangyou [HTML/CSS/JS technology comprehensive practice]
3117 people are watching
Intermediate
Vue3.0 from 0 to build a universal backend management system project practice
5351 people are watching
Elementary
Zero-based front-end course [Vue advanced learning and practical application]
2821 people are watching
Elementary
WEB front-end tutorial [HTML5+CSS3+JS]
3506 people are watching
Elementary
Quick introduction to apipost
2161 people are watching
Intermediate
Vue3+TypeScript practical tutorial-enterprise-level project practice
3208 people are watching
Elementary
Let's briefly talk about starting a business in PHP
17423 people are watching
Intermediate
VUE e-commerce project (front-end & back-end dual project actual combat)
3828 people are watching
Elementary
Apipost practical application [api, interface, automated testing, mock]
2265 people are watching
MySQL full set of tutorial related courseware
Belongs to chapter:A complete set of MySQL tutorials - MySQL hot interview questions
Download
Students who have watched this course are also learning
492410 plays
Let's briefly talk about starting a business in PHP
Quick introduction to web front-end development
Large-scale practical Tianlongbabu development of Mini version MVC framework imitating the encyclopedia website of embarrassing things
Getting Started with PHP Practical Development: PHP Quick Creation [Small Business Forum]
Login verification and classic message board
Computer network knowledge collection
Quick Start Node.JS Full Version
The front-end course that understands you best: HTML5/CSS3/ES6/NPM/Vue/...[Original]
Write your own PHP MVC framework (40 chapters in depth/big details/must read for newbies to advance)
notes
X