|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracle-sql-tuning-indexes/
课程评论：没有评论
## Coursera 课程总结：《Oracle SQL 性能调优 - 索引》 **课程概述：** 本课程专注于解决工作中常见的 SQL 性能问题，特别是针对大多数 DBA 和开发者在编写高性能查询方面的不足。统计数据显示，约 70% 的数据库性能问题与 SQL 语句相关，其中最常见的原因包括： * **缺失或不恰当的索引** * **缺乏、过时或不准确的统计信息** * **SQL 语句代码质量不高** 本课程将深入探讨 Oracle SQL 优化器如何利用索引选择执行计划，并侧重于**实践**。所有理论知识都将通过可复现的实际操作演示进行巩固，课程还将提供一个虚拟环境供学员练习。此外，学员将被要求完成 20 个相关主题的实践练习，并在课程最后三节课中进行详细解答和讲解。 **核心内容：** * **SQL 性能问题剖析：** 了解 SQL 语句在数据库性能中扮演的关键角色。 * **索引的重要性：** 深入理解索引在数据库查询中的作用，以及如何通过索引提升查询效率。 * **优化器与索引：** 学习 Oracle 优化器如何选择和使用索引来生成最佳执行计划。 * **实践驱动的学习：** 通过大量的实际操作和练习，掌握 SQL 性能调优的技巧。 * **解决常见性能瓶颈：** 针对索引、统计信息和 SQL 代码质量等常见问题提供解决方案。 **目标学员：** * DBA * 数据库开发者 * 任何希望提升 SQL 查询性能的专业人士
The most common problem of working with SQL is performance problems. Most of the DBA and developers don't know how to write well-performing queries. So in time, this problem grows and becomes a problem for everybody the developer, DBA and the company.Statistics provided by specialized institutions point out that about 70% of the database performance problems are related to the SQL statement.Among the most common SQL statement performance problems are:Missing index or inappropriate indexLack of statistics, outdated statistics or inaccurate statisticsQuality of the SQL statement codeThe level of knowledge of each of these topics is very important in the SQL Tuning tasks, so in this course we will explore in detail the use of indexes by the Optimizer in choosing the execution plan.This training has a very strong focus on the practical part, I believe the best way to consolidate knowledge is through practice.All the theories of this training are accompanied by practical demonstrations that you can replicate in a virtual environment that will be made available in the training.In addition, you will be invited to perform 20 practical exercises on the proposed topics that will be solved and commented on in the last 3 training classes.
