|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-tuning/
课程评论：没有评论
**课程名称：SQL 性能调优 (SQL Tuning)** **课程概述：** 在 IT 行业，优秀的 SQL 开发人员需求旺盛，薪资可达 10 万美元以上。SQL 性能调优是一门值得掌握的艺术！许多 SQL 开发人员曾经尝试理解 SQL 运行缓慢的原因，但屡屡失败，因为我们从未真正了解 SQL 的工作原理，而将其视为数据库管理员的职责。为了在职业生涯中取得进步并获得高薪，掌握 SQL 调优技能至关重要。 本课程旨在帮助您摆脱对 SQL 调优的困惑。通过循序渐进的方式，我们将介绍优化程序，并指导您编写高效的 SQL。本课程将系统地规划、分析、调试和解决常见的查询性能问题，为您提供编写可扩展、高性能 SQL 所需的技能。 **课程采用的 SQL 调优方法论：** 1. **识别问题 SQL 语句。** 2. **确定 Oracle 执行 SQL 语句的方式以及 Oracle 选择该方式的原因。** 3. **研究是否有更优的替代执行计划。** 4. **更新 SQL 语句，引导 Oracle 生成更优的执行计划。** 课程讲师将手把手指导，带您一步步掌握这些技能。 **讲师：** Amarnath Panyam
Good SQL Developers are in high demand and demand 100k+ salary in the IT industry.SQL performance tuning is an art to master - for all of us!!!Many SQL Developers have tried to understand why a particualr SQL was running slow - including me - but have failed over and over again because we never tried to understand how SQL works? We were thinking it is database administrators Job!!!!If we have to advance in our career and earn a good salary, we need these SQL tuning skills.We know how it feels if someone talks about SQL Tuning and I dont want you to feel the same.I took baby steps in introducing you to the optimizer and helping you write an effecient SQL.This course takes a systematic approach to planning, analyzing, debugging and troubleshooting common query-related performance problems and will provide you with the skills necessary to write scalable, high performance SQL.The SQL tuning methodology I used:Identify a problem SQL statementDetermine how Oracle is executing SQL statement and why Oracle chose that way.Investigate whether alternative executon plans would be better.Update the SQL statement to push Oracle towards the better plan.Trust me, I will catch your hand and take you step by step!!!See you inside,Amarnath Panyam
