Discover new courses and celebrate learning with us today. 🎓

Explore

Development

Web Development

Oracle SQL Performance Tuning Masterclass (2024)

4.9

315,475 rating
11 Lessons
229 Students
Last updated 1 month ago

By Database Masters Training | 250,000+ Students Worldwide

By Code Star Academy

via Udemy

Go To Course

About This Course

Become an Expert on Oracle SQL Tuning and Solve All The Performance Problems of Your SQL Queries and the Database!

Welcome the most comprehensive SQL Tuning course on the planet that makes you an expert on SQL & Performance Tuning!

Important Notice: This SQL & Performance Tuning 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 SQL 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.
Learn How to Gather Statistics for 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!

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!

Course Curriculum

SQL & Perfomance Tuning Course Introduction

3 Lectures

SQL & Performance Tuning Course Overview

UDEMY 101: How to Use Udemy? +Some Useful Tips (Do not Skip)

Welcome Gift! + Course Document

What is SQL (Performance) Tuning and Why We Need?

2 Lectures

What is SQL Tuning and Why to Do That?

What to Know Before Starting the Course?

Oracle Database Architecture

14 Lectures

Do You Have a Running Database in Your PC?

Why to know the Oracle Database Architecture and how much to know?

Oracle Database Architecture Overview (Part 1)

Oracle Database Architecture Overview (Part 2)

Database Data Blocks in Detail

What is PGA?

What is Shared Pool?

What is Buffer Cache?

What is Redo Log Buffer?

What is Undo?

How a DML is processed and committed

Automatic Memory Management

Oracle Database Storage Architecture

Logical and Physical Database Structure

Quiz - Database Architecture

SQL Tuning Basics

14 Lectures

When to Tune?

What is a Bad SQL?

Effective Schema Design

Table Partitioning

How an SQL Statement is Processed?

Why do we need the Optimizer?

Optimizer Overview

Query Transformer

Selectivity & Cardinality

What is "cost" in detail?

Plan Generator

Row Source Generator

SQL Tuning Principles and Strategies

Query Analysis Strategy

SQL Tuning Basics Assessment Test

Execution Plans & Statistics

16 Lectures

Execution Plan and Explain Plan in Details

Generating Statistics (Part 1)

Generating Statistics (Part 2)

Generating Statistics (Part 3)

Generating Statistics (Code Samples)

Generating Execution Plan

Generating Execution Plan (Code Samples)

Autotrace

Autotrace (Code Samples)

V$SQL_PLAN View

V$SQL_PLAN (Code Samples)

Reading the Execution Plans (Part 1)

Reading the Execution Plans (Part 2)

Reading the Execution Plans (Code Samples)

Analyzing the Execution Plans

Analyzing the Execution Plans (Code Samples)

Execution Plans & Statistics

Table & Index Access Paths

17 Lectures

What are Indexes and How They work in details?

Types of Table and Index Access Paths

Table Access Full

Table Access Full (Code Samples)

Table Access by ROWID

Table Access by ROWID (Code Samples)

Index Unique Scan

Index Range Scan

Index Range Scan (Code Samples)

Index Full Scan

Index Full Scan (Code Samples)

Index Fast Full Scan

Index Fast Full Scan (Code Samples)

Index Skip Scan

Index Skip Scan (Code Samples)

Index Join Scan

Index Join Scan (Code Samples)

Table & Index Access Paths

Optimizer Hints

4 Lectures

What are Hints and Why to Use Them?

How to use Hints

How to use Hints (Code Samples)

List of Some Useful Hints

Using Hints

Join Operations

18 Lectures

Join Methods Overview

Nested Loop Joins

Nested Loop Join (Code Samples)

Sort Merge Joins

Sort Merge Join (Code Samples)

Hash Joins

CODE: Hash Joins

Cartesian Joins

CODE: Cartesian Joins

Join Types Overview

Equijoins & Nonequijoins

CODE: Equijoins & Nonequijoins

Outer Joins

CODE: Outer Joins

Semijoins

CODE: Semijoins

Antijoins

CODE: Antijoins

Join Operations

Other Optimizer Operators

24 Lectures

Result Cache Operator

CODE: Result Cache Operator

View Operator

CODE: View Operator

Clusters

CODE: Clusters

Sort Operators

CODE: Sort Operators

INLIST Operator

CODE: INLIST Operator

Count Stopkey Operator

