MySQL from getting started to mastering tutorials (performance testing and tuning)

MySQL from getting started to mastering (performance testing and tuning)

Course View Address: HTTP://WWW.XUETUWUYOU.COM/COURSE/33

Courses from the School of worry-free network : http://www.xuetuwuyou.com/

Starting from the basics, all the way up to the advanced level, including but not limited to SQL statements, SQL Tuning, Database tuning excellence, interspersed with multiple cases, most of them are examples of interpretation.

Lesson 1:sql Statement Combat-1

Lesson 2:sql Statement Combat-2

Lesson 3: Advanced SQL statement Combat-1

Lesson 4: Advanced SQL statement Combat-2

Lesson 5: Storage Engine explanation

Lesson 6: Stored procedure explaining

Lesson 7: The monologue of the lock

Lesson 8: Backup and restore of data

Class 9:sql performance Test and tuning-1

Class 10:sql performance test and tuning-2

Class 11:sql performance test and tuning case-1

Class 12:sql performance test and tuning-3

Class 13:sql performance testing and tuning-Case 2

Lesson 14: Single-quote killings-Case 3

Lesson 15: Database Schema Optimization Scenarios

Lesson 16: Parameter Optimization and hardware optimization solutions

Lesson 17: Summary

MySQL from getting started to mastering tutorials (performance testing and tuning)