-
Phase I: Enterprise MySQL Database Introduction Essential Linux Foundation
Learning schedule: 2 tests every 2 weeks
Features: Part of the content in this stage is prepared for students with zero foundation or without any foundation of Linux operating system. The introduction is guided by practice, so that students can quickly grasp the foundation and enter the database field.
Chapter 1: MySQL Database Career Prospects and Learning Guidelines
Chapter 2: Basic knowledge of Linux operating system
Chapter 3: VMware Virtual Machine Installation Configuration
Chapter 4: Linux System Download and Installation (Red Hat RHEL Linux)
Chapter 5: Linux System Download and Installation (CentOS)
Chapter 6: Linux system download and installation (Oracle Linux)
Chapter 7: Linux System Download and Installation (SUSE/openSUSE)
Chapter 8: Linux System Download and Installation (Ubuntu)
Chapter 9: Linux System Download and Installation (Kirin/UOS/Huawei)
Chapter 10: Linux system remote login and file transfer
Chapter 11: Linux Device Types and File Directory Structure
Chapter 12: Linux boot on/off and process management
Chapter 13: Linux Text Editing and Task Planning
Chapter 14: Linux Network Management and Network Commands
Chapter 15: Linux Disk Partitioning and File System Management
Chapter 16: Linux LVM Logical Volume Management
Chapter 17: Linux File Directory Class Commands
Chapter 18: Linux User Permission Commands
Chapter 19: Linux Software Installation and Warehouse Management
Chapter 20: Linux System Services and Network Security
Chapter 21: Introduction and Improvement of Linux Shell Script Programming
Request course outline
-
Phase II: Basic Introduction to Enterprise MySQL Database and Project Practice
Learning schedule: 2 tests every 2 weeks
Features: This stage explains the implementation and simple management of basic projects of MySQL database, which is very practical, with enterprise project practice as the leading explanation.
Chapter 1: MySQL Database Basic Introductory Training Course
Chapter 2: Introduction to MySQL Installation, Configuration and Management on Windows Platform
Chapter 3: Getting Started with MySQL Installation, Configuration and Management on Linux Platform
Chapter 4: Getting Started with the Installation, Configuration and Management of MariaDB on Linux Platform
Chapter 5: Introduction to Percona Installation Configuration and Management on Linux Platform
Chapter 6: MySQL multi instance technology and project implementation
Chapter 7: MySQL 8.0 Installation Configuration and Version Upgrade on Linux Platform
Request course outline
-
Stage 3: Enterprise MySQL Database SQL Language Development and Application Practice
Learning schedule: 2 tests every 2 weeks
Features: In this stage, the MySQL language, the management and development of MySQL common objects, the modeling design and reverse engineering of databases will be explained, with the enterprise project practice as the leading explanation, which is very practical.
Chapter 1: Basic Introduction to SQL Language and MySQL Data Type
Chapter 2: MySQL table management and SQL statement addition, deletion and modification
Chapter 3: SQL Query
Chapter 4: MySQL Object Management and Development and Database Modeling Design
Chapter 5: Application of MySQL User defined Functions and Built in Functions
Request course outline
-
Stage 4: Basic and core analysis of enterprise level MySQL database
Learning schedule: 2 tests every 2 weeks
Features: This stage starts with source code level analysis to deeply explain MySQL core technology, InnoDB storage engine management, locks and in-depth analysis of things. It focuses on actual combat and is very practical.
Chapter 1: Introduction to MySQL Initialization Process and Source Code Analysis
Chapter 2: Basic Functions and Parameter Files of MySQL Database
Chapter 3: MySQL User Rights and Security Management
Chapter 4: In depth Analysis and Management of MySQL InnoDB Storage Engine
Chapter 5: MySQL InnoDB lock and transaction in-depth analysis
Request course outline
-
Phase V: Enterprise MySQL database backup and recovery practice
Learning schedule: 2 tests every 2 weeks
Features: This stage explains MySQL backup and recovery technology, involving a large number of logical and physical backup and recovery cases of the production environment. It focuses on enterprise project practice, which is very practical.
Chapter 1: MySQL database backup, recovery and storage disaster tolerance
Chapter 2: Deep parsing and application of MySQL binary logs
Chapter 3: MySQL Logical Backup Recovery Practice 1: mysqldump and mysqlpump
Chapter 4: Mydumper of MySQL Logical Backup Recovery Practice 2
Chapter 5: MySQL Physical Backup Recovery Practice 1 - XtraBackup
Chapter 6: MySQL Physical Backup Recovery Practice 2: mysqlbackup
Chapter 7: Load Data and Outfile of MySQL Data Import and Export
Chapter 8: MySQL 8.0 Backup Recovery Comprehensive Project
Request course outline
-
Stage 6: Enterprise level MySQL high availability replication and distributed cluster architecture
Learning schedule: 5 tests in 5 weeks
Features: This stage is the most important part of MySQL database, which is a necessary high-end skill for MySQL engineers. It explains MySQL master-slave replication/high availability cluster/read-write separation/table and database division/distributed database middleware, involving a large number of project cases. This stage of the course involves dozens of hosts/hundreds of databases/tens of millions of tables, and focuses on enterprise project practice, Extremely practical.
Chapter 1: MySQL High Availability Solution and Project Environment Preparation
Chapter 2: MySQL Master Slave Replication Project Implementation and Maintenance 01 (MySQL Replication)
Chapter 3: MySQL Master Slave Replication Project Implementation and Maintenance 02 (MySQL Group Replication)
Chapter 4: MySQL master slave replication project implementation and maintenance 03 (MHA+dual master kept)
Chapter 5: MySQL Load Balancing Solution (LVS+Retained+HAProxy)
Chapter 6: Implementation and Maintenance of Galera High Availability Cluster Project (Percona XtraDB Cluster)
Chapter 7: Implementation and Maintenance of MySQL Router Read Write Separation Project
Chapter 8: Implementation and Maintenance of MaxScale Read Write Separation Project
Chapter 9: ProxySQL Read Write Separation Middleware Project Implementation and Maintenance
Chapter 10: Implementation and maintenance of MyCat read/write separation and sub table/sub database project
Chapter 11: MySQL 8.0 Master Slave Replication Cluster Comprehensive Project
Chapter 12: MySQL 8.0 InnoDB Cluster Project
Request course outline
-
Stage 7: Performance optimization and O&M diagnosis of enterprise MySQL database
Learning schedule: 3 tests in 3 weeks
Features: In this stage, the daily operation and maintenance diagnosis of MySQL database and the performance optimization of tens of millions of data volume are explained in detail, which is a necessary skill in the operation and maintenance process.
Chapter 1: MySQL Performance Benchmarking
Chapter 2: MySQL Table Partition Management
Chapter 3: MySQL Operating System Performance Tools
Chapter 4: MySQL Operation, Maintenance and Diagnosis Tools
Chapter 5: MySQL Performance Analysis and Adjustment
Chapter 6: MySQL Automatic Operation, Maintenance and Monitoring
Request course outline
-
Stage 8: Enterprise NoSQL Internet mainstream unstructured database
Learning schedule: 2 tests every 2 weeks
Features: In this stage, practical learning is carried out for the currently mainstream NoSQL databases Memcache, Redis, and MongoDB, which are essential skills and interview bonus items for senior MySQL database engineers.
Chapter 1: Memcache Database Foundation and Project Practice
Chapter 2: Redis Database Foundation and Project Practice
Chapter 3: MongoDB Database Foundation and Project Practice
Request course outline
-
Stage 9: Career guidance and regular live broadcast of enterprise level MySQL senior engineers
Learning schedule: 1 week
Features: This stage is an essential course for career development, which summarizes the learning of MySQL database, provides employment guidance, prepares resumes, and improves learning communication and communication skills.
Chapter 1: Learning summary and employment guidance
Chapter 2: Resume Preparation and Interview Guidance
Chapter 3: Live communication courses once a month
Request course outline