Skip to content
Write a review
UdemySqlPaid courseIntermediate levelCertificate

Oracle 12c SQL Tuning - the Ultimate Guide (Udemy.com)

Learn how to analyze, troubleshoot, and optimize Oracle SQL performance like a professional

4.6
309 reviews

Created by: Ahmed Baraka

Last updated February 2024

icon
What you will learn

  • Troubleshoot SQL statement performance issues
  • Understand internal optimizer operations
  • Techniques to influence the optimizer operations
  • Use Oracle SQL performance advisory set
  • Use advanced techniques to improve Oracle SQL

icon
Course Description

Become confident in tuning Oracle SQL statements by understanding how the Oracle optimizer works and learning how to control and influence its decisions.

When a SQL query suddenly becomes slow with no obvious reason, you need the right knowledge, tools, and methodology to identify the bottleneck and apply the correct solution. This course teaches you exactly how to do that, using a hands-on, practical approach.

The course goes beyond theory. Every concept is followed by real implementation exercises, allowing you to practice SQL tuning techniques step by step using Oracle Database 12c.

You will learn how to:

  • Troubleshoot SQL performance issues methodically

  • Understand Oracle optimizer architecture and internal operations

  • Influence optimizer behavior using:

    • SQL Profiles

    • SQL Plan Baselines (SPM)

    • Directives

    • SQL Hints

    • Cursor Sharing

  • Use Oracle SQL performance advisory tools, including:

    • SQL Tuning Advisor

    • SQL Access Advisor

    • Optimizer Statistics Advisor

    • SPM Evolve Advisor

    • SQL Performance Analyzer

  • Apply advanced SQL tuning techniques, such as:

    • Histograms

    • Advanced indexing strategies

    • Server Result Cache

    • Star Transformation

This course is designed for Oracle developers and DBAs who want to move beyond basic indexing and execution plans. You will learn how to trace SQL statements, analyze execution behavior, and make informed tuning decisions.

By the end of the course, you will be able to identify SQL performance bottlenecks, understand why they occur, and apply effective tuning solutions with confidence.

Join this learning journey and master one of the most valuable skills in Oracle performance tuning.
Read More Intermediate Intermediate Level product length iconTime: 19.8h

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

Ahmed Baraka

Ahmed Baraka is an Oracle database specialist with 25 years of hands-on experience designing and running high-availability environments. He focuses on RAC, ASM, Data Guard, GoldenGate, WebLogic, Oracle Database Appliance, and Enterprise Manager, and has worked with international teams in Australia and Abu Dhabi. Ahmed’s courses translate real production scenarios into practical, step-by-step training so learners build job-ready skills in administration, performance, HA, and migration.

Read More

icon
More courses by Ahmed Baraka

$44.99

$34.99

$22.99

$44.99

$34.99

$49.99

All courses by Ahmed Baraka

icon
More SQL courses

$94.99

$16.99

$12.99

$13.99

$10.99

$34.99

All SQL courses

icon
Reviews

4.6

309 ratings on Udemy

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

Write a review

By Chamunorwa on 12/28/2023

The course needs to be updated

By Peter Lim on 4/23/2022

The documentation for Preparing Practice Environment is obsolete and should be begin with general concepts for each step before the specific instructions. The general concepts will help when the specific instructions become obsolete.

By Shruchin on 7/28/2021

Oracle is the best RDBMS overall, but still it is complex one with other RDBMS, but Ahmed (Guru) had made the course simple and kept the momentum for full course and made the topics easy to understand The best course in Udemy no question on that!

By Sikandar Khan Farzand on 11/28/2020

Ahmed barakah has the brilliant courses this is my fifth course and he offered so much with huge practical material which is hard to find somewhere else thx for such a huge effort thx for the

By Niraj Singh on 5/22/2020

This is excellent course, if you want to understand oracle under the hood operations, it helped me a lot in building efficient solutions in my project from performance perspective. Thanks for creating!

By Ayman Haboubi on 1/6/2020

So much content, so many things, so many exercises. Very much worth it. Nothing like it anywhere. I've been Oracle DBA for 6 years now. Thanks Ahmed

By Majid Shabani on 10/21/2019

You helped me on my path and achieving my goals and dream, thank you for all the knowledge and experience you shared. I’m grateful to have such an awesome teacher like you. I look forward to another great course from you. BR Majid

By Ritu on 7/16/2019

I will give him 5 stars as I believe he is one of the best instructors in this space. His content and downloadable resources are very up-to-date and easy to understand. His explanation is very clear and detailed .I would recommend others who is looking for oracle sql tuning course . Thank you Ahmed for providing such a wonderful course!

By Syed Ali on 5/4/2019

I had bought all the courses by Ahmed Sir...... BEST DBA EVER.....Great Concepts.... Hands-On after every Concept is what makes the courses by Ahmed Sir, UNIQUE & UNDERSTANDABLE

By Sandip Mukherjee on 4/27/2019

Ahmed as usual is top notch Oracle Instructor on Udemy. Very detailed and thorough explanation on topics as per expectation. This course is one of the best tuning courses available online. We are eagerly waiting for his course on Generic Performance tuning and Oracle Exadata Engineered system. Keep up doing the great work. Best Regards, Sandy

Showing all 10 reviews on CourseDuck

Read all 309 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

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

Overall Score : 92 / 100

Oracle 12c SQL Tuning - the Ultimate Guide
Visit course on Udemy Write a review
  • Video Duration: icon 19.8h
  • Price: $22.99
  • Provider: icon Udemy
  • Updated: icon February 2024
  • 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