SQL Tuning (Udemy.com)

Learn how to formulate and tune SQL statements for optimal performance

( 49 Reviews )

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

Time: 3h

*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

4.3 Rating
49 Reviews

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.

SQL in Motion (2017)

0.0 (0 Reviews)

Provider: Manning Publications
Time: 4h

$59.99

Introduction to SQL (2015)

0.0 (0 Reviews)

Provider: SQLBolt

Free

Intro to SQL: Querying and managing data (2015)

0.0 (0 Reviews)

Provider: Khan Academy
Time: 1h

Free

More Courses

Reviews

4.3

49 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Rajinikanth on

Good but if u share the documents that should be helpful

By Anton John Thomas on

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

By Gagan Sai Reddy on

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

By Rafi Ramadhana on

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

By Art Reynoso on

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

By Roberto Araripe on

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

By Ayush Mittal on

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

By Bhabani Kar on

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.

By Mohamed Goulay on

It was very useful and interested topics

By Chandra Shekhar on

I am improving my skills watching these videos.

By Febin Varghese on

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.

By Yegor Androsov on