Oracle SQL Performance Tuning - From Scratch To Tuner
Analyze & Interpret Poor Performing SQL From Scratch And Fix Them With Best Plan
4.35 (94 reviews)
389
students
4 hours
content
Jan 2023
last update
$49.99
regular price
What you will learn
Analyze SQL Query From Scratch By Verifying Optimizer Is Undertaking Desired Path By Reading And Interpreting Execution Plan
Fix Poor Performing SQL Query Involving Non-Joins, Joins With Two Tables, Joins With Multiple Tables With Best Plan By Making Use Of Indexes, Hints & Baselines
Interview Ready On Joins/Histograms/Access Methods/Execution Plan
19 Cases of poor performing SQL's and their fixes
Why take this course?
This Course Will Help You To Tune SQL Queries With Respect To Oracle Database 11g Starting With The Basic Pre-Requisite For SQL Tuning Along With Tips And Tricks. After Completing This Course, You Will Be Able To Tune Most Of The SQL Queries With Non-Joins, Joins With Two Tables And Joins With Multiple Tables.
Screenshots
Reviews
Gaurav
October 16, 2021
The way he is explaining the concept, it’s like I can think of the query execution in oracle. I can handle and after clearing the concept I can decide the what is best for query optimizing. After seeing introductory part of the course I got to know that there are certain rules for query optimisation that if we follow then most of the query we can tune.
Muhammed
August 15, 2021
This is one of the best courses I have taken. Mr Vijesh is very knowledgeable about Oracle database and he is aware of every details about how query gets executed. I recommend this course to everyone who wants to understand how query gets executed as that's the first step before query tuning. This course will help you to build your performance tuning skill.
Puneet
August 10, 2021
The course is amazing. It is very well explained in detail and is very easy to understand for beginners like me. I highly recommend this course to anyone who needs to expertise in sql tuning.
Infra
August 2, 2021
The course is too good, but voice is unclear for most of the videos. Please help on this. The access method video is too troublesome to listen to
Bhushan
September 10, 2020
Excellent approaches towards tuning. And Easy explanations. This course is much better than other courses on Udemy. Thank you.
Amlanjyoti
August 29, 2020
It could have better ......this video is typically made for someone who is looking for basic knowledge on Explain plan
John
August 7, 2020
Very excellent course on SQL tuning . This course covers all of the essential topics and explains them in a very easy to understand manner .
Saran
July 19, 2020
whatever you covered sofar is good. i am expecting in-depth knowledge on performance tunning in upcoming days
Saikat
June 8, 2020
Thank you for the Course. It helped me to learn SQL Tuning from scratch. Course was simple and easy to understand.
Navaneeth
May 28, 2020
The trainer was very well versed and the subject of tuning was presented in a very simple and clear manner,each topic was explained with very good and simple examples .
Jamsher
May 27, 2020
Course is very good to understand basic of SQL Tuning and build the basic understanding of explain plan
Charts
Price
Rating
Enrollment distribution
Related Topics
3100688
udemy ID
5/7/2020
course created date
2/28/2021
course indexed date
Bot
course submited by