Oracle 12c SQL Tuning - the Ultimate Guide
4.8 (122 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
659 students enrolled

Oracle 12c SQL Tuning - the Ultimate Guide

Be one of the top professionals who know how to tune Oracle SQL. No other course covers all this course topics.
Highest Rated
4.8 (122 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
660 students enrolled
Created by Ahmed Baraka
Last updated 7/2020
English
English [Auto]
Current price: $118.99 Original price: $169.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 20 hours on-demand video
  • 1 article
  • 85 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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
Requirements
  • Basics of Oracle SQL
  • Basics of Oracle database architecture
  • Familiarity with Linux operating system basics
  • PC with 8GB RAM, 35GB free disk space, Windows
Description

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!

Who this course is for:
  • Oracle Developers
  • Oracle DBAs
Course content
Expand all 86 lectures 19:47:15
+ Introduction to SQL Tuning
2 lectures 22:05
Introduction to SQL Tuning - Part 1 of 2
15:51
Introduction to SQL Tuning - Part 2 of 2
06:14
+ Introducing Query Optimizer
1 lecture 13:30
Query Optimizer Fundamentals
13:30

Questions about Query Optimizer Fundamentals

Query Optimizer Fundamentals
5 questions
+ Execution Plans
9 lectures 01:57:07
Reading Query Execution Plans
14:46
Displaying Query Execution Plans
21:04
Pracitce 2 - Displaying Execution Plans
16:36
Introduction to SQL Operators
07:02
Table and B-Tree Index SQL Operators
21:09
SQL Joins - Nested Loop Joins
10:59
SQL Joins - Hash Joins
05:40
SQL Joins - Sort Merge Joins
11:15

Questions about SQL Operators

SQL Operators
9 questions
Practice 3 - Exploring SQL Operators and Joins
08:36
+ Optimizer Hints
4 lectures 49:39
Influencing the Optimizer with Hints - Part 1 of 2
13:34
Influencing the Optimizer with Hints - Part 2 of 2
15:38
Practice 4 - Influencing the Optimizer with Hints - Part 1 of 2
09:10
Practice 4 - Influencing the Optimizer with Hints - Part 2 of 2
11:17
+ Managing Optimizer Statistics
18 lectures 03:42:21
Optimizer Statistics Concepts
11:33
Practice 5 - Exploring Optimizer Statistics
09:44
Gathering Optimizer Statistics
16:43
Practice 6 - Gathering Optimizer Statistics
15:08
Setting Optimizer Statistics Preferences
13:10
Practice 7 - Setting Optimizer Statistics Preferences
08:23
Managing Histograms - Part 1 of 2
16:43
Managing Histograms - Part 2 of 2
13:59
Practice 8 - Managing Histograms - Part 1 of 2
13:22
Practice 8 - Managing Histograms - Part 2 of 2
10:35
Managing Extended Statistics
16:11
Practice 9 - Managing Extended Statistics
12:58
Managing Optimizer Statistics
14:53
Practice 10 - Managing Optimizer Statistics
14:20
Managing Historical Optimizer Statistics
07:43
Practice 11 - Managing Historical Optimizer Statistics
11:47
Using Optimizer Statistics Advisor
08:21
Practice 12 - Using Optimizer Statistics Advisor
06:48
+ Adaptive Query Optimization
7 lectures 01:30:50
Adaptive Query Optimization
07:17
Adaptive Plans
17:01
Practice 13 - Demonstrating Adaptive Plans
17:22
Statistics Feedback and Dynamic Statistics
12:43
Practice 14 - Statistics Feedback and Dynamic Statistics
11:12
SQL Plan Directives
12:41
Practice 15 - SQL Plan Directives
12:34
+ Cursor Sharing
2 lectures 30:53
Improving Performance Through Cursor Sharing
14:11
Practice 16 - Improving Performance Through Cursor Sharing
16:42
+ Monitoring and Tracing SQL
8 lectures 01:42:08
Monitoring Database Operations in Real-time using DBMS_MONITOR
12:45
Practice 17 - Monitoring Database Operations in Real-time using DBMS_MONITOR -P1
12:59
Practice 17 - Monitoring Database Operations in Real-time using DBMS_MONITOR -P2
09:01
Tracing SQL Statements using DBMS_MONITOR
12:33
Using tkprof Utility
19:01
Practice 18 - Tracing SQL Statements using DBMS_MONITOR
20:05
More SQL Tracing Methods
09:34
Practice 19 - More SQL Tracing Methods
06:10