|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracle-12c-sql-tuning/
课程评论：没有评论
课程名称：Oracle 12c SQL优化 - 终极指南 课程概述： 在本课程中，您将掌握Oracle SQL调优的关键技能，成为顶尖专业人士。面对性能逐渐变慢的查询时，您将获得解决瓶颈的知识和工具。课程不仅讲解SQL调优的概念，还将提供实践经验，让您能够实施所学的概念。 您将学习的技能包括： - 解决SQL语句性能问题 - 理解内部优化器操作 - 影响优化器操作的技术，如：SQL配置文件、SQL计划基线、指令、SQL提示、游标共享 - 使用Oracle SQL性能顾问，包括：SQL调优顾问、SQL访问顾问、优化器统计顾问、SPM演变顾问、SQL性能分析器 - 使用高级技术提高Oracle SQL性能，例如：直方图、与索引结合的高级技术、使用服务器结果缓存、星型转换 课程内容与结构： 本课程为Oracle开发人员和数据库管理员提供SQL调优的知识和经验。您将全面学习Oracle SQL语句的调优技巧。每个概念讲解后，您将进行实际操作练习，视频演示和可下载的指南文件将支持您的实践。 课程从介绍优化器架构开始，内容涵盖查询优化器的基础知识到高级处理技巧。您将理解优化器的内部工作原理，并学习如何影响其操作。实践部分包括： - 使用SQL提示 - 管理对象统计（使用DBMS_STATS） - 启用和管理SQL配置文件 - 启用和管理SQL计划管理（SPM） 此外，您将超过索引使用的基本概念，学习如何构造索引以实现最佳SQL性能。课程还将使您掌握跟踪SQL语句的常用技术，处理慢SQL语句、识别瓶颈并提出相应解决方案的能力。 抓住这个机会，跟随作者探索Oracle SQL调优技能！
Be one of the top professionals who know how to tune Oracle SQL. When you face a query that starts to be very slow with no apparent reason, you need knowledge and tools to troubleshoot the bottleneck and propose a proper solution; and that is what you will learn in this course.The course does not only demonstrate the SQL tuning concepts, you will gain hands-on experience on implementing the those concepts as well.The skills that you will learn in this course include the following:Troubleshoot SQL statement performance issuesUnderstand internal optimizer operationsTechniques to influence the optimizer operations:- SQL profiles, - SQL plan baselines- Directives- SQL Hints- Cursor SharingUse Oracle SQL performance advisory set, including:- SQL Tuning Advisor- SQL Access Advisor- Optimizer Statistics Advisor- SPM Evolve Advisor- SQL Performance AnalyzerUse advanced techniques to improve Oracle SQL, like the following:- histograms- using the advanced techniques with the indexes- using server result cache- star transformation Content and OverviewInformation presented in this course provides the Oracle developers and DBAs the knowledge and experience to perform SQL Tuning activities on Oracle databases.Through this extensive course, you'll learn all of SQL Tuning on Oracle SQL statements. After every concepts lecture, you will implement a hands-on practical exercise. To guide you on implementing the practices, the practice lectures are supported by video-based demonstrations and the downloadable guide documents.Starting with introducing the optimizer architecture, this course will take you all the away from basics of Query optimizer up to to implementing advanced topics of handling the Query optimizer. You will understand how the optimizer internally works and how to influence its operations. You will practically implement the following influencing the optimizer techniques:Using SQL HintsManaging object statistics (using DBMS_STATS)Enabling and managing SQL profilesEnabling and managing SQL plan management (SPM) (or stored outlines)Beside all those advanced concepts, you will exceed the basics concepts of using the indexes and learn how to manipulate them to achieve the best possible SQL performance. In addition to all of these skills, you will learn the most common techniques in tracing SQL statements and how to handle them. Upon completing this course, you will be able to troubleshoot slow SQL statement, identify the bottleneck, and propose a proper solution.Take this opportunity and join the author in exploring Oracle SQL Tuning skills!
