4.5 out of 5
4.5
223 reviews on Udemy

Oracle 12c SQL Tuning – the Ultimate Guide

Be one of the top professionals who knows how to tune Oracle SQL. No other course covers all this course topics.
Instructor:
Ahmed Baraka
1,297 students enrolled
English [Auto]
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

Be one of the top professionals who know how to tune Oracle SQL. When you face a query that starts to be very slow with no apparent reason, you need knowledge and tools to troubleshoot the bottleneck and propose a proper solution; and that is what you will learn in this course.

The course does not only demonstrate the SQL tuning concepts, you will gain hands-on experience on implementing the those concepts as well.

The skills that you will learn in this course include the following:

  • Troubleshoot SQL statement performance issues

  • Understand internal optimizer operations

  • Techniques to influence the optimizer operations:

    – SQL profiles,

    – SQL plan baselines

    – Directives

    – SQL Hints

    – Cursor Sharing

  • Use Oracle SQL performance advisory set, including:

    – SQL Tuning Advisor

    – SQL Access Advisor

    – Optimizer Statistics Advisor

    – SPM Evolve Advisor

    – SQL Performance Analyzer

  • Use advanced techniques to improve Oracle SQL, like the following:

    – histograms

    – using the advanced techniques with the indexes

    – using server result cache

    – star transformation

     

Content and Overview
Information presented in this course provides the Oracle developers and DBAs the knowledge and experience to perform  SQL Tuning activities on Oracle databases.

Through this extensive course, you’ll learn all of SQL Tuning on Oracle SQL statements. After every concepts lecture, you will implement a hands-on practical exercise. To guide you on implementing the practices, the practice lectures are supported by video-based demonstrations and the downloadable guide documents.

Starting with introducing the optimizer architecture, this course will take you all the away from basics of Query optimizer up to to implementing advanced topics of handling the Query optimizer.

You will understand how the optimizer internally works and how to influence its operations.

You will practically implement the following influencing the optimizer techniques:

  • Using SQL Hints

  • Managing object statistics (using DBMS_STATS)

  • Enabling and managing SQL profiles

  • Enabling and managing SQL plan management (SPM) (or stored outlines)

Beside all those advanced concepts, you will exceed the basics concepts of using the indexes and learn how to manipulate them to achieve the best possible SQL performance.

In addition to all of these skills, you will learn the most common techniques in tracing SQL statements and how to handle them.

Upon completing this course, you will be able to troubleshoot slow SQL statement, identify the bottleneck, and propose a proper solution.

Take this opportunity and join the author in exploring Oracle SQL Tuning skills!

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.5
4.5 out of 5
223 Ratings

Detailed Rating

Stars 5
139
Stars 4
65
Stars 3
13
Stars 2
4
Stars 1
2
686ce5044460f51bc47802321d08b529
30-Day Money-Back Guarantee

Includes

20 hours on-demand video
1 article
Full lifetime access
Access on mobile and TV
Certificate of Completion

Archive

Working hours

Monday 9:30 am - 6.00 pm
Tuesday 9:30 am - 6.00 pm
Wednesday 9:30 am - 6.00 pm
Thursday 9:30 am - 6.00 pm
Friday 9:30 am - 5.00 pm
Saturday Closed
Sunday Closed