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 CompTIA Security+ Amazon AWS 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 Personal Transformation Meditation 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
Personal Development Personal Productivity Oracle SQL

Oracle SQL : Mastering Oracle SQL Performance Tuning

Oracle SQL Query Tuning and Architecture | Solve critical Oracle SQL query performance issues | Advanced SQL Tuning
Bestseller
Rating: 4.4 out of 54.4 (225 ratings)
5,089 students
Created by Prathap G
Last updated 10/2019
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Step by Step approach on troubleshooting badly performing SQL queries.
  • Identify how internal Oracle components affects the performance of the SQL query.
  • Identify potential performance bottlenecks by reading the Explain plan of the queries.
  • Tips and Tricks to make the Oracle SQL query run faster.
  • Compare BAD vs GOOD Queries with Examples.
  • Understand how STATISTICS and CARDINALITY affects the performance of the SQL Query.
  • Implications of JOINS and ACCESS Methods on the performance of the Query.
  • Oracle Performance Tuning on both Oracle11g and Oracle12c Environment.
  • Advanced SQL Query Tuning Steps.

Requirements

  • Basic understanding of Oracle SQL Query writing.
  • No prerequisite software required. You should be able to use PC/laptop comfortably.

Description

*** This Course purchase includes video lectures, practice files, quizzes, & assignments, 1-on-1 instructor support***

Please note that this course will be continuously getting updated with more videos to keep you up to date on Oracle SQL Tuning. You will find lot of new lecture covering new features in the area of  Oracle SQL Tuning. Best part about this course is that, You can also demand a lecture on a specific topic of  SQL Tuning, which comes under the scope and I will make sure that the section on that Topic is added .

This course is designed to take the Oracle SQL Developers, Analysts, DBA to next level in SQL Query Tuning. You will find Various ways to optimize and tune the queries in the Production Environment. The professional who wants to start with the tuning of Oracle SQL queries and have  basic idea of writing and reading queries, will find it extremely easy to understand.

How many times have we seen this. A Production batch job or a SQL Query  is hung or consuming more time. Majority of the times we are clueless on what needs to be done or how it has to be troubleshooted.

I will Guide you through a STEP by STEP approach on how to troubleshoot the badly performing SQL Queries. We will also talk about the Oracle components that need to be checked and looked at. This course will also teach you how to interpret various components and identify the actual reason why the SQL Query is taking time. We will not stop there. We will also look at what fixes could be applied to make the SQL Query work faster.

I have taken a systematic approach in identifying , analyzing and troubleshooting badly performing SQL Query and will provide you with the skills required to write highly efficient Oracle SQL queries.

There is a separate section on most commonly seen problems in SQL Queries and have provided TIPS and TRICKS on correcting those SQL queries . So, next time, you do a Code review or write your own code, you can follow some of of the BEST Practices mentioned to proactively solve the SQL Performance Issues.
 
You should be able to complete this course in a week time, if you dedicate 2 hours of your time daily and this journey will take you from Oracle SQL Tuning beginners to expert Level.

Important Topics covered:

  • Gather statistics for the bad SQL

  • Understand the Cardinality and Execution Plan

  • Advanced Query Tuning Techniques.

  • Understand the Various components of the Execution Plans and interpret them

  • Understand the Index in depth and its impact on Performance

  • Guide Oracle Optimizer to choose a better execution Plan.

  • Tips and Tricks to tune the SQL Queries.

  • Gain Oracle performance tuning knowledge on Oracle11g and Oracle12c

  • Adaptive Cursor Sharing

Briefly, The knowledge of SQL Tuning is a must for IT professionals and this course is one stop shop for gaining this necessary and in-demand skill.

Trust me, I will make sure you have an awesome learning experience and will hold your hand and take you step by step!!! 

Happy Oracle SQL Tuning :-)

Who this course is for:

  • Oracle SQL Developers who want to optimize the SQL queries.
  • Aspirants seeking career opportunities in Oracle Database and SQL.
  • DBA, Developers, Support Analyst who wants to troubleshoot Oracle SQL queries and fix it.

Course content

12 sections • 61 lectures • 6h 26m total length

  • Preview01:43

  • Introduction to Oracle Architecture
    03:04
  • Oracle Storage
    05:50
  • Preview06:59
  • Oracle Background Process
    04:34
  • Oracle PGA
    03:21
  • Oracle Terminology
    03:04
  • Preview08:56
  • Quiz
    4 questions

  • Explain Plan and it's contents
    06:47
  • Generate and View the Explain Plan
    13:17
  • View Explain Plan and Statistics in SQL * PLUS
    07:35
  • Analyze the Explain Plan
    Preview17:56
  • Quiz
    5 questions

  • Soft/Hard Parse
    06:05

  • Oracle Statistics
    06:57
  • Generate Statistics
    13:17
  • Importance of Cardinality
    Preview19:37
  • Statistics/Cardinality Feedback
    10:18
  • Extended Statistics
    09:30
  • Histogram
    08:12

  • Index and its types
    03:17
  • B-Tree Index
    Preview11:22
  • Descending Index
    04:21
  • Key Compressed Index
    07:41
  • Reverse Key Index
    03:59
  • Function Based Index
    03:45
  • B-Tree Clustered Index
    03:19
  • IOT Index
    03:33
  • Bit Map Index
    05:59
  • Quiz
    11 questions

  • Access Methods
    02:37
  • Full Table Scan
    04:03
  • Index Fast Full Scan
    04:04
  • Index Full Scan
    02:57
  • Index Range Scan
    05:41
  • Index Unique Scan
    03:52
  • Index Skip Scan
    03:39

  • Overview of Joins
    03:20
  • Nested Loop Join
    05:59
  • Sort Merge Join
    Preview05:20
  • Hash Join
    06:51
  • Quiz
    4 questions

  • Parallel Hint
    03:45
  • Append Hint
    02:55
  • CTAS Statement
    Preview04:06
  • Union Vs Union ALL
    03:48
  • Multiple Scan Statements
    03:37
  • Expression on Index Columns
    03:10
  • Truncate Vs Delete
    03:32
  • Unnecessary Sort
    02:23
  • Bad Usage of * in Select
    02:23
  • Having in Group By
    02:21
  • Use of Alias
    02:09

  • Bind Peeking Problem
    03:18
  • Adpative Cursor sharing (Part 1)
    14:04
  • Adpative Cursor sharing (Part 2)
    19:44
  • Preview10:16
  • Dynamic Sampling
    Preview06:07

Instructor

Prathap G
Technical Enterprise Architect
Prathap G
  • 4.3 Instructor Rating
  • 608 Reviews
  • 11,407 Students
  • 3 Courses

Prathap is an IT professional who has 15 years of Experience and diversified knowledge across multiple domains in the industry. Working in a leading Product/Cloud provider company. He has taken various roles in his career from Developer, Designer, Consultant, Architect, Performance Management and is currently ramping up his skills on latest generation Tools and Products.

Prathap has vast knowledge on Database(Oracle/SQL Server/PostgreSQL), Python, Performance Management, DevOps  Tools and Microsoft Azure.

He loves to teach from very beginning and Udemy is the platform that helps him in continuation of the same passion.

  • 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.