Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
IT & Software Other IT & Software Oracle SQL

The Ultimate SQL Tuning Formula

The Complete, Proven, Step by Step System to Find, Troubleshoot and Fix Performance Problems in Your Oracle Database
Rating: 4.6 out of 54.6 (75 ratings)
331 students
Created by Diana Robete
Last updated 6/2020
English
English [Auto]
30-Day Money-Back Guarantee

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

Featured review

Anup Gupta
Anup Gupta
28 courses
6 reviews
Rating: 4.5 out of 59 months ago
Great course. Really helpful to understand from the SQL tuning perspective and the optimizer behavior. Highly recommended to all those who work more on the Oracle database and precisely on the tuning area.

Course content

7 sections • 8 lectures • 4h 3m total length

  • Preview01:36
  • Preview03:10

  • Preview33:44

  • All About Cursors. Why You Need Them.
    31:41

  • How To Be The Hero Of The Day: Finding SQL Statements and Execution Plans
    40:25

  • Optimizer Stats: The Secret Weapon Of The DBA
    34:33

  • Getting Information from the AWR
    50:20

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

Instructor

Diana Robete
Senior Oracle DBA, Oracle Ace and Founder of DBAParadise
Diana Robete
  • 4.6 Instructor Rating
  • 75 Reviews
  • 331 Students
  • 1 Course

I am so thrilled you landed on my course!

I always wondered what does it take to be an exceptional DBA. Is it knowledge, skill, certifications, attitude? Maybe all of them.

I created DBAParadise in 2016, with the intention of helping DBAs around the world to grow in their career, by providing useful blog posts, step by step guides and blueprints to the Oracle community.

My goal is to inspire DBAs to become exceptional in their careers and always reach higher.

My expertise comes from the 15+ years of experience as an Oracle DBA Consultant. I have seen and fixed many performance problems in Oracle databases. From my observations, what all of the performance problems have in common, is the repeatable methodology I use to troubleshoot them.

That is how my first course The Ultimate SQL Tuning Formula was born.

My love of teaching started in 2006, as an Oracle instructor, at the Southern Alberta Institute of Technology in Canada, where I taught Oracle classes in the everning.

Last year my readers nominated me for the Oracle Ace program, and I became an Oracle Ace Associate.

This is the best time to sharpen your skills, and become the best DBA you can be!


  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.