CODE: Count Stopkey Operator

First Row Operator

CODE: First Row Operator

Filter Operator

CODE: Filter Operator

Concatenation Operator

CODE: Concatenation Operator

UNION Operators

CODE: Union Operators

Intersect Operator

CODE: Intersect Operator

Minus Operator

CODE: Minus Operator

Other Optimizer Operators

SQL Tuning Techniques

58 Lectures

How to find a performance problem and its tuning solution?

Ways of Getting the Execution Plan and the Statistics

Using the Real-Time SQL Monitoring Tool Part 1

Using the Real-Time SQL Monitoring Tool Part 2

Using the Real-Time SQL Monitoring Tool Part 3

CODE: Using the Real-Time SQL Monitoring Tool

Using the Trace Files & TKPROF Utility - Part 1

Using the Trace Files & TKPROF Utility - Part 2

Using the Trace Files & TKPROF Utility - Part 3

CODE: Using the Trace Files & TKPROF Utility

Get What You Need Only

CODE: Get What You Need Only

Index Usage

CODE: Index Usage

Using Concatenation Operator

CODE: Using Concatenation Operator

Using Arithmetic Operators

CODE: Using Arithmetic Operators

Using Like Conditions

CODE: Using Like Conditions

Using Functions on the Indexed Columns

CODE: Using Functions on the Indexed Columns

Handling NULL-Based Performance Problems

CODE: Handling NULL-Based Performance Problems

Using EXISTS instead of IN Clause

Using TRUNCATE instead of DELETE command

CODE: Using TRUNCATE instead of DELETE command

Data Type Mismatch

CODE: Data Type Mismatch

Tuning Ordered Queries

CODE: Tuning Ordered Queries

Retrieving the MIN & MAX Values

CODE: Retrieving the MIN & MAX Values

UNION and UNION ALL Operators (Which one is faster?)

Avoid Using the HAVING Clause!

CODE: Avoid Using the HAVING Clause!

Be Careful on Views!

CODE: Be Careful on Views!

Create Materialized Views

CODE: Create Materialized Views

Avoid Commit Too Much or Too Less!

Partition Pruning

CODE: Partition Pruning

Using BULK COLLECT

CODE: Using BULK COLLECT

Tuning the Join Order

CODE: Tuning the Join Order

Multitable DML Operations

CODE: Multitable DML Operations

Using Temporary Tables

CODE: Using Temporary Tables

Combining SQL Statements

CODE: Combining SQL Statements

Using "WITH" Clause

CODE: Using WITH Clause

Using Analytical Functions

CODE: Using Analytical Functions

SQL Tuning Techniques

Tuning with ADVANCED Indexing Techniques

29 Lectures

Why Indexing is Important?

Index Selectivity & Cardinality

B-Tree Indexes in Details

CODE: B-Tree Indexes in Details

Bitmap Indexes in Details

CODE: Bitmap Indexes in Details

Bitmap Operations

Composite Indexes and Order of Indexed Columns

CODE: Composite Indexes and Order of Indexed Columns

Covering Indexes

CODE: Covering Indexes

Reverse Key Indexes

Bitmap Join Indexes

CODE: Bitmap Join Indexes

Combining Bitmap Indexes

CODE: Combining Bitmap Indexes

Function-Based Indexes

CODE: Function-Based Indexes

Index-Organized Tables

CODE: Index-Organized Tables

Cluster Indexes

CODE: Cluster Indexes

Invisible Indexes

CODE: Invisible Indexes

Index Key Compression- Part 1

Index Key Compression- Part 2

CODE: Index Key Compression

Full-Text Searches

CODE: Full-Text Search Indexes

Advanced SQL Tuning Techniques

14 Lectures

Tuning Star Queries

CODE: Tuning Star Queries

Using Bind Variables

CODE: Using Bind Variables

Beware of Bind Variable Peeking

CODE: Beware of Bind Variable Peeking

Cursor Sharing

CODE: Cursor Sharing

Adaptive Cursor Sharing

CODE: Adaptive Cursor Sharing

Adaptive Plans

CODE: Adaptive Plans

Dynamic Statistics (Dynamic Sampling)

CODE: Dynamic Statistics (Dynamic Sampling)

Appendix: Software Installations

18 Lectures

About the Database Installation

The Ways to Get a Database

Option 1: Installing VMware and VirtualBox on Windows

Option 1: How to Install the Virtual Box on Mac OS X?

