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
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Life Purpose Meditation 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 Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling 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
2020-12-31 20:19:37
30-Day Money-Back Guarantee
Office Productivity Oracle Oracle SQL

Oracle SQL Performance Tuning Masterclass 2021

Become an Expert on Oracle SQL Tuning and Solve All The Performance Problems of Your SQL Queries and the Database!
Bestseller
Rating: 4.6 out of 54.6 (3,339 ratings)
18,719 students
Created by Oracle Master Training • 80,000+ Students Worldwide, Code Star Academy
Last updated 2/2021
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Learn How to Solve Critical Performance Problems with Step by Step Approach!
  • Learn Advanced Indexing Techniques for Ultimate Database Performance!
  • Learn How to Use Various Performance Tuning Tools for In-Depth Assistance!
  • Maximize the Query Performance by Using Advanced Tuning Tecniques!
  • Learn Oracle Database Architecture by "Tuning" aspects.
  • Identify and Optimize the Performance of poorly performing (bad) SQLs.
  • Understand SQL Tuning Terminologies
  • Learn How to Create "Better" Queries
  • Learn How to Prioritize your SQL Tuning Efforts.
  • Learn the Details of How an SQL Code is Interpreted
  • Learn Useful Hints to improve Performance of your Queries
  • Learn & Improve How to Use Oracle Optimizer and Execution Plans Well
  • Various Tips and Tricks to make the Oracle SQL queries run faster.
  • Oracle Performance Tuning on both Oracle11g and Oracle12c Environment.
  • Learn Efficient Schema Design
  • Lifetime Support from the Authors.
  • Weekly Quizzes & Assesment Tests
  • Working materials and always up to date!
Curated for the Udemy for Business collection

Requirements

  • SQL Knowledge
  • Basic PL/SQL Knowledge

Description

★ Here is the most comprehensive SQL Tuning course that you will not need to take any other courses in anywhere.

★ This course will be continuously getting updated with more lectures, quizzes, assessments to enhance your knowledge on Oracle SQL Tuning.

The most common problem of working with SQL is, performance problems. Most of the developers don't know how to write well-performing queries. So in time, this problem grows and becomes a problem for both the developer and the company.

This course will teach you how to tune your SQL statements and database step by step for a perfect performance! You will learn how to write fast, reliable, and secure queries. Besides, you will learn the database architecture and will be able to optimize the database workloads.

Once you complete this course, you will recognize the database terms better and will use the most appropriate one for the performance.

Once you complete this course, you will be able to:

  • Find the poorly performing queries

  • Learn Advanced Query Tuning Techniques

  • Understand the Database Architecture to perform Better Tuning Techniques

  • Learn Advanced Indexing Techniques to Maximize Database Performance

  • Learn how to use various Performance Tuning Tools

  • Compare BAD vs GOOD Queries with Hands-on Examples.

  • Gather Statistics for the bad SQLs

  • Interpret the Execution Plans with different methods

  • Choose an appropriate SQL tuning approach

  • Guide the Oracle Optimizer for a better execution

  • Use various tuning techniques like using bind variables, different types of indexes, and much more.

  • Improve the performance of the queries & database

  • Gain Complete Knowledge in Oracle SQL and Performance Tuning!


Briefly, the knowledge of SQL Tuning is a "must" for IT Professionals and this course is the magic pill for that you're seeking for Becoming a Performance Expert!

If you want to step ahead in your career, "SQL & Performance Tuning" should be your next step.

See you in the first lecture!

Who this course is for:

  • SQL Developers
  • Data Analysts
  • Data Scientists
  • PL/SQL Developers
  • Oracle DBAs
  • Oracle BI Developers

Course content

