Skip to content
Write a review
UdemySQLPaid courseIntermediate levelCertificate

SQL Tuning (Udemy.com)

Learn how to formulate and tune SQL statements for optimal performance

4.2
1,350 reviews

Created by: Amarnath Reddy

Last updated July 2015

icon
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

How it compares

Against the other 388 rated Udemy courses in SQL on CourseDuck:

  • Rating4.2 out of 5higher than 13% of them
  • Reviews1,350#119 of 389 by number of reviews
  • Length3.1 hoursshorter than 73% of them
  • Last updatedJuly 2015earlier than 98% of them

icon
Quality Score

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

Overall Score : 84 / 100

icon
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 Panyam
Read More Intermediate Intermediate Level product length iconTime: 3.1h

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
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.

Read More

icon
More courses by Amarnath Reddy

$15.99

$14.99

$13.99

$11.99

$13.99

$12.99

All courses by Amarnath Reddy

icon
Reviews

4.2

1,350 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

Write a review

By Prajakta Kushte on 2/9/2020

I got a good knowledge on performance tuning part with this course. This is best one. I will recommend it to my friends. This gives you techniques needs to be use by Developer as well as DBA end for better performance. Only thing I feel is in the last few topics, Demo part was missing or not explained that good because I am having few doubts.

By Rajinikanth on 12/12/2019

Good but if u share the documents that should be helpful

By Bhushan Tari on 11/27/2018

The course mainly focuses on Oracle SQL and not general SQL language. This will help to only those who are using Oracle as database. I was expecting a more generic course which can suit any SQL irrespective of the database.

By Krishna Kishore S on 11/7/2017

Explanation was Good to the Topics that are covered but expected Explanation on Execution Plans for Mutiple Datas pulled through Complex views. Tuning of views, Triggers, Materialized views , plsql code was also expected.

By Ratna Hazra on 1/3/2017

Highly satisfied. The courses taught by Instructor Amarnath Reddy are easy to grasp, in-depth, relate to real world. It really aims at enhancing the knowledge level of the students. I would love to see more from the same instructor. A Big THANK YOU to Amarnath Reddy.

By Rajeev Sagar on 11/5/2016

The course covered most of the topics. However, the explanations aren't quite enough. For ex: From the course, we know when to use Bitmap Index, but we don't know why we prefer Bitmap over B-Tree index. Also, there are some things that are missing in this course. For ex: From the course, we know how to assign values to each partition in a list partitioning, but we don't know what happens if we get a new value that we didn't specify in the definition.

By Anu G on 4/12/2016

Basics are covered really well.But I feel,When it comes to sql tuning the level of this course has to be Basic instead of Intermediate,so that expectations are set right. Explanation of little more complex explain plans with more than 5 tables would have been useful.

By Srivanth Manohar Babu on 7/15/2015

Many 'SQL Tuning' techniques discussed with good learning content. After learning this coursework, i am confident that i can write an effective SQL. Thanks a lot amarnath reddy for this brilliant coursework. I learned a lot from this. Guys, also please check on his other courses 'Oracle SQL : Step by Step SQL' and 'PL/SQL by example'.

By Umair on 6/25/2015

This course is a good abstract of SQL Tuning guides. Its a powerful kick start towards learning and good understanding about SQL Tuning. If few topics like SPM, Index maintenance can be covered then the 5 stars in rating will also start glittering. Thank you Ammarnath.

By Doan Truong Giang on 4/12/2015

Lessons are informative. I can feel that Amarnath Panyam, the instructor, indulges in his working. Learning with the one quickly responds to your discussion is better than with the one leaves their course and learners behind for decade.

By Sameer Ahmad

Yes till now I'm able to understand the things my Lecturer is trying to make me understand by nice simple examples.

By Venkata Manjunath Reddy Ankireddygari

The course has Good Content and the instructor explanation with regards to content shows how experienced he is .
It is very good course for those who want to start learning SQL TUNING.

Showing 12 of 55 reviews

SQL Tuning
Visit course on Udemy Write a review
  • Video Duration: icon 3.1h
  • Price: $14.99
  • Provider: icon Udemy
  • Updated: icon July 2015
  • Level: Intermediate Intermediate
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com