SQL Tuning (Udemy.com)

Learn how to formulate and tune SQL statements for optimal performance

Created by: Amarnath Reddy

Produced in 2015

What you will learn

  • Identify poorly performing SQL
  • Understand how the Query Optimizer makes decisions about how to access data
  • Define how optimizer statistics affect the performance of SQL
  • List the possible methods of accessing data, including different join methods
  • Modify a SQL statement to perform at its best

Quality Score

Content Quality
Video Quality
Qualified Instructor
Course Pace
Course Depth & Coverage

Overall Score : 86 / 100

Live Chat with CourseDuck's Co-Founder for Help

Need help deciding on a sql course? Or looking for more detail on Amarnath Reddy's SQL Tuning? Feel free to chat below.
Join CourseDuck's Online Learning Discord Community

Course Description

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 statement
  • Determine 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 PanyamWho this course is for:
  • Database developers, DBAs and SQL developers

*Some courses are excluded from this sale. Coupon not working? If the link above doesn't drop prices, clear the cookies in your browser and then click this link here.
Also, you may need to apply the coupon code directly on the cart page to get the discount.

Coupon Code

Instructor Details

Amarnath Reddy

Amarnath has a Masters Degree in computer science with around 15 years of experience in the IT industry. He has successfully designed and implemented projects for clients in South Africa, India and USA. Currently his main focus is on Datawarehouse Architecture.
Amarnath is currently working for a fortune 500 company in USA and has pioneered the data architecture discipline. His Innovative and simple architectural designs have won accolades in the company.
Today, he brings leadership and technical expertise to enable customers to optimize and modernize their IT environments leveraging Business Intelligence tools, Big Data, social, mobile, and the Internet of Things.



49 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

Good but if u share the documents that should be helpful

Thanks for the knowledge sir. Course is really useful. Could have some more scenarios with complex explain plan, profile, baseline etc.

Excellent! Shows the trainer presentation skills with his vast experience.

pretty cool and straight forwards... although im using Postgre rather than Oracle, but still it gives me lot of knowledge :D

Great course about various techniques and methods to optimize user response and throughput. Thank you!

Sim, o curso excelente e atendeu minhas expectativas, com certeza aprendi vrias tcnicas importantes e que poderei aplicar em meu dia a dia.

it was expected that there would be an explanation for buffer sort and merge cartesian join while explaining the plan.

This course concentrates on basics without going too deep, good for beginners who are exploring oracle performance tuning as they get a good starting point to build on.The language and explanation is really simple and hence the course is easy to learn.But,for a person already into performance tuning it does not offer anything new.

It was very useful and interested topics

I am improving my skills watching these videos.

Good explanation, but the concepts covered are very basic. For eg: different types of hints are mentioned, why/why not parallel hints should be used isn't explained at all. Another eg: what are the scenarios in which hash join will be faster than a nested loop join isn't mentioned at all. Would request the author to add more details/examples and clarify on these.

voice accent is terrible, i am getting tired listening to it. subtitles are not correct most of time