14 sections • 226 lectures • 20h 1m total length

  • Preview04:52
  • UDEMY 101: How to Use Udemy? +Some Useful Tips (Do not Skip)
    05:01
  • Welcome! +Course Document
    00:33

  • Preview05:55
  • Preview06:20

  • Do You Have a Running Database in Your PC?
    00:29
  • Why to know the Oracle Database Architecture and how much to know?
    02:31
  • Oracle Database Architecture Overview (Part 1)
    Preview09:17
  • Oracle Database Architecture Overview (Part 2)
    06:04
  • Database Data Blocks in Detail
    07:57
  • What is PGA?
    Preview05:32
  • What is Shared Pool?
    06:31
  • What is Buffer Cache?
    05:24
  • What is Redo Log Buffer?
    04:18
  • What is Undo?
    03:49
  • How a DML is processed and committed
    04:28
  • Automatic Memory Management
    02:06
  • Oracle Database Storage Architecture
    03:57
  • Logical and Physical Database Structure
    06:13
  • Quiz - Database Architecture
    8 questions

  • When to Tune?
    07:40
  • What is a Bad SQL?
    05:08
  • Effective Schema Design
    08:42
  • Table Partitioning
    07:15
  • How an SQL Statement is Processed?
    09:32
  • Why do we need the Optimizer?
    05:41
  • Optimizer Overview
    03:25
  • Query Transformer
    08:44
  • Selectivity & Cardinality
    08:02
  • What is "cost" in detail?
    04:51
  • Plan Generator
    03:56
  • Row Source Generator
    03:38
  • SQL Tuning Principles and Strategies
    08:10
  • Query Analysis Strategy
    12:58
  • SQL Tuning Basics Assessment Test
    12 questions

  • Execution Plan and Explain Plan in Details
    07:24
  • Generating Statistics (Part 1)
    06:16
  • Generating Statistics (Part 2)
    07:15
  • Generating Statistics (Part 3)
    08:50
  • Generating Statistics (Code Samples)
    00:20
  • Generating Execution Plan
    12:06
  • Generating Execution Plan (Code Samples)
    00:09
  • Autotrace
    Preview12:38
  • Autotrace (Code Samples)
    00:09
  • V$SQL_PLAN View
    Preview11:11
  • V$SQL_PLAN (Code Samples)
    00:23
  • Reading the Execution Plans (Part 1)
    13:12
  • Reading the Execution Plans (Part 2)
    10:29
  • Reading the Execution Plans (Code Samples)
    00:07
  • Analyzing the Execution Plans
    08:18
  • Analyzing the Execution Plans (Code Samples)
    00:14
  • Execution Plans & Statistics
    10 questions

  • What are Indexes and How They work in details?
    10:51
  • Types of Table and Index Access Paths
    11:59
  • Table Access Full
    08:35
  • Table Access Full (Code Samples)
    00:11
  • Table Access by ROWID
    06:18
  • Table Access by ROWID (Code Samples)
    00:07
  • Index Unique Scan
    04:48
  • Index Range Scan
    10:40
  • Index Range Scan (Code Samples)
    00:30
  • Index Full Scan
    Preview09:34
  • Index Full Scan (Code Samples)
    01:00
  • Index Fast Full Scan
    06:37
  • Index Fast Full Scan (Code Samples)
    00:29
  • Index Skip Scan
    14:14
  • Index Skip Scan (Code Samples)
    00:25
  • Index Join Scan
    05:37
  • Index Join Scan (Code Samples)
    00:12
  • Table & Index Access Paths
    10 questions

  • What are Hints and Why to Use Them?
    04:04
  • How to use Hints
    15:21
  • How to use Hints (Code Samples)
    01:21
  • List of Some Useful Hints
    00:08
  • Using Hints
    5 questions

  • Join Methods Overview
    05:10
  • Nested Loop Joins
    12:09
  • Nested Loop Join (Code Samples)
    00:31
  • Sort Merge Joins
    10:19
  • Sort Merge Join (Code Samples)
    00:24
  • Hash Joins
    11:08
  • CODE: Hash Joins
    00:09
  • Cartesian Joins
    06:28
  • CODE: Cartesian Joins
    00:03
  • Join Types Overview
    03:00
  • Equijoins & Nonequijoins
    03:36
  • CODE: Equijoins & Nonequijoins
    00:06
  • Outer Joins
    11:16
  • CODE: Outer Joins
    00:31
  • Semijoins
    06:00
  • CODE: Semijoins
    00:10
  • Antijoins
    03:26
  • CODE: Antijoins
    00:19
  • Join Operations
    7 questions

  • Result Cache Operator
    11:23
  • CODE: Result Cache Operator
    00:18
  • View Operator
    07:29
  • CODE: View Operator
    00:37
  • Clusters
    14:31
  • CODE: Clusters
    00:31
  • Sort Operators
    07:07
  • CODE: Sort Operators
    00:10
  • INLIST Operator
    04:25
  • CODE: INLIST Operator
    00:17
  • Count Stopkey Operator
    03:34
  • CODE: Count Stopkey Operator
    00:06
  • First Row Operator
    05:15
  • CODE: First Row Operator
    00:08
  • Filter Operator
    01:41
  • CODE: Filter Operator
    00:02
  • Concatenation Operator
    03:06
  • CODE: Concatenation Operator
    00:04
  • UNION Operators
    02:54
  • CODE: Union Operators
    00:07
  • Intersect Operator
    05:20
  • CODE: Intersect Operator
    00:18
  • Minus Operator
    01:49
  • CODE: Minus Operator
    00:11
  • Other Optimizer Operators
    5 questions

  • How to find a performance problem and its tuning solution?
    15:05
  • Ways of Getting the Execution Plan and the Statistics
    16:27
  • Using the Real-Time SQL Monitoring Tool Part 1
    10:35
  • Using the Real-Time SQL Monitoring Tool Part 2
    13:55
  • Using the Real-Time SQL Monitoring Tool Part 3
    12:00
  • CODE: Using the Real-Time SQL Monitoring Tool
    00:17
  • Using the Trace Files & TKPROF Utility - Part 1
    15:56
  • Using the Trace Files & TKPROF Utility - Part 2
    20:21
  • Using the Trace Files & TKPROF Utility - Part 3
    10:22
  • CODE: Using the Trace Files & TKPROF Utility
    00:15
  • Get What You Need Only
    07:13
  • CODE: Get What You Need Only
    00:04
  • Index Usage
    16:24
  • CODE: Index Usage
    00:37
  • Using Concatenation Operator
    03:35
  • CODE: Using Concatenation Operator
    00:05
  • Using Arithmetic Operators
    03:15
  • CODE: Using Arithmetic Operators
    00:06
  • Using Like Conditions
    06:43
  • CODE: Using Like Conditions
    00:13
  • Using Functions on the Indexed Columns
    04:52
  • CODE: Using Functions on the Indexed Columns
    00:11
  • Handling NULL-Based Performance Problems
    08:08
  • CODE: Handling NULL-Based Performance Problems
    00:26
  • Using EXISTS instead of IN Clause
    05:02
  • Using TRUNCATE instead of DELETE command
    04:37
  • CODE: Using TRUNCATE instead of DELETE command
    00:06
  • Data Type Mismatch
    05:35
  • CODE: Data Type Mismatch
    00:13
  • Tuning Ordered Queries
    07:09
  • CODE: Tuning Ordered Queries
    00:14
  • Retrieving the MIN & MAX Values
    10:52
  • CODE: Retrieving the MIN & MAX Values
    00:15
  • UNION and UNION ALL Operators (Which one is faster?)
    03:17
  • UNION and UNION ALL Operators (Which one is faster?)
    00:07
  • Avoid Using the HAVING Clause!
    05:22
  • CODE: Avoid Using the HAVING Clause!
    00:11
  • Preview10:22
  • CODE: Be Careful on Views!
    00:38
  • Create Materialized Views
    07:26
  • CODE: Create Materialized Views
    00:28
  • Avoid Commit Too Much or Too Less!
    04:36
  • Partition Pruning
    06:10
  • CODE: Partition Pruning
    00:07
  • Using BULK COLLECT
    10:01
  • CODE: Using BULK COLLECT
    01:06
  • Tuning the Join Order
    06:49
  • CODE: Tuning the Join Order
    00:19
  • Multitable DML Operations
    07:19
  • CODE: Multitable DML Operations
    00:51
  • Using Temporary Tables
    07:18
  • CODE: Using Temporary Tables
    00:35
  • Combining SQL Statements
    04:55
  • CODE: Combining SQL Statements
    00:19
  • Using "WITH" Clause
    08:12
  • CODE: Using WITH Clause
    00:59
  • Using Analytical Functions
    04:49
  • CODE: Using Analytical Functions
    00:15
  • SQL Tuning Techniques
    5 questions

