2015年8月10日
MySQL的SQL查询优化课程
M
mac
Author
12 min
Read Time
52
Views
MySQL的SQL查询优化课程
文档下载地址： https://zcdn.askmaclean.com/MySQL%E6%9F%A5%E8%AF%A2%E6%80%A7%E8%83%BD%E4%BC%98%E5%8C%96.pdf
第一课：课程介绍
https://zcdn.askmaclean.com/%E3%80%90dbDao%20IT%E5%9C%A8%E7%BA%BF%E6%95%99%E8%82%B2-%E6%B1%AA%E4%BC%9F%E5%8D%8E%E3%80%91%20MySQL%E6%9F%A5%E8%AF%A2%E6%80%A7%E8%83%BD%E4%BC%98%E5%8C%96_L1_%E8%AF%BE%E7%A8%8B%E4%BB%8B%E7%BB%8D%E5%8F%8A%E5%87%86%E5%A4%87.mp4
第二课：数据访问优化
https://zcdn.askmaclean.com/%E3%80%90dbDao%20IT%E5%9C%A8%E7%BA%BF%E6%95%99%E8%82%B2-%E6%B1%AA%E4%BC%9F%E5%8D%8E%E3%80%91%20MySQL%E6%9F%A5%E8%AF%A2%E6%80%A7%E8%83%BD%E4%BC%98%E5%8C%96_L2_%E6%95%B0%E6%8D%AE%E8%AE%BF%E9%97%AE%E4%BC%98%E5%8C%96.mp4
第三课 了解MySQL查询优化概念（1）
https://zcdn.askmaclean.com/%E3%80%90dbDao%20IT%E5%9C%A8%E7%BA%BF%E6%95%99%E8%82%B2-%E6%B1%AA%E4%BC%9F%E5%8D%8E%E3%80%91%20MySQL%E6%9F%A5%E8%AF%A2%E6%80%A7%E8%83%BD%E4%BC%98%E5%8C%96_L3_%E4%BA%86%E8%A7%A3MySQL%E6%9F%A5%E8%AF%A2%E4%BC%98%E5%8C%96%E8%BF%87%E7%A8%8B%20-%20%E6%9F%A5%E8%AF%A2%E7%9A%84%E6%89%A7%E8%A1%8C%E8%B7%AF%E5%BE%84.mp4
第四课 了解MySQL查询优化概念（2）
https://zcdn.askmaclean.com/%E3%80%90dbDao%20IT%E5%9C%A8%E7%BA%BF%E6%95%99%E8%82%B2-%E6%B1%AA%E4%BC%9F%E5%8D%8E%E3%80%91%20MySQL%E6%9F%A5%E8%AF%A2%E6%80%A7%E8%83%BD%E4%BC%98%E5%8C%96_L4_%E4%BA%86%E8%A7%A3MySQL%E6%9F%A5%E8%AF%A2%E4%BC%98%E5%8C%96%E8%BF%87%E7%A8%8B%20-%20%E4%BA%86%E8%A7%A3%E6%9F%A5%E8%AF%A2%E7%8A%B6%E6%80%81.mp4
第五课 了解EXPLAIN
https://zcdn.askmaclean.com/%E3%80%90dbDao%20IT%E5%9C%A8%E7%BA%BF%E6%95%99%E8%82%B2-%E6%B1%AA%E4%BC%9F%E5%8D%8E%E3%80%91%20MySQL%E6%9F%A5%E8%AF%A2%E6%80%A7%E8%83%BD%E4%BC%98%E5%8C%96_L5_%E4%BA%86%E8%A7%A3MySQL%E6%9F%A5%E8%AF%A2%E4%BC%98%E5%8C%96%E8%BF%87%E7%A8%8B%20-%20%E4%BA%86%E8%A7%A3EXPLAIN%E5%91%BD%E4%BB%A4%E7%9A%84%E4%BD%BF%E7%94%A8.mp4
第六课 SELECT语句优化实例
https://zcdn.askmaclean.com/%E3%80%90dbDao%20IT%E5%9C%A8%E7%BA%BF%E6%95%99%E8%82%B2-%E6%B1%AA%E4%BC%9F%E5%8D%8E%E3%80%91%20MySQL%E6%9F%A5%E8%AF%A2%E6%80%A7%E8%83%BD%E4%BC%98%E5%8C%96_L6_%E4%BC%98%E5%8C%96%E5%AE%9E%E4%BE%8B%20-%20%E5%9C%A8Select%E8%AF%AD%E5%8F%A5%E4%B8%AD%E7%B4%A2%E5%BC%95%E7%9A%84%E4%BD%BF%E7%94%A8.mp4
L7 - 优化实例 - 单个复杂查询 vs 多个简单查询
https://zcdn.askmaclean.com/%E3%80%90dbDao%20IT%E5%9C%A8%E7%BA%BF%E6%95%99%E8%82%B2-%E6%B1%AA%E4%BC%9F%E5%8D%8E%E3%80%91%20MySQL%E6%9F%A5%E8%AF%A2%E6%80%A7%E8%83%BD%E4%BC%98%E5%8C%96_L7_%E4%BC%98%E5%8C%96%E5%AE%9E%E4%BE%8B%20-%20%E5%8D%95%E4%B8%AA%E5%A4%8D%E6%9D%82%E6%9F%A5%E8%AF%A2%20vs%20%E5%A4%9A%E4%B8%AA%E7%AE%80%E5%8D%95%E6%9F%A5%E8%AF%A2.mp4
L8 - 优化实例 - JOIN语法中表顺序的影响
https://zcdn.askmaclean.com/%E3%80%90dbDao%20IT%E5%9C%A8%E7%BA%BF%E6%95%99%E8%82%B2-%E6%B1%AA%E4%BC%9F%E5%8D%8E%E3%80%91%20MySQL%E6%9F%A5%E8%AF%A2%E6%80%A7%E8%83%BD%E4%BC%98%E5%8C%96_L8_%E4%BC%98%E5%8C%96%E5%AE%9E%E4%BE%8B%20-%20JOIN%E8%AF%AD%E6%B3%95%E4%B8%AD%E8%A1%A8%E9%A1%BA%E5%BA%8F%E7%9A%84%E5%BD%B1%E5%93%8D.mp4
L9 - 优化实例 - 子查询，Exists，表连接？谁是最优之选
https://zcdn.askmaclean.com/%E3%80%90dbDao%20IT%E5%9C%A8%E7%BA%BF%E6%95%99%E8%82%B2-%E6%B1%AA%E4%BC%9F%E5%8D%8E%E3%80%91%20MySQL%E6%9F%A5%E8%AF%A2%E6%80%A7%E8%83%BD%E4%BC%98%E5%8C%96_L9_%E4%BC%98%E5%8C%96%E5%AE%9E%E4%BE%8B%20-%20%E5%AD%90%E6%9F%A5%E8%AF%A2%EF%BC%8CExists%EF%BC%8C%E8%A1%A8%E8%BF%9E%E6%8E%A5%EF%BC%9F%E8%B0%81%E6%98%AF%E6%9C%80%E4%BC%98%E4%B9%8B%E9%80%89.mp4
L10 - 优化实例 - 聚合函数 MIN，MAX的调优
https://zcdn.askmaclean.com/%E3%80%90dbDao%20IT%E5%9C%A8%E7%BA%BF%E6%95%99%E8%82%B2-%E6%B1%AA%E4%BC%9F%E5%8D%8E%E3%80%91%20MySQL%E6%9F%A5%E8%AF%A2%E6%80%A7%E8%83%BD%E4%BC%98%E5%8C%96_L10_%E4%BC%98%E5%8C%96%E5%AE%9E%E4%BE%8B%20-%20%E8%81%9A%E5%90%88%E5%87%BD%E6%95%B0%20MIN%EF%BC%8CMAX%E7%9A%84%E8%B0%83%E4%BC%98.mp4
L11 - 优化实例 - Group By语法优化
https://zcdn.askmaclean.com/%E3%80%90dbDao%20IT%E5%9C%A8%E7%BA%BF%E6%95%99%E8%82%B2-%E6%B1%AA%E4%BC%9F%E5%8D%8E%E3%80%91%20MySQL%E6%9F%A5%E8%AF%A2%E6%80%A7%E8%83%BD%E4%BC%98%E5%8C%96_L11_%E4%BC%98%E5%8C%96%E5%AE%9E%E4%BE%8B%20-%20Group%20By%E8%AF%AD%E6%B3%95%E4%BC%98%E5%8C%96.mp4
L12 - 优化实例 - 使用Limit语法进行分页优化
https://zcdn.askmaclean.com/%E3%80%90dbDao%20IT%E5%9C%A8%E7%BA%BF%E6%95%99%E8%82%B2-%E6%B1%AA%E4%BC%9F%E5%8D%8E%E3%80%91%20MySQL%E6%9F%A5%E8%AF%A2%E6%80%A7%E8%83%BD%E4%BC%98%E5%8C%96_L12_%E4%BC%98%E5%8C%96%E5%AE%9E%E4%BE%8B%20-%20%E4%BD%BF%E7%94%A8Limit%E8%AF%AD%E6%B3%95%E8%BF%9B%E8%A1%8C%E5%88%86%E9%A1%B5%E4%BC%98%E5%8C%96.mp4
L13 - 优化实例 - Union和Union ALL之间的性能差别
https://zcdn.askmaclean.com/%E3%80%90dbDao%20IT%E5%9C%A8%E7%BA%BF%E6%95%99%E8%82%B2-%E6%B1%AA%E4%BC%9F%E5%8D%8E%E3%80%91%20MySQL%E6%9F%A5%E8%AF%A2%E6%80%A7%E8%83%BD%E4%BC%98%E5%8C%96_L13_%E4%BC%98%E5%8C%96%E5%AE%9E%E4%BE%8B%20-%20Union%E5%92%8CUnion%20ALL%E4%B9%8B%E9%97%B4%E7%9A%84%E6%80%A7%E8%83%BD%E5%B7%AE%E5%88%AB.mp4
L14 - 优化实例 - 索引和不等号
https://zcdn.askmaclean.com/%E3%80%90dbDao%20IT%E5%9C%A8%E7%BA%BF%E6%95%99%E8%82%B2-%E6%B1%AA%E4%BC%9F%E5%8D%8E%E3%80%91%20MySQL%E6%9F%A5%E8%AF%A2%E6%80%A7%E8%83%BD%E4%BC%98%E5%8C%96_L14_%E4%BC%98%E5%8C%96%E5%AE%9E%E4%BE%8B%20-%20%E7%B4%A2%E5%BC%95%E5%92%8C%E4%B8%8D%E7%AD%89%E5%8F%B7.mp4
L15 - 最佳实践建议总结
https://zcdn.askmaclean.com/%E3%80%90dbDao%20IT%E5%9C%A8%E7%BA%BF%E6%95%99%E8%82%B2-%E6%B1%AA%E4%BC%9F%E5%8D%8E%E3%80%91%20MySQL%E6%9F%A5%E8%AF%A2%E6%80%A7%E8%83%BD%E4%BC%98%E5%8C%96_L15_%E6%9C%80%E4%BD%B3%E5%AE%9E%E8%B7%B5%E5%BB%BA%E8%AE%AE%E6%80%BB%E7%BB%93.mp4