The Ultimate SQL Tuning Formula
4.3 (42 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.
214 students enrolled

The Ultimate SQL Tuning Formula

The Complete, Proven, Step by Step System to Find, Troubleshoot and Fix Performance Problems in Your Oracle Database
4.3 (42 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.
214 students enrolled
Created by Diana Robete
Last updated 6/2020
English
English [Auto]
Current price: $48.99 Original price: $69.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4 hours on-demand video
  • 35 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
  • Students will be able to troubleshoot performance problems
  • Students will have a good understanding of the Oracle optimizer, why it does what it does, and how it works.
  • Students will be able to find the bad SQL statement
  • Students will be able to implement a fix for bad SQL statements
  • Students will be able to implement good performance tuning practices at work
  • Students will know the exact steps to take to find and fix the performance problem. Students will know the exact step by step methodology to follow when fixing performance problems.
  • Students will be the hero at work, the one that saved the day, when nobody knew what to do to fix the performance problem.
Requirements
  • A basic understanding of the Oracle database is required
Description

Do you want to be an exceptional Oracle DBA? Do you want to be the DBA everyone calls when a performance problem in the database occurs?

Do you want to be the Hero of the Day, as you were the ONE who made the report run faster?

Are you afraid of performance problems in the database? Do you feel that you have no idea where to start?

Do you feel that you read and studied lots of tuning books and articles, and still it is not clear in you mind what steps to take to improve the database performance?

Do you feel lost and overwhelmed when someone is asking for your help in troubleshooting performance problems?

Are you just out of DBA school or with a few years of DBA experience, and you want to improve your tuning skills?


If you answered YES to any of these questions, than this course is definitely for you!


You don't need to spend tens and tens of hours studying and reading books on performance and tuning.

This course puts it all together for you in the minimum time required to learn all you need to know about Oracle performance and tuning.


The course comes with 6 compact modules, and tons of bonuses: mind maps, scripts, and course slides. All the knowledge you are getting, can be applied right away on the job.

The scripts included in the course, are the exact same scripts I use, day to day on my job, to troubleshoot and fix performance problems.

If you are curious to see what is there in each module, keep reading further!

Module 1: The Foundation: All You Need To Know About Oracle Memory Components To Be An Awesome DBA

In this module you will:

  • Understand the ins and outs of the Oracle Memory

  • Work with the SGA (System Global Area)

  • Work with the PGA (Program Global Area)

  • Learn detailed information about each memory component

  • Learn all that you need to know about memory management


Module 2: All About Cursors And Why Are They Important

In this module you will:

  • Learn what cursors are and why you need them

  • Learn the 7 stages of the cursor aka cursor life-cycle

  • Learn everything about bind variables and literals


Module 3: How To Be The Hero Of The Day: Finding SQL Statements and Execution Plans

In this module you will:

  • Learn the ins and outs of execution plans

  • Learn the 6 ways to get the execution plan of a SQL statement

  • How to navigate an execution plan without a compass

  • Learn to finding inefficient execution plans


Module 4: Optimizer Stats The Secret Weapon Of The DBA

In this module you will:

  • Learn to Navigate statistics without getting lost

  • Learn how stats are gathered and how to configure statistics preferences

  • Learn all about histograms


Module 5: Getting Information From AWR

In this module you will:

  • Learn how to become a master of the AWR repository, working with snapshots, reports, baselines

  • Learn how to read and interpret the AWR report

  • Learn about the Active Session History and ADDM


Module 6: Step By Step Tuning Techniques, so you always know what you need to do.

In this module you will:

  • Learn the Seven Questions to ask when troubleshooting any performance problems

  • Learn how to find the answer to these questions - aka step by step plan to solve performance problem

  • Get Troubleshooting steps

  • Learn 6 ways to tune a query

  • Learn about SQL profiles - how to use them (everything about profiles)

  • Learn about moving SQL profiles from one database to another - 2 methods

  • Learn to use SQL Baselines

  • Learn the building blocks of the SQL Plan Management


Still not convinced? Why don't you give it a try, you have nothing to lose with the 30 Day Money Back Guaranteed!

Who this course is for:
  • Beginner Oracle DBAs, right out of school
  • Beginner and Intermediate Oracle DBAs eager to improve their performance tuning skills
  • DBAs who are afraid of Oracle performance problems
  • DBAs who don't know where to start when troubleshooting performance problems
  • DBAs who have no understanding or knowledge about performance and tuning concepts
Course content
Expand all 8 lectures 04:03:36
+ Introduction
2 lectures 04:46

Welcome message to the students of The Ultimate SQL Tuning Formula!

I am so excited you joined, and thank you for your trust to join The Ultimate SQL Tuning Formula!

Preview 01:36

How to get the most out of this course

Preview 03:10
+ Module 1: The Foundation
1 lecture 33:44

After this module, you will:

  • Understand the ins and outs of the Oracle Memory

  • Work with the SGA (System Global Area)

  • Work with the PGA (Program Global Area)

  • Have detailed understanding about each memory component

  • Know everything about memory management

The Goal of this module is for you to have a thorough understanding of the Oracle instance.

Preview 33:44
+ Module 2: All About Cursors, Why They Are Important
1 lecture 31:41

After this module, you will know:

  • What are cursors and why you need them?

  • The 7 stages of the cursor aka cursor life cycle

  • Everything about bind variables and literals


The Goal of this module is for you to have an understanding of how Oracle works with cursor, bind variable, literals.

All About Cursors. Why You Need Them.
31:41
+ Module 3: Finding SQL Statements And Execution Plans
1 lecture 40:25

After this module, you will know:

  • The ins and outs of execution plans

  • The 6 ways to get the execution plan of a SQL statement

  • How to navigate an execution plan without a compass

  • How to find inefficient execution plans

The Goal of this module is to make you comfortable working with execution plans, and know how to obtain an execution plan.

How To Be The Hero Of The Day: Finding SQL Statements and Execution Plans
40:25
+ Module 4: Optimizer Stats. The Secret Weapon Of The DBA
1 lecture 34:33

After this module, you will know:

  • How to navigate statistics without getting lost

  • How to gather stats and configure statistics preferences

  • All about histograms

The Goal of this module is to fully understand the optimizer stats in Oracle, and know how it can help you!

Optimizer Stats: The Secret Weapon Of The DBA
34:33
+ Module 5: Getting Information from the AWR
1 lecture 50:20

After this module, you will:

  • Become a master of the AWR repository, working with snapshots, reports, baselines

  • Know how to read and interpret an AWR report

  • Know Active Session History and ADDM concepts

The Goal of this module is to make you feel confident in using the AWR, ASH and ADDM

Getting Information from the AWR
50:20
+ Module 6: Step By Step Tuning Techniques, so you always know what you need to do
1 lecture 48:07

After this module, you will know:

  • The Seven Questions to ask when troubleshooting any performance problems

  • How to find the answer to these questions - aka step by step plan to solve the performance problem

  • What troubleshooting steps to take

  • 6 ways to tune a query

  • Everything about SQL profiles - how to use them

  • How to move SQL profiles from one database to another - 2 methods

  • How to use SQL Baselines

  • About the building blocks of the SQL Plan Management

The Goal of this module is to become an expert in tuning SQL queries

Step By Step Tuning Techniques, so you always know what you need to do
48:07