Option 1: Downloading Virtual Machine Image (19c)

Option 1: Downloading Virtual Machine Image(If the previous lecture didn't work)

Option 1: Configuring the VMware Virtualization Software

Option 1: Configuring the Oracle VirtualBox Virtualization Software

Option 1: Configuring SQL Developer inside of the Virtual Machine

Option 2: What is Pluggable Database?

Option 2: Downloading and Installing the Oracle Database

Option 2: Unlocking the HR Schema

Option 2: Configuring and Using Oracle SQL Developer

Option 2: Installing Sample Schemas in Oracle Database

Extra: 12c Installation

Option 2: How to Unlock the HR Schema in the Oracle Database 12c?

Option 2: Oracle Database 12c Installation into Your Computer

Option 2: Configuring and Using Oracle SQL Developer for Oracle Database 12c

Bonus

1 Lectures

Bonus Lecture

Instructors

Database Masters Training | 250,000+ Students Worldwide

4.9

315,475 Reviews
345 Students
34 Course

We have been working for more than 28 years on software development on many programming languages (like C, C++, Java, C#, Python, PHP, etc.) and about 25+ years on SQL & PL/SQL programming using many different Oracle Technologies.Currently, I work as a Project Manager on a huge database which has more than 20 million active-users, and at the same time,...

Instructors

Code Star Academy

4.9

315,475 Reviews
345 Students
34 Course

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

More Courses By Database Masters Training | 250,000+ Students Worldwide, Code Star Academy

The Complete Oracle SQL Bootcamp (2024)

4.9

(230)

Advanced SQL : The Ultimate Guide (2024)

4.9

(230)

SQL for Beginners: The Easiest Way to Learn SQL Step by Step

4.9

(230)

PHP for Beginners : Learn PHP Programming From Scratch!

4.9

(230)

The Complete PL/SQL Bootcamp : "Beginner to Advanced PL/SQL"

4.9

(230)

Review

4.9 course rating

4K ratings

Avinash N.

4.0

7 months ago

It is good, explored many new areas of tuning with the help of this course.
Covered examples are very basics, If we could cover example with complex sql (i.e. SQL with multiple layers of subqueries and joins with huge cost ) it will be better learning experience for all students.

wonderful efforts. Thanks!!

Helpful
Not helpful

Magdalena K.

5.0

7 months ago

Great course!

Helpful
Not helpful

Rakesh G.

4.0

7 months ago

Excellent

Helpful
Not helpful

Victor H. C. C. S.

4.5

7 months ago

Gostaria de compartilhar minha experiência com o curso "Oracle SQL Performance Tuning Masterclass". Recentemente, concluí o curso e foi uma jornada extremamente gratificante. Aprendi a identificar e resolver problemas de desempenho de consultas de forma eficaz, a usar ferramentas avançadas de diagnóstico e a otimizar consultas complexas.

O instrutor foi excepcional, sempre dispostos a ajudar e esclarecer dúvidas. O conteúdo foi bem estruturado, com uma ótima combinação de teoria e prática. Com certeza, as habilidades que adquiri serão de grande valor na minha carreira.

Recomendo fortemente este curso para qualquer um que queira aprofundar seus conhecimentos em SQL e otimização de desempenho no Oracle.

Obrigado!

Helpful
Not helpful

Hong H. N.

4.5

7 months ago

Useful

Helpful
Not helpful

Thanigaivel R.

4.0

7 months ago

Helpful
Not helpful

Heptagon

5.0

7 months ago

Thank you. I will work hard.

Helpful
Not helpful

Hung K. V.

4.5

7 months ago

it's very good and helpful to me

Helpful
Not helpful

Waly Y. V. R.

5.0

7 months ago

Excelente

Helpful
Not helpful

Adi M.

5.0

8 months ago

Great coure for anyone who want to start learning about oracle performance tuning

Helpful
Not helpful

Ratings

This course includes:

54.5 hours on-demand video
3 articles
249 downloadable resources
Access on mobile and TV
Full lifetime access
Certificate of completion

Courses You May Like

Lorem ipsum dolor sit amet elit

Show More Courses

Become a Certified Web Developer: HTML, CSS and JavaScript

4.9

(230)

By: Carolyn Welborn

Oracle SQL Performance Tuning Masterclass (2024)

About This Course

Course Curriculum

Instructors

Database Masters Training | 250,000+ Students Worldwide