# NTES_MySQL_notes

**Repository Path**: qiaodian/NTES_MySQL_notes

## Basic Information

- **Project Name**: NTES_MySQL_notes
- **Description**: 网易云课堂MySQL微专业学习笔记
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2019-11-26
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# NTES_MySQL_notes

网易云课堂MySQL微专业学习笔记

但愿可以不弃坑。

## 目录

* [数据库基础](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter1.md#mysql数据库基础)
  * [1.1-认识MySQL](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter1.md#11-认识mysql)
  * [1.2-轻松安装MySQL](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter1.md#12-轻松安装mysql)
  * [1.3-MySQL数据库连接](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter1.md#13-mysql数据库连接)
  * [1.4-SQL语言入门](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter1.md#14-sql语言入门)
  * [1.5-认识DBA](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter1.md#15-认识dba)
* [MySQL数据库对象与应用](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter2.md#mysql数据库对象与应用)
  * [2.1-MySQL数据类型](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter2.md#21-mysql数据类型)
  * [2.2-MySQL数据对象](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter2.md#22-mysql数据对象)
  * [2.3-MySQL权限管理](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter2.md#23-mysql权限管理)
  * [2.4-SQL语言进阶](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter2.md#24-sql语言进阶)
  * [2.5-内置函数](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter2.md#25-内置函数)
  * [2.6-触发器与存储过程](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter2.md#26-触发器与存储过程)
  * [2.7-MySQL字符集](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter2.md#27-mysql字符集)
  * [2.8程序连接MySQL](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter2.md#28程序连接mysql)
  * [2.9-DAO框架的使用](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter2.md#29-dao框架的使用)
* [MySQL事务与存储引擎](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter3.md#mysql事务与存储引擎)
  * [3.1-数据库事务](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter3.md#31-数据库事务)
  * [3.2-存储引擎概述](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter3.md#32-存储引擎概述)
  * [3.3-InnoDB存储引擎](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter3.md#33-innodb存储引擎)
  * [3.4-InnoDB事务锁](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter3.md#34-innodb事务锁)
* [MySQL应用优化](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter4.md#mysql应用优化)
  * [4.1-MySQL索引优化与设计](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter4.md#41-mysql索引优化与设计)
  * [4.2-MySQL数据库设计](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter4.md#42-mysql数据库设计)
  * [4.3-MySQL容量评估](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter4.md#43-mysql容量评估)
  * [4.4-MySQL性能测试](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter4.md#44-mysql性能测试)
* [MySQL运维实践](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter5.md#mysql运维实践)
  * [5.1-MySQL日志系统](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter5.md#51-mysql日志系统)
  * [5.2-MySQL数据备份](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter5.md#52-mysql数据备份)
  * [5.3-MySQL数据恢复](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter5.md#52-mysql数据恢复)
  * [5.4-MySQL线上部署](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter5.md#54-mysql线上部署)
  * [5.5-MySQL主从复制](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter5.md#55-mysql主从复制)
  * [5.6-MySQL日常运维](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter5.md#56-mysql日常运维)
  * [5.7-MySQL参数调优](https://github.com/yumendy/NTES_MySQL_notes/blob/master/chapter5.md#57-mysql参数调优)