Instructors

Oracle Master Training • 80,000+ Students Worldwide
Oracle Architect & Best Selling Instructor
Oracle Master Training • 80,000+ Students Worldwide
  • 4.5 Instructor Rating
  • 16,581 Reviews
  • 84,290 Students
  • 7 Courses

I have been working for more than 20+ years on software development on many programming languages (like C, C++, Java, C#, Python, PHP, etc.) and about 15+ years on SQL & PL/SQL programming using many different Oracle Technologies. And also I'm a software development manager for more than 15 years.

Currently, I work as a Project Manager on a huge database which has more than 20 million active-users, and at the same time, teaching SQL & PL/SQL and many programming languages such as Python, C, Java, PHP programming, etc.

Code Star Academy
Software Training Center | Over 80.000+ Successful Students
Code Star Academy
  • 4.5 Instructor Rating
  • 16,581 Reviews
  • 84,290 Students
  • 7 Courses

Hi, welcome to our courses.

'Code Star' Academy is a platform and community that teaches SQL & PL/SQL Development, SQL Tuning, Python Programming, Web Development and many Computer Science related topics. 

Through a passion for tech and what it means to be a Computer Scientist and Developer, Code Star Academy creates great courses, blog posts and videos to instruct, inspire and spread these topics across a large spectrum.

Our Mission, give others the opportunity to be part of an amazing field whilst teaching them the skills that will allow them to do so.

Our expertise areas are mainly:

★ Programming Languages (Python, SQL, PL&SQL, PHP, Java, etc.)

★ Database Development

★ Data Science

★ Big Data

★ Cloud Computing

★ Data Mining

★ Data Visualization

★ Data Security

★ Computer Security               

✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯

► Time is so precious so every second costs you money ($$$)

☞ Don't postpone your dreams ☜

✔ Enroll to our courses right now!

✔ Success is your destiny and we are waiting for you!

✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯

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