【老男孩教育】2020年 MySQL 开年标杆班 #郭加磊老师
转载于 https://www.oldboyedu.com/
郭老师B站号：https://space.bilibili.com/408186671
老师拥有10多年的数据库从业经验，认证专家，精通虚拟化、linux技术，讲课风趣有意思！今年的新课程，讲的很不错，
【老男孩教育/路飞的使命：为学员提供高质量IT课程和服务，帮助年轻人通过努力学习获得体面工作和生活】
视频选集
（33/127）
1.2020-开年标杆班-day01-MySQL课程介绍
25:32
2.2020-开年标杆班-day01-MySQL-数据库产品介绍
39:48
3.2020-开年标杆班-day01-MySQL-企业版本选择
24:12
4.2020-开年标杆班-day01-MySQL-5728二进制包安装
59:46
5.2020-开年标杆班-day01-MySQL-工作模型及实例
45:02
6.2020-开年标杆班-day01-MySQL-mysqld程序结构
35:58
7.2020-开年标杆班-day01-MySQL-mysqld物理存储结构简介
01:08:03
1.2020-开年标杆班-day02-MySQL上节回顾
44:20
2.2020-开年标杆班-day02-MySQL-用户管理
29:58
3.2020-开年标杆班-day02-MySQL-权限管理
01:10:56
4.2020-开年标杆班-day02-MySQL-连接管理
39:44
5.2020-开年标杆班-day02-MySQL-初始化配置管理
37:15
6.2020-开年标杆班-day02-MySQL-启动和关闭
16:57
7.2020-开年标杆班-day02-MySQL-同版本多实例配置
22:04
1.2020-开年标杆班-day03-MySQL上节回顾
34:35
10.2020-开年标杆班-day03-MySQL-DDL-库定义
26:11
11.2020-开年标杆班-day03-MySQL-DDL-表定义-建表
19:35
12.2020-开年标杆班-day03-MySQL-DDL-表定义-建表规范说明
19:01
13.2020-开年标杆班-day03-MySQL-DDL-表定义-练习题讲解
09:36
14.2020-开年标杆班-day03-MySQL-DDL-表定义-修改-删除
13:12
2.2020-开年标杆班-day03-MySQL-SQL介绍
17:08
3.2020-开年标杆班-day03-MySQL-SQL_MODE介绍
18:42
4.2020-开年标杆班-day03-MySQL-字符集和校对规则
29:35
5.2020-开年标杆班-day03-MySQL-数据类型-1
01:01:28
6.2020-开年标杆班-day03-MySQL-数据类型-2
09:06
7.2020-开年标杆班-day03-MySQL-数据类型-3
13:18
8.2020-开年标杆班-day03-MySQL-约束和属性
12:19
9.2020-开年标杆班-day03-MySQL-客户端内置命令
12:05
1.2020-开年标杆班-day04-MySQL上节回顾
52:13
10.2020-开年标杆班-day04-MySQL-DQL-Select -应用-3-group by 语句应用
35:59
11.2020-开年标杆班-day04-MySQL-DQL-Select -应用-3-作业及明日安排
08:01
2.2020-开年标杆班-day04-MySQL-产品开发流程
11:36
3.2020-开年标杆班-day04-MySQL-DDL扩展
48:32
4.2020-开年标杆班-day04-MySQL-DML-insert应用
18:53
5.2020-开年标杆班-day04-MySQL-DML-update,delete应用
24:58
6.2020-开年标杆班-day04-MySQL-DQL-Select 独立使用
24:49
7.2020-开年标杆班-day04-MySQL-DQL-Select -学习环境准备
25:20
8.2020-开年标杆班-day04-MySQL-DQL-Select -应用-1
20:41
9.2020-开年标杆班-day04-MySQL-DQL-Select -应用-2
22:17
1.2020-开年标杆班-day05-MySQL上节回顾
38:24
10.2020-开年标杆班-day05-MySQL-元数据介绍
22:45
11.2020-开年标杆班-day05-MySQL-I_S.tables介绍
17:37
12.2020-开年标杆班-day05-MySQL-I_S.tables应用案例
29:07
2.2020-开年标杆班-day05-MySQL-select having order by limit
23:56
3.2020-开年标杆班-day05-MySQL-select 多表连接查询介绍
42:32
4.2020-开年标杆班-day05-MySQL-select 多表连接查询例子讲解
41:53
5.2020-开年标杆班-day05-MySQL-select -外连接应用场景
36:39
6.2020-开年标杆班-day05-MySQL-select 多表连接优化-强制驱动表
09:31
7.2020-开年标杆班-day05-MySQL-select 别名应用
13:12
8.2020-开年标杆班-day05-MySQL-select补充内容
07:35
9.2020-开年标杆班-day05-MySQL-show语句介绍
17:08
1.2020-开年标杆班-day06-MySQL上节回顾
49:44
2.2020-开年标杆班-day06-MySQL上节回顾-2
20:59
3.2020-开年标杆班-day06-MySQL-Btree介绍及算法结构图
31:38
4.2020-开年标杆班-day06-MySQL-聚簇索引BTREE结构
38:05
5.2020-开年标杆班-day06-MySQL-辅助索引BTREE结构
39:21
6.2020-开年标杆班-day06-MySQL-辅助索引细分
13:06
7.2020-开年标杆班-day06-MySQL-联合索引应用
08:59
8.2020-开年标杆班-day06-MySQL-索引树高度问题
15:43
9.2020-开年标杆班-day06-MySQL-索引压测
56:24
1.2020-开年标杆班-day07-MySQL上节回顾-回表问题
28:04
2.2020-开年标杆班-day07-MySQL上节回顾--2
30:16
3.2020-开年标杆班-day07-MySQL执行计划介绍
18:54
4.2020-开年标杆班-day07-MySQL执行计划-各字段说明
31:58
5.2020-开年标杆班-day07-MySQL执行计划-key_len
30:12
6.2020-开年标杆班-day07-MySQL-建索引的规范
30:29
7.2020-开年标杆班-day07-MySQL-不走索引情况
21:06
8.2020-开年标杆班-day07-MySQL-不走索引情况-2
17:17
9.2020-开年标杆班-day07-MySQL-索引自由化+ICP介绍
51:02
1.2020-开年标杆班-day08-MySQL上节回顾-1
36:20
10.2020-开年标杆班-day08-MySQL-存储引擎-微观结构-事务日志介绍
13:14
11.2020-开年标杆班-day08-MySQL-存储引擎-学生案例
15:36
2.2020-开年标杆班-day08-MySQL上节回顾-2
33:15
3.2020-开年标杆班-day08-MySQL-存储引擎介绍
38:39
4.2020-开年标杆班-day08-MySQL-存储引擎-InnoDB核心特性介绍
12:51
5.2020-开年标杆班-day08-MySQL-存储引擎基础操作命令
23:34
6.2020-开年标杆班-day08-MySQL-存储引擎基础操作命令-2
09:23
7.2020-开年标杆班-day08-MySQL-存储引擎-宏观体系结构
44:50
8.2020-开年标杆班-day08-MySQL-存储引擎-微观结构-redo
13:03
8.2020-开年标杆班-day08-MySQL-存储引擎-微观结构-表空间
51:01
9.2020-开年标杆班-day08-MySQL-存储引擎-微观结构-事务日志介绍
09:21
1.2020-开年标杆班-day09-MySQL上节回顾
42:07
2.2020-开年标杆班-day09-MySQL-事务介绍
40:02
3.2020-开年标杆班-day09-MySQL-事务生命周期管理
39:54
4.2020-开年标杆班-day09-MySQL-事务中的一些关键名词介绍
19:06
5.2020-开年标杆班-day09-MySQL-事务ACID实现-redo功能
43:39
6.2020-开年标杆班-day09-MySQL-事务ACID实现-redo刷新参数说明
15:13
7.2020-开年标杆班-day09-MySQL-事务ACID实现-undo的功能
41:56
8.2020-开年标杆班-day09-MySQL-事务ACID实现-事务的隔离界别
01:16:49
1.2020-开年标杆班-day10-MySQL-InnoDB锁介绍
57:24
2.2020-开年标杆班-day10-MySQL-InnoDB锁的演示
29:46
3.2020-开年标杆班-day10-MySQL-InnoDB一致性问题总结
28:48
4.2020-开年标杆班-day10-MySQL-InnoDB核心参数介绍
40:53
5.2020-开年标杆班-day10-MySQL-日志管理-错误日志
15:18
6.2020-开年标杆班-day10-MySQL-日志管理-binlog介绍及设置
19:46
7.2020-开年标杆班-day10-MySQL-日志管理-binlog记录内容详解
11:45
8.2020-开年标杆班-day10-MySQL-日志管理-binlog-event记录单元
05:39
9.2020-开年标杆班-day10-MySQL-日志管理-binlog-event查看
24:25
1.2020-开年标杆班-day11-MySQL-上节回顾
57:22
2.2020-开年标杆班-day11-MySQL-binlog日志内容查看
21:55
3.2020-开年标杆班-day11-MySQL-binlog日志恢复案例
18:52
4.2020-开年标杆班-day11-MySQL-binlog日志恢弊端
24:50
5. 2020-开年标杆班-day11-MySQL-binlog其他相关操作
18:02
6. 2020-开年标杆班-day11-MySQL-binlog——gtid介绍及开启
18:55
7. 2020-开年标杆班-day11-MySQL-binlog_gtid模式下的日志截取例子
11:38
8. 2020-开年标杆班-day11-MySQL-binlog_gtid模式下的数据恢复
25:53
9. 2020-开年标杆班-day11-MySQL-slowlog介绍及配置
12:07
10. 2020-开年标杆班-day11-MySQL-slowlog分析处理
19:03
1.2020-开年标杆班-day12-MySQL-上节回顾
29:54
2.2020-开年标杆班-day12-MySQL-备份恢复-职责
35:42
3.2020-开年标杆班-day12-MySQL-备份恢复-mysqldump基础参数
42:07
4.2020-开年标杆班-day12-MySQL-备份恢复-mysqldump高级参数-master-data介绍
23:33
5.2020-开年标杆班-day12-MySQL-备份恢复-mysqldump高级参数--2
26:41
6.2020-开年标杆班-day12-MySQL-备份恢复-mysqldump+binlog恢复案例-1
38:02
7.2020-开年标杆班-day12-MySQL-备份恢复-mysqldump+binlog恢复案例-1
13:40
8.2020-开年标杆班-day12-MySQL-备份恢复-mysqldump+小结
28:11
9.2020-开年标杆班-day12-MySQL-备份恢复-xbk介绍及基本使用
54:26
1.2020-开年标杆班-day13-MySQL-上节回顾
14:11
2.2020-开年标杆班-day13-MySQL-xbk增量备份恢复逻辑
25:47
3.2020-开年标杆班-day13-MySQL-xbk增量备份演示
19:55
4.2020-开年标杆班-day13-MySQL-xbk full_inc_binlog恢复案例讲解
44:00
5.2020-开年标杆班-day13-MySQL-xbk 小彩蛋
16:26
6.2020-开年标杆班-day13-MySQL-主从复制介绍及搭建
43:50
7.2020-开年标杆班-day13-MySQL-主从复制工作中应用的资源
24:28
8.2020-开年标杆班-day13-MySQL-主从复制原理图
22:29
9.2020-开年标杆班-day13-MySQL-主从复制原理文字说明
15:13
10.2020-开年标杆班-day13-MySQL-主从复制监控
18:03
爆肝30天！我做了一款《跳跳史莱姆》游戏！！
点击体验>>
顶部