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

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

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)

4.7 (6 Reviews)

Provider: SQLBolt

Free

Intro to SQL: Querying and managing data

Intro to SQL: Querying and managing data (2015)

0.0 (0 Reviews)

Provider: Khan Academy
Time: 1h

Free

More Courses

More courses by Amarnath Reddy

Oracle SQL - Step by Step SQL (2018)
4.6 (348 Reviews)

- Provider: Udemy
- Time: 5.5h

$11.99

SQL Advanced (2018)
4.4 (315 Reviews)

- Provider: Udemy
- Time: 4.5h

$11.99

PL/SQL by Example - Beginner to Advanced PL/SQL

PL/SQL by Example - Beginner to Advanced PL/SQL (2018)
4.5 (256 Reviews)

- Provider: Udemy
- Time: 5h

$11.99

200+ SQL Interview Questions (2017)
4.2 (231 Reviews)

- Provider: Udemy
- Time: 2.5h

$11.99

SQL Developer Tips and Tricks (2018)
4.8 (12 Reviews)

- Provider: Udemy
- Time: 1.5h

$11.99

All courses by Amarnath Reddy

Reviews

4.3

49 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

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.

By NAGA HEMA SUNDAR SIRISIPALLI

It's a good explanation for Oracle SQL tuning. I would recommend to take this course. Instruction is very clear on point.
Would be more helpful with examples to understand how and when to hints.

By Padmini Priya ch

Really good one to learn basics of tuning concepts...

By Srivanth Manohar Babu

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 Frank Nwadike

Amarnath, Is a very informative instructor, he takes his time to explain things in an easy to understand manner. I will recommend him any time.

By Felipe Quiroz

a very good introduction and different point of view in relations to formal oracle docs. it makes easier to understand topics.
you need previous knowledge of oracle database technology.

By Umair

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 Adrian Niedziela

I finally had someone explain an Explain Plan in such a way that I could understand it. I like the way he shows and explain a plan, change the sql and show the improvement.

By Ashish Panwar

Thanks for this course sir ... i have learnt many thing during this session .... please update if there is any more course related to SQL , DATABASE or performance tuning.

By Al Smith

Great presentation clearly articulate the main point and made it easy to follow. like the introduction how you use the Google map direction..thanks

By Manish Kumar

Course content is good. It could have been much better if you add few real time example like a problem statement and how you approched and solved it.
Liked the content. thank you