MySQL Network training Boutique class-inside June Kang Pro

Source: Internet
Author: User
Tags mysql version mysql backup mysql index

Nside's MySQL Network training course features:
The industry's most authoritative MySQL database trainer Kang Teacher (that is, inside June himself) pro-Grant. Kang published the MySQL Technology insider: InnoDB storage engine, MySQL kernel: InnoDB storage engine, and so on.
The course closely combines the practice of Internet companies, students can appreciate the bat, NetEase and other large companies database architecture and application cases
With the latest MySQL version 5.6 and 5.7, students are learning the latest content.
Students who fully master the content of the course have a yearly salary of at least 25W, and the 1th period has proved the value of the training.
Excellent students can get the push of big internet companies such as Ms. Ginger's bat
Interview Skills and resume templates (added) to help students get a better offer

MySQL installation with engine
Day001-mysql 5.7 Introduction and installation
Day002-mysql 5.7 Installing multiple instances
Day003-mysql Upgrade Parameters Connection permissions
Day004-mysql Permissions Supplements role Simulation Workbench architecture
Day005-slow_log Generic_log Audit Storage Engine One
day006-Storage Engine Two multi-instance installation
Day007-mysql Multiple instances of SSL
MySQL data types and SQL query development
Day008-mysql Data types
day009-proficient in JSON type
Day010-employees Creating a FOREIGN KEY constraint on a temporary table
Day011-sql syntax of SELECT
day012-Sub-query INSERT UPDATE DELETE REPLACE
day013-assignment on a Rank view UNION trigger
Stored procedure custom functions under day014-triggers
MySQL Execution Plan and optimizer
day015-Index B + Tree
day016-index B + tree under Explain 1
Day017-explain 2
MySQL InnoDB Engine Optimization
day018-disk
day019-Disk Test
Day020-innodb_1 Table Space General
day021-innodb_2 spaceid.pagenumber Compression table)
Day022-innodb_3 Transparent table Space Compressed Index Organization table
Day023-innodb_4 page (2) Row record
Day024-innodb_5–heap_number Buffer Poo
Day025-innodb_6 Buffer Pool with compressed page CheckPoint LSN
Day026-innodb_7 doublewrite Changebuffer AHI FNP
MySQL Index and InnoDB lock mechanism
Day027-secondary Index
Day028-join algorithm Lock _1
day029-Lock _2
day030-Lock _3
day031-Lock _4
day032-Lock _5
day032-Lock 5 SD
day033-Lock _6 Things _1
day033-lock _6 Things 1 SD
day034-things _2
MySQL Performance measurement
Day035-redo_binlog_xa
Day036-undo_sysbench
Day036-undosysbench SD
Day037-tpcc_mysqlslap
MySQL Backup and Recovery
Day038-purge Dead Lock Example _mysql backup _1
Day039-mysql Backup Restore _2
MySQL replication technology with high availability
Day040-mysql Backup Recovery backup_3_replication_1
Day041-backup_4-replication_2
Day042-replication_3
Day043-replication_4-gtid 1
Day044-replication_5-gtid 2

: http://www.itsource.com.cn/thread-3054-1-1.html

MySQL Network training Boutique class-inside June Kang Pro

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.