Course name reading

Times; &amp
Beneficiary: Jiangsu knowledge of the Computer Co., Ltd. Price reading
Alipay to pay
WeChat payment

After paying the success of the page automatically jump, please do not close the window in the payment process.

  • curriculum> data base> MySQL> Subversion of the traditional]web class MySQL subversion combat
  • Subversion of the traditional]web class MySQL subversion combat

  • Provide technical support from Baidu
    Course catalog
    Chapter 1: MySQL million level data warm-up
    • 1 War: the design of a project needs, irrigation ten thousand data (free)
    • 33:36
    • 2 user login: (a) using a unique index (free)
    • 30:20
    • 3 user login (two): a method for storing user operation log
    • 11:54
    • 4 commodity system design (1): Commodity master table design
    • 26:21
    • 5 commodity system design (two): regular update of the total amount of goods
    • 23:55
    • 6 commodity system design (three): the fixed attribute of commodity attribute design (free)
    • 23:11
    • 7 commodity system design (four): the custom attribute of commodity attribute design
    • 13:16
    • 8 commodity system design (five): one dimensional attribute of commodity price list design
    • 26:38
    • 9 study MySQL affairs: the vernacular understands business
    • 16:32
    • 10 MySQL custom exception handling how to break
    • 23:27
    • 11 users recharge functions (a): when the server what happened 7 seconds Caton (free)
    • 24:29
    • 12 user recharge function implementation (two): the security of the table level lock
    • 14:43
    • 13 user recharge function implementation (three): learning MySQL in the row level lock
    • 21:02
    • 14 supplementary class: the realization of user transfer function
    • 16:12
    • 15 types of micro-blog topic and multi-layer comment function: function structure design
    • 19:27
    • 16 types of micro-blog topic and multi-layer comment function (two): how to load the topic of master data
    • 14:09
    • 17 types of micro-blog topic and multi-layer comment function (three): to achieve a review and the combination of web page update comments
    • 15:33
    • The display of 18 types of micro-blog nested Reviews
    • 25:27
    The second chapter: large data table query optimization
    • 1 data query optimization (1): type index refinement in explain
    • 34:51
    • 2 data sheet query optimization (two): the first step in the elegant product page
    • 21:30
    • 3 data sheet query optimization (three): like and full text index when there is a query condition
    • 21:15
    • 4 data sheet query optimization (four): MySQL stunning partition function
    • 31:25
    • 5 using the combination of PHP in the large scale data table to achieve by popularity, classification and year of the joint conditions of the query
    • 19:36
    The third chapter: MySQL master and slave optimization
    • 1 MySQL master slave configuration (one): the secret of MySQL log and disaster recovery
    • 18:49
    • 2 MySQL master slave configuration (two): configure MySQL master slave service
    • 22:05
    The fourth chapter: small group of friends of redis actual combat learning
    • 1 easy quick start redis small base friends MySQL
    • 26:29
    • 2 redis store user table information, simple analog login
    • 24:16
    • 3 MySQL data import to redis some of the fun of the knowledge point
    • 22:51
    • 4 direct interaction between MySQL and MySQL: " " redis;
    • 40:24
    • 5 using C to call Redis super simple method
    • 19:43
    • 6 MySQL and redis integration, using SQL call redis
    • 16:56
    The fifth chapter: MySQL's small group of friends (two): memcached
    • 1 learning MySQL another small group of friends: memcached
    • 21:03
    • 2 combined with libmemcached pure hand to achieve MySQL direct call memcached
    • 24:17
    The sixth chapter: the study of MySQL Middleware
    • 1 MySQL middleware MyCat configuration (on): multi node access data
    • 33:23
    • 2 MySQL middleware MyCat configuration (lower): read and hang a master-slave server
    • 20:02
    • Brief analysis on the application of global table in 3 MYCAT (on) (free)
    • 14:03
    • 4 MYCAT global table application analysis (under): multi node from the field of processing
    • 29:06
    • 5 MYCAT data slice learning (1): the study of the enumeration
    • 20:49
    • 6 MYCAT data slice learning (two): suitable for the study of the scope of the large scale table
    • 12:42
    • 7 MYCAT data learning (three): learning by talent
    • 10:42
    • 8 MYCAT data slice learning (four): the method of model taking
    • 12:58
    • 9 MYCAT data slice learning (five): the method of dividing the mode and the range of the modules
    • 13:07
    • 10 MYCAT data slice learning (six): the slice setting of the main table and the sub table.
    • 14:18
    • 11 using PHP connection MYCAT middleware to achieve new multi node order form (free)
    • 26:43
    • 12 HAproxy+mycat+mysql simple load balancing configuration method
    • 28:07
    The seventh chapter: the actual case to explain the article
    • Design of basic information table for 1 small system
    • 21:44
    • 2 general website backstage user rights system design
    • 26:34
    • 3 face the reality of the order table design method
    • 23:21
    $280 Buy immediately Join a shopping cart
    • [course type]Actual combat Teaching [difficulty level]senior [suitable for the crowd]All
    • [course introduction]
      This course is based on the field of web development under the actual combat MySQL courses. This course will simulate a project needs, from ten thousand data to one million data to explain how to build, optimize and third party library combination process. At the same time the climax of the course: 1, mysql+memcached combined with actual combat 2, mysql+redis combined with actual combat 3, mysql+mycat (basic database middleware) used in the split in the table 4, mysql+HaProxy load balancing configuration 5, some of the actual cases to explain the design of the table.
    • [course objectives]
      The key to improve the level of web development technology is not from the development of language itself, but on the database, Linux, third party library understanding and the accumulation of practical experience in the project. This course is also starting from the database to help you find their real technical bottlenecks
    • [Course Project]
      Points 2-3 times all updated

    Chapter 1: MySQL million level data warm-up

    The second chapter: large data table query optimization

    The third chapter: MySQL master and slave optimization

    The fourth chapter: small group of friends of redis actual combat learning

    The fifth chapter: MySQL's small group of friends (two): memcached

    The sixth chapter: the study of MySQL Middleware

    The seventh chapter: the actual case to explain the article

    All evaluationZero)
    Praise (Zero)
    Middle assessment (Zero)
    Bad ratingZero)
    Published evaluation
    Shenyi
    FivecurriculumOne hundred and thirty-eight thousand and ninety-threeStudent
    IT from the media "programmer sponsors in embarrassed way", CSDN blog expert. Engaged in IT development, management, self thirteen years. Combination of actual combat technology + business IT entrepreneurs. The author of the book "unemployment" programmer
    Affiliated institutions:Programmers in the embarrassed.

    Reference knowledge base