|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracle-sql-mastering-oracle-sql-performance-tuning/
课程评论：没有评论
课程名称：Oracle SQL：精通Oracle SQL性能调优 课程概述： 本课程包括视频讲座、练习文件、测验和作业，以及一对一的指导教师支持。请注意，该课程将不断更新，新增有关Oracle SQL调优的视频讲座。您将找到许多涵盖Oracle SQL调优新特性的课程内容。课程最吸引人的部分是，您可以根据需求提出特定的SQL调优主题，确保将该主题纳入课程中。 本课程旨在帮助Oracle SQL开发人员、分析师和数据库管理员提升SQL查询调优技能。您将学习在生产环境中优化和调优查询的各种方法。课程特别适合那些希望开始调优Oracle SQL查询并对编写和阅读查询有基本了解的专业人士。 无论是生产批处理作业还是SQL查询卡住或消耗过多时间，您可能曾面临这种情况，而往往对如何解决问题束手无策。我将通过逐步的方法指导您如何排查表现不佳的SQL查询。此外，我们还将讨论需要检查和关注的Oracle组件。本课程将教授您如何解读不同的组件并识别SQL查询执行时间过长的实际原因。我们将探讨可以应用的改进措施，以加快SQL查询的速度。 我将以系统化的方法来识别、分析和排查表现不佳的SQL查询，赋予您编写高效Oracle SQL查询所需的技能。课程中有一个专门部分讨论常见的SQL查询问题，并提供修正建议和技巧。因此，下次代码审查或编写代码时，您可以采用一些提到的最佳实践，以主动解决SQL性能问题。如果您每天投入两个小时，每周便可完成本课程。这段学习之旅将带您从Oracle SQL调优初学者提升至专家水平。 重要主题包括： - 收集表现不佳SQL的统计信息 - 理解基数和执行计划 - 高级查询调优技术 - 理解执行计划的各个组件并进行解读 - 深入理解索引及其对性能的影响 - 指导Oracle优化器选择更好的执行计划 - SQL查询调优的技巧和建议 - 获取有关Oracle 11g和Oracle 12c的性能调优知识 - 自适应游标共享 总之，SQL调优知识对IT专业人士至关重要，本课程是获得这一必要且需求旺盛技能的一站式商店。相信我，我将确保您获得出色的学习体验，并逐步引导您。祝您在Oracle SQL调优方面学习愉快！
*** This Course purchase includes video lectures, practice files, quizzes, & assignments, 1-on-1 instructor support***Please note that this course will be continuously getting updated with more videos to keep you up to date on Oracle SQL Tuning. You will find lot of new lecture covering new features in the area of Oracle SQL Tuning. Best part about this course is that, You can also demand a lecture on a specific topic of SQL Tuning, which comes under the scope and I will make sure that the section on that Topic is added.This course is designed to take the Oracle SQL Developers, Analysts, DBA to next level in SQL Query Tuning. You will find Various ways to optimize and tune the queries in the Production Environment. The professional who wants to start with the tuning of Oracle SQL queries and have basic idea of writing and reading queries, will find it extremely easy to understand.How many times have we seen this. A Production batch job or a SQL Query is hung or consuming more time. Majority of the times we are clueless on what needs to be done or how it has to be troubleshooted. I will Guide you through a STEP by STEP approach on how to troubleshoot the badly performing SQL Queries. We will also talk about the Oracle components that need to be checked and looked at. This course will also teach you how to interpret various components and identify the actual reason why the SQL Query is taking time. We will not stop there. We will also look at what fixes could be applied to make the SQL Query work faster.I have taken a systematic approach in identifying , analyzing and troubleshooting badly performing SQL Query and will provide you with the skills required to write highly efficient Oracle SQL queries.There is a separate section on most commonly seen problems in SQL Queries and have provided TIPS and TRICKS on correcting those SQL queries. So, next time, you do a Code review or write your own code, you can follow some of of the BEST Practices mentioned to proactively solve the SQL Performance Issues. You should be able to complete this course in a week time, if you dedicate 2 hours of your time daily and this journey will take you from Oracle SQL Tuning beginners to expert Level.Important Topics covered:Gather statistics for the bad SQLUnderstand the Cardinality and Execution PlanAdvanced Query Tuning Techniques.Understand the Various components of the Execution Plans and interpret themUnderstand the Index in depth and its impact on PerformanceGuide Oracle Optimizer to choose a better execution Plan.Tips and Tricks to tune the SQL Queries.Gain Oracle performance tuning knowledge on Oracle11g and Oracle12cAdaptive Cursor SharingBriefly, The knowledge of SQL Tuning is a must for IT professionals and this course is one stop shop for gaining this necessary and in-demand skill.Trust me, I will make sure you have an awesome learning experience and will hold your hand and take you step by step!!! Happy Oracle SQL Tuning:-)
