Course Intermediate  3422

Course Introduction：This set of courses is based on the design concept and data structure of MySQL index, index usage scenarios, index classification, index usage scenarios, index performance analysis, query optimization, slow query of MySQL index, etc. It mainly describes the solution of MySQL index optimization. It is very suitable for students who have basic knowledge of MySQL or have certain work experience. The course explains how to solve the problem of slow large-volume queries, how to write an efficient SQL, how to optimize query statements, what is the implementation principle of indexes, how to optimize indexes... and many other difficulties and interview points in SQL index optimization.

Course Elementary  12703

Course Introduction："AJAX Cross-Domain Solution: JSONP Video Tutorial" The core of ajax is the JavaScript object XmlHttpRequest. This object was first introduced in Internet Explorer 5 and is a technology that supports asynchronous requests. This video introduces the ajax cross-domain solution.

Course Intermediate  8025

Course Introduction：Caching is a core component of current enterprise-level applications. Today's mainstream e-commerce, life services, live broadcast and other fields are inseparable from the use of cache. As the current mainstream caching technology, Redis has become the first choice for Internet companies. The cache structure design based on redis cluster currently accounts for half of the market in the same field.

Course Advanced  44724

Course Introduction：This set of courses is an advanced course, including: query optimization and performance analysis of MySQL single table with tens of millions of data, mySQL master-slave principle and its application in high-concurrency systems, integration and use of Elasticsearch and PHP (Laravel), high concurrency The difference between system code and ordinary system code architecture and analysis of concerns, etc.

Course Elementary  7704

Course Introduction："Qianfeng HTML5 Tutorial Part 2: Micro-Case Explanation Video Tutorial" This set of video tutorials mainly uses small cases to let everyone understand the knowledge points learned, and achieve different interactive effects through the reasonable use of knowledge points. This learning model that combines theory and practice allows everyone to better master theory and practical applications. This is also the teaching feature of Qianfeng HTML5 discipline. Only continuous practice can improve working methods and work experience. Micro cases include various HTML5-related projects, such as page layout, cool animation effects, game development, mobile development, front-end and back-end development, etc. There are many design contents and a wide range, covering various development needs. I hope this set of micro-case teaching videos can help everyone in their study and work.

Course Intermediate  11218

Course Introduction："MySQL Data Management Backup and Recovery Case Analysis Video Tutorial" MySQL is an open source small-scale relational database management system. Currently, MySQL is widely used in small and medium-sized websites on the Internet. Due to its small size, fast speed, low total cost of ownership, and especially the characteristics of open source, many small and medium-sized websites choose MySQL as their website database in order to reduce the total cost of website ownership.

Course Advanced  18025

Course Introduction："Comprehensive Interpretation of the Laravel Framework and Practical Video Tutorial" introduces the Laravel framework and its installation methods, routing, views, basic addition, deletion, modification and query functions, as well as related knowledge points such as login and registration instances.

Course Intermediate  6900

Course Introduction：How to tune SQL according to execution plan under massive data? How does the mysql index system cope with massive data storage? How to design a mysql index with excellent performance under massive data Full analysis of clustered index and non-clustered index of mysql Must-ask nouns in mysql index interview: table return, index coverage, leftmost matching How to optimize indexes for specific SQL scenarios

Course Intermediate  11266

Course Introduction："Self-study IT Network Linux Load Balancing Video Tutorial" mainly implements Linux load balancing by performing script operations on web, lvs and Linux under nagin.

Course Advanced  17592

Course Introduction："Shangxuetang MySQL Video Tutorial" introduces you to the process from installing to using the MySQL database, and introduces the specific operations of each link in detail.