Oracle SQL : Mastering Oracle SQL Performance Tuning (Udemy.com)

Oracle SQL Query Tuning and Architecture | Solve critical Oracle SQL query performance issues | Advanced SQL Tuning

( 22 Reviews )

Created by: Prathap G

Produced in 2022

What you will learn

Step by Step approach on troubleshooting badly performing SQL queries.
Identify how internal Oracle components affects the performance of the SQL query.
Identify potential performance bottlenecks by reading the Explain plan of the queries.
Tips and Tricks to make the Oracle SQL query run faster.
Compare BAD vs GOOD Queries with Examples.
Understand how STATISTICS and CARDINALITY affects the performance of the SQL Query.
Implications of JOINS and ACCESS Methods on the performance of the Query.
Oracle Performance Tuning on both Oracle11g and Oracle12c Environment.
Advanced SQL Query Tuning Steps.

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 92 / 100

Live Chat with CourseDuck's Co-Founder for Help

Need help deciding on a postgresql course? Or looking for more detail on Prathap G's Oracle SQL : Mastering Oracle SQL Performance Tuning? Feel free to chat below.

Join CourseDuck's Online Learning Discord Community

Course Description

*** This Course purchase includes video lectures, practice files, quizzes, & assignments, 1-on-1 instructor support***
Please note that this course will be continuously getting updated with more videos to keep you up to date on Oracle SQL Tuning. You will find lot of new lecture covering new features in the area of Oracle SQL Tuning. Best part about this course is that, You can also demand a lecture on a specific topic of SQL Tuning, which comes under the scope and I will make sure that the section on that Topic is added .
This course is designed to take the Oracle SQL Developers, Analysts, DBA to next level in SQL Query Tuning. You will find Various ways to optimize and tune the queries in the Production Environment. The professional who wants to start with the tuning of Oracle SQL queries and have basic idea of writing and reading queries, will find it extremely easy to understand.
How many times have we seen this. A Production batch job or a SQL Query is hung or consuming more time. Majority of the times we are clueless on what needs to be done or how it has to be troubleshooted.
I will Guide you through a STEP by STEP approach on how to troubleshoot the badly performing SQL Queries. We will also talk about the Oracle components that need to be checked and looked at. This course will also teach you how to interpret various components and identify the actual reason why the SQL Query is taking time. We will not stop there. We will also look at what fixes could be applied to make the SQL Query work faster.
I have taken a systematic approach in identifying , analyzing and troubleshooting badly performing SQL Query and will provide you with the skills required to write highly efficient Oracle SQL queries.
There is a separate section on most commonly seen problems in SQL Queries and have provided TIPS and TRICKS on correcting those SQL queries . So, next time, you do a Code review or write your own code, you can follow some of of the BEST Practices mentioned to proactively solve the SQL Performance Issues.

You should be able to complete this course in a week time, if you dedicate 2 hours of your time daily and this journey will take you from Oracle SQL Tuning beginners to expert Level.
Important Topics covered:

Gather statistics for the bad SQL
Understand the Cardinality and Execution Plan
Advanced Query Tuning Techniques.
Understand the Various components of the Execution Plans and interpret them
Understand the Index in depth and its impact on Performance
Guide Oracle Optimizer to choose a better execution Plan.
Tips and Tricks to tune the SQL Queries.
Gain Oracle performance tuning knowledge on Oracle11g and Oracle12c
Adaptive Cursor Sharing

Briefly, The knowledge of SQL Tuning is a must for IT professionals and this course is one stop shop for gaining this necessary and in-demand skill.
Trust me, I will make sure you have an awesome learning experience and will hold your hand and take you step by step!!!
Happy Oracle SQL Tuning :-) Who this course is for:

Oracle SQL Developers who want to optimize the SQL queries.
Aspirants seeking career opportunities in Oracle Database and SQL.
DBA, Developers, Support Analyst who wants to troubleshoot Oracle SQL queries and fix it.

Time: 6.5h

*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

Prathap G

4.6 Rating
22 Reviews

Prathap is an IT professional who has 15 years of Experience and diversified knowledge across multiple domains in the industry. Working in a leading Product/Cloud provider company. He has taken various roles in his career from Developer, Designer, Consultant, Architect, Performance Management and is currently ramping up his skills on latest generation Tools and Products.
Prathap has vast knowledge on Database(Oracle/SQL Server/PostgreSQL), Python, Performance Management, DevOps Tools and Microsoft Azure.
He loves to teach from very beginning and Udemy is the platform that helps him in continuation of the same passion.

Reviews

4.6

22 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Malayaj Das on

The course covered major areas and was very helpful

By Khalid Hanif on

Good way of explaining the Tuning concepts....

By Mark Shibley on

Excellent course. Well paced. Dense with good information, but not overwhelming. Having gone through the course, my knowledge of optimization has been bumped up to the next level.

By Dipak Kalamkar on

So far, its very basic.

By Sarella Udaya Kirana Reddy on

Detailed content and great presentation. I have learned a lot on these optimization techniques. I would recommend this course for others too ...

By Vishal Kumar on

The Course was a good refresher of the concepts. I would recommend to add more topics on tuning such as SQL Profiles.

By Vishal Sharma on

well structured course and the thing which I loved the most is everything is explained with easily understandable examples.

By Madhusudanareddy on

Having Depth knowledge in subject.Nicely explained.

By Jayanti Chowdhury on

Excellent course on SQL tuning,short and to the point with ample examples to clear the concepts. Just one request to him, kindly add few lectures on "SQLT" tool as it's one of the main tuning tools for poorly performing SQL's.

By Maurizio Dimatteo on