|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/the-ultimate-sql-tuning-formula/
课程评论：没有评论
**课程名称：**终极SQL调优公式 **课程概述：** 本课程旨在帮助您成为一名卓越的Oracle DBA，能够在任何性能问题发生时被召唤，并成为解决问题的英雄，让报告运行得更快。如果您对数据库性能问题感到困惑，不知从何入手，或者觉得阅读了大量调优书籍和文章后仍未掌握清晰的调优步骤，甚至在协助他人解决性能问题时感到迷失和不知所措，那么这门课程正是为您量身定制的。 无论您是刚从DBA学校毕业，还是拥有几年DBA经验，希望提升调优技能，这门课程都能帮助您在最短的时间内掌握所有必要的SQL性能和调优知识，而无需花费大量时间和精力阅读书籍。 课程包含6个精炼的模块，并提供丰富的奖励内容，如思维导图、脚本和课程幻灯片。所有学到的知识都可以立即应用于实际工作。课程提供的脚本是讲师日常工作中用于排查和修复性能问题的确切脚本。 **课程模块详情：** * **模块一：基础 - Oracle内存组件全解析，成就优秀DBA** * 深入理解Oracle内存结构 * 操作SGA（System Global Area） * 操作PGA（Program Global Area） * 详细了解各项内存组件 * 掌握内存管理所需的一切知识 * **模块二：游标的重要性及一切** * 了解游标及其重要性 * 学习游标的7个生命周期阶段 * 掌握绑定变量和字面值的所有知识 * **模块三：成为当天的英雄 - 查找SQL语句和执行计划** * 深入理解执行计划 * 学习获取SQL语句执行计划的6种方法 * 掌握如何在执行计划中导航，不再迷失 * 学习查找低效的执行计划 * **模块四：优化器统计信息 - DBA的秘密武器** * 学习如何在统计信息中导航而不迷失 * 了解统计信息的收集机制和配置方法 * 掌握所有关于直方图的知识 * **模块五：从AWR获取信息** * 成为AWR（Automatic Workload Repository）存储库大师，操作快照、报告和基线 * 学习如何阅读和解读AWR报告 * 了解ASH（Active Session History）和ADDM（Automatic Database Diagnostic Monitor） * **模块六：一步步调优技术 - 知道该做什么** * 学习排查任何性能问题时需要提出的七个问题 * 学习如何找到这些问题的答案，制定逐步解决性能问题的计划 * 获得故障排除步骤 * 学习6种调优查询的方法 * 了解SQL Profile - 如何使用（关于Profile的一切） * 学习SQL Profile在不同数据库间的迁移方法（2种） * 学习使用SQL Baseline * 了解SQL Plan Management（SPM）的构建模块 **不容错过：** 如果您仍未决定，不妨尝试一下，并且有30天退款保证，您没有任何损失！
Do you want to be an exceptional Oracle DBA? Do you want to be the DBA everyone calls when a performance problem in the database occurs?Do you want to be the Hero of the Day, as you were the ONE who made the report run faster?Are you afraid of performance problems in the database? Do you feel that you have no idea where to start? Do you feel that you read and studied lots of tuning books and articles, and still it is not clear in you mind what steps to take to improve the database performance?Do you feel lost and overwhelmed when someone is asking for your help in troubleshooting performance problems?Are you just out of DBA school or with a few years of DBA experience, and you want to improve your tuning skills?If you answered YES to any of these questions, than this course is definitely for you!You don't need to spend tens and tens of hours studying and reading books on performance and tuning. This course puts it all together for you in the minimum time required to learn all you need to know about Oracle performance and tuning.The course comes with 6 compact modules, and tons of bonuses: mind maps, scripts, and course slides. All the knowledge you are getting, can be applied right away on the job.The scripts included in the course, are the exact same scripts I use, day to day on my job, to troubleshoot and fix performance problems.If you are curious to see what is there in each module, keep reading further! Module 1: The Foundation: All You Need To Know About Oracle Memory Components To Be An Awesome DBAIn this module you will: Understand the ins and outs of the Oracle MemoryWork with the SGA (System Global Area) Work with the PGA (Program Global Area)Learn detailed information about each memory componentLearn all that you need to know about memory managementModule 2: All About Cursors And Why Are They Important In this module you will:Learn what cursors are and why you need themLearn the 7 stages of the cursor aka cursor life-cycleLearn everything about bind variables and literalsModule 3: How To Be The Hero Of The Day: Finding SQL Statements and Execution PlansIn this module you will:Learn the ins and outs of execution plansLearn the 6 ways to get the execution plan of a SQL statementHow to navigate an execution plan without a compassLearn to finding inefficient execution plansModule 4: Optimizer Stats The Secret Weapon Of The DBAIn this module you will:Learn to Navigate statistics without getting lostLearn how stats are gathered and how to configure statistics preferencesLearn all about histogramsModule 5: Getting Information From AWRIn this module you will:Learn how to become a master of the AWR repository, working with snapshots, reports, baselinesLearn how to read and interpret the AWR reportLearn about the Active Session History and ADDMModule 6: Step By Step Tuning Techniques, so you always know what you need to do.In this module you will:Learn the Seven Questions to ask when troubleshooting any performance problemsLearn how to find the answer to these questions - aka step by step plan to solve performance problemGet Troubleshooting stepsLearn 6 ways to tune a queryLearn about SQL profiles - how to use them (everything about profiles)Learn about moving SQL profiles from one database to another - 2 methodsLearn to use SQL BaselinesLearn the building blocks of the SQL Plan ManagementStill not convinced? Why don't you give it a try, you have nothing to lose with the 30 Day Money Back Guaranteed!
