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+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Meditation Life Purpose Coaching 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 Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Data Science
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++ Unreal Engine Blueprints 2D Game Development Blender
30-Day Money-Back Guarantee

This course includes:

  • 3 hours on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
IT & Software Other IT & Software SQL

SQL Tuning

Learn how to formulate and tune SQL statements for optimal performance
Rating: 3.7 out of 53.7 (1,106 ratings)
7,628 students
Created by Amarnath Reddy
Last updated 7/2015
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Identify poorly performing SQL
  • Understand how the Query Optimizer makes decisions about how to access data
  • Define how optimizer statistics affect the performance of SQL
  • List the possible methods of accessing data, including different join methods
  • Modify a SQL statement to perform at its best

Requirements

  • Database/SQL knowledge is a must to understand this course.

Description

Good SQL Developers are in high demand and demand 100k+ salary in the IT industry.

SQL performance tuning is an art to master - for all of us!!!

Many SQL Developers have tried to understand why a particualr SQL was running slow - including me - but have failed over and over again because we never tried to understand how SQL works? We were thinking it is database administrators Job!!!!

If we have to advance in our career and earn a good salary, we need these SQL tuning skills.

We know how it feels if someone talks about SQL Tuning and I dont want you to feel the same.

I took baby steps in introducing you to the optimizer and helping you write an effecient SQL.

This course takes a systematic approach to planning, analyzing, debugging and troubleshooting common query-related performance problems and will provide you with the skills necessary to write scalable, high performance SQL.

The SQL tuning methodology I used:

  • Identify a problem SQL statement
  • Determine how Oracle is executing SQL statement and why Oracle chose that way.
  • Investigate whether alternative executon plans would be better.
  • Update the SQL statement to push Oracle towards the better plan.


Trust me, I will catch your hand and take you step by step!!!

See you inside,

Amarnath Panyam

Who this course is for:

  • Database developers, DBAs and SQL developers

Featured review

ashish ranjan
ashish ranjan
16 courses
8 reviews
Rating: 5.0 out of 53 months ago
very well explained , how SQL query run inside was not clear to me but now i know what are things happens inside the oracle and how we can improve the performance by Sql query tuning with avoid suppressing indexes.

Course content

12 sections • 61 lectures • 3h 5m total length

  • Preview03:13
  • Preview02:22
  • Preview04:07
  • Preview01:44
  • Parsing
    2 questions

  • Cost based Optimization
    02:08
  • Gathering Statistics
    03:13
  • Execution Plan
    02:11
  • SQL Tuning Tools
    02:22
  • Running Explain Plan
    02:57
  • Optimizer statistics
    3 questions

  • What is my Address?
    01:40
  • Types of Table Accesses
    01:44
  • Table Access FULL
    02:19
  • Table Access by ROWID
    02:23
  • Index Unique Scan
    03:03
  • Index Range Scan
    03:17
  • Choosing between FULL and INDEX scan
    01:46
  • Access Paths
    3 questions

  • Execution Plan
    01:12
  • What should you look for?
    03:24
  • What is COST?
    01:40
  • Rules of Execution Plan Tree
    02:40
  • Traversing through the Tree
    03:40
  • Reading Execution Plan
    02:59
  • Execution Plan Example #1
    02:15
  • Execution Plan Example #2
    03:09
  • Execution Plan Example #3
    04:34
  • Execution Plan Example #4
    06:33

  • SELECT consideration
    02:01
  • Using Table Aliases
    02:16
  • Using WHERE rather than HAVING
    02:57
  • Simple Rules
    3 questions

  • Index Suppression reasons
    01:48
  • Use of <> operator
    03:55
  • Use of SUBSTR function
    02:37
  • Use of Arithmetic operators
    02:13
  • Use of TRUNC function on Date columns
    02:16
  • Use of || operator
    02:29
  • Comparing a character column to a numeric value
    02:12
  • Use of IS NULL and IS NOT NULL
    03:00
  • Function based Indexes
    03:03
  • Index Suppression SQL
    4 questions

  • Use UNION ALL instead of UNION
    02:34
  • Minimize Table lookups in a Query
    02:49
  • EXISTS vs IN
    02:28
  • Use EXISTS instead of DISTINCT
    02:54
  • Reading same table multiple times?
    05:00
  • Use TRUNCATE instead of DELETE
    03:32

  • Reduce the number of Trips to the database
    01:52
  • Issue frequent COMMIT statements
    01:33
  • Using BULK COLLECT
    02:38

  • Join Methods
    01:13
  • Nested Loop Join
    05:02
  • Hash Join
    02:28
  • Sort Merge Join
    03:35

  • Why HINTS?
    04:26
  • Forcing a specific Join Method
    03:30
  • HINTS list
    3 pages

Instructor

Amarnath Reddy
Oracle Architect & Best Selling Instructor | 27000+ Students
Amarnath Reddy
  • 4.3 Instructor Rating
  • 15,296 Reviews
  • 68,014 Students
  • 9 Courses

Amarnath has a Masters Degree in computer science with around 15 years of experience in the IT industry. He has successfully designed and implemented projects for clients in South Africa, India and USA. Currently his main focus is on Datawarehouse Architecture.

Amarnath is currently working for a fortune 500 company in USA and has pioneered the data architecture discipline. His Innovative and simple architectural designs have won accolades in the company.

Today, he brings leadership and technical expertise to enable customers to optimize and modernize their IT environments leveraging Business Intelligence tools, Big Data, social, mobile, and the Internet of Things.

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