Oracle SQL Performance Tuning Masterclass (2023)

Home
Courses
Oracle SQL Performance Tuning Masterclass (2023)

Office Productivity / Oracle

Oracle SQL Performance Tuning Masterclass (2023)

Become an Expert on Oracle SQL Tuning

0.00 0 Review(s)

0 Students Enrolled

Expert

English

Ansel Haley

Oracle SQL Performance Tuning Masterclass (2023)

This Course Includes:

25h 57m
234 Lectures
350 Downloadable Assets
Full Lifetime Access
Access On Mobile And Tv
Certificate On Completion

At Just Price Of $527.00

Enroll Now

Favorite

Overview

What will students learn in your course?

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!

What are the requirements or prerequisites for taking your course?

SQL Knowledge
Basic PL/SQL Knowledge

Who is the course for?

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

Description

Course Tags

Course Content

14 Sections
234 Lectures
25h 57m Total Length

Section 1

SQL & Perfomance Tuning Course Introduction

Time 23m

Lectures 3

See All

SQL & Performance Tuning Course Overview

Preview 0:09:13

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

0:07:30

Welcome Gift! + Course Document

0:06:54

Section 2

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

Time 07m

Lectures 2

See All

Section 3

Oracle Database Architecture

Time 1h 35m

Lectures 15

See All

Do You Have a Running Database in Your PC?

0:03:41

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

0:07:30

Oracle Database Architecture Overview (Part 1)

Preview 0:09:13

Oracle Database Architecture Overview (Part 2)

0:09:13

Database Data Blocks in Detail

0:09:13

What is PGA?

Preview 0:06:54

What is Shared Pool?

0:06:12

What is Buffer Cache?

0:03:41

What is Redo Log Buffer?

0:07:30

What is Undo?

0:07:30

How a DML is processed and committed

0:06:54

Automatic Memory Management

0:03:41

Oracle Database Storage Architecture

0:03:41

Logical and Physical Database Structure

0:03:41

Quiz - Database Architecture

0:06:54

Section 4

SQL Tuning Basics

Time 1h 46m

Lectures 15

See All

When to Tune?

0:06:54

What is a Bad SQL?

0:03:41

Effective Schema Design

0:06:54

Table Partitioning

0:09:13

How an SQL Statement is Processed?

0:07:30

Why do we need the Optimizer?

0:09:13

Optimizer Overview

0:06:12

Query Transformer

0:07:30

Selectivity & Cardinality

0:09:13

What is "cost" in detail?

0:06:12

Plan Generator

0:07:30

Row Source Generator

0:06:12

SQL Tuning Principles and Strategies

0:06:12

Query Analysis Strategy

0:06:12

SQL Tuning Basics Assessment Test

0:07:30

Section 5

Execution Plans & Statistics

Time 1h 42m

Lectures 17

See All

Execution Plan and Explain Plan in Details

0:03:41

Generating Statistics (Part 1)

0:06:12

Generating Statistics (Part 2)

0:06:54

Generating Statistics (Part 3)

0:06:12

Generating Statistics (Code Samples)

0:07:30

Generating Execution Plan

0:06:54

Generating Execution Plan (Code Samples)

0:07:30

Autotrace

Preview 0:03:41

Autotrace (Code Samples)

0:06:12

V$SQL_PLAN View

Preview 0:07:30

V$SQL_PLAN (Code Samples)

0:07:30

Reading the Execution Plans (Part 1)

0:06:54

Reading the Execution Plans (Part 2)

0:03:41

Reading the Execution Plans (Code Samples)

0:03:41

Analyzing the Execution Plans

0:03:41

Analyzing the Execution Plans (Code Samples)

0:06:54

Execution Plans & Statistics

0:07:30

Section 6

Table & Index Access Paths

Time 2h 13m

Lectures 18

See All

What are Indexes and How They work in details?

0:09:13

Types of Table and Index Access Paths

0:07:30

Table Access Full

0:07:30

Table Access Full (Code Samples)

0:09:13

Table Access by ROWID

0:07:30

Table Access by ROWID (Code Samples)

0:07:30

Index Unique Scan

0:06:54

Index Range Scan

0:06:12

Index Range Scan (Code Samples)

0:09:13

Index Full Scan

Preview 0:09:13

Index Full Scan (Code Samples)

0:07:30

Index Fast Full Scan

0:06:54

Index Fast Full Scan (Code Samples)

0:06:54

Index Skip Scan

0:03:41

Index Skip Scan (Code Samples)

0:03:41

Index Join Scan

0:06:12

Index Join Scan (Code Samples)

0:09:13

Table & Index Access Paths

0:09:13

Section 7

Optimizer Hints

Time 42m

Lectures 5

See All

What are Hints and Why to Use Them?

0:09:13

How to use Hints

0:07:30

How to use Hints (Code Samples)

0:09:13

List of Some Useful Hints

0:09:13

Using Hints

0:07:30

Section 8

Join Operations

Time 2h 13m

Lectures 19

See All

Join Methods Overview

0:06:54

Nested Loop Joins

0:06:12

Nested Loop Join (Code Samples)

0:09:13

Sort Merge Joins

0:07:30

Sort Merge Join (Code Samples)

0:06:12

Hash Joins

0:03:41

CODE: Hash Joins

0:09:13

Cartesian Joins

0:07:30

CODE: Cartesian Joins

0:06:54

Join Types Overview

0:07:30

Equijoins & Nonequijoins

0:03:41

CODE: Equijoins & Nonequijoins

0:06:54

Outer Joins

0:09:13

CODE: Outer Joins

0:06:12

Semijoins

0:06:12

CODE: Semijoins

0:07:30

Antijoins

0:07:30

CODE: Antijoins

0:06:12

Join Operations

0:09:13

Section 9

Other Optimizer Operators

Time 2h 45m

Lectures 25

See All

Result Cache Operator

0:06:12

CODE: Result Cache Operator

0:06:12

View Operator

0:07:30

CODE: View Operator

0:07:30

Clusters

0:06:54

CODE: Clusters

0:03:41

Sort Operators

0:06:12

CODE: Sort Operators

0:03:41

INLIST Operator

0:09:13

CODE: INLIST Operator

0:06:12

Count Stopkey Operator

0:09:13

CODE: Count Stopkey Operator

0:07:30

First Row Operator

0:09:13

CODE: First Row Operator

0:06:12

Filter Operator

0:06:12

CODE: Filter Operator

0:06:54

Concatenation Operator

0:07:30

CODE: Concatenation Operator

0:07:30

UNION Operators

0:06:12

CODE: Union Operators

0:06:12

Intersect Operator

0:03:41

CODE: Intersect Operator

0:03:41

Minus Operator

0:06:54

CODE: Minus Operator

0:06:12

Other Optimizer Operators

0:09:13

Section 10

SQL Tuning Techniques

Time 6h 08m

Lectures 59

See All

How to find a performance problem and its tuning solution?

0:06:54

Ways of Getting the Execution Plan and the Statistics

0:06:54

Using the Real-Time SQL Monitoring Tool Part 1

0:06:12

Using the Real-Time SQL Monitoring Tool Part 2

0:03:41

Using the Real-Time SQL Monitoring Tool Part 3

0:03:41

CODE: Using the Real-Time SQL Monitoring Tool

0:06:12

Using the Trace Files & TKPROF Utility - Part 1

0:06:54

Using the Trace Files & TKPROF Utility - Part 2

0:07:30

Using the Trace Files & TKPROF Utility - Part 3

0:06:12

CODE: Using the Trace Files & TKPROF Utility

0:03:41

Get What You Need Only

0:09:13

CODE: Get What You Need Only

0:06:12

Index Usage

0:03:41

CODE: Index Usage

0:06:54

Using Concatenation Operator

0:06:54

CODE: Using Concatenation Operator

0:06:12

Using Arithmetic Operators

0:06:54

CODE: Using Arithmetic Operators

0:06:54

Using Like Conditions

0:09:13

CODE: Using Like Conditions

0:07:30

Using Functions on the Indexed Columns

0:06:54

CODE: Using Functions on the Indexed Columns

0:07:30

Handling NULL-Based Performance Problems

0:03:41

CODE: Handling NULL-Based Performance Problems

0:09:13

Using EXISTS instead of IN Clause

0:03:41

Using TRUNCATE instead of DELETE command

0:06:12

CODE: Using TRUNCATE instead of DELETE command

0:03:41

Data Type Mismatch

0:09:13

CODE: Data Type Mismatch

0:07:30

Tuning Ordered Queries

0:07:30

CODE: Tuning Ordered Queries

0:09:13

Retrieving the MIN & MAX Values

0:03:41

CODE: Retrieving the MIN & MAX Values

0:03:41

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

0:03:41

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

0:09:13

Avoid Using the HAVING Clause!

0:07:30

CODE: Avoid Using the HAVING Clause!

0:09:13

Be Careful on Views!

Preview 0:06:12

CODE: Be Careful on Views!

0:09:13

Create Materialized Views

0:06:54

CODE: Create Materialized Views

0:03:41

Avoid Commit Too Much or Too Less!

0:06:12

Partition Pruning

0:06:12

CODE: Partition Pruning

0:03:41

Using BULK COLLECT

0:07:30

CODE: Using BULK COLLECT

0:03:41

Tuning the Join Order

0:03:41

CODE: Tuning the Join Order

0:03:41

Multitable DML Operations

0:06:12

CODE: Multitable DML Operations

0:03:41

Using Temporary Tables

0:06:54

CODE: Using Temporary Tables

0:07:30

Combining SQL Statements

0:06:54

CODE: Combining SQL Statements

0:06:54

Using "WITH" Clause

0:06:54

CODE: Using WITH Clause

0:07:30

Using Analytical Functions

0:06:12

CODE: Using Analytical Functions

0:03:41

SQL Tuning Techniques

0:06:54

Section 11

Tuning with ADVANCED Indexing Techniques

Time 3h 17m

Lectures 29

See All

Why Indexing is Important?

Preview 0:06:54

Index Selectivity & Cardinality

0:03:41

B-Tree Indexes in Details

0:09:13

CODE: B-Tree Indexes in Details

0:06:12

Bitmap Indexes in Details

0:06:12

CODE: Bitmap Indexes in Details

0:09:13

Bitmap Operations

0:06:12

Composite Indexes and Order of Indexed Columns

0:06:54

CODE: Composite Indexes and Order of Indexed Columns

0:06:54

Covering Indexes

0:03:41

CODE: Covering Indexes

0:06:12

Reverse Key Indexes

0:09:13

Bitmap Join Indexes

0:09:13

CODE: Bitmap Join Indexes

0:06:54

Combining Bitmap Indexes

0:09:13

CODE: Combining Bitmap Indexes

0:06:12

Function-Based Indexes

0:06:54

CODE: Function-Based Indexes

0:07:30

Index-Organized Tables

0:06:12

CODE: Index-Organized Tables

0:09:13

Cluster Indexes

0:06:12

CODE: Cluster Indexes

0:03:41

Invisible Indexes

0:06:54

CODE: Invisible Indexes

0:06:12

Index Key Compression- Part 1

0:06:54

Index Key Compression- Part 2

0:07:30

CODE: Index Key Compression

0:07:30

Full-Text Searches

0:07:30

CODE: Full-Text Search Indexes

0:03:41

Section 12

Advanced SQL Tuning Techniques

Time 1h 39m

Lectures 14

See All

Tuning Star Queries

0:07:30

CODE: Tuning Star Queries

0:03:41

Using Bind Variables

0:07:30

CODE: Using Bind Variables

0:06:12

Beware of Bind Variable Peeking

0:09:13

CODE: Beware of Bind Variable Peeking

0:06:54

Cursor Sharing

0:07:30

CODE: Cursor Sharing

0:07:30

Adaptive Cursor Sharing

0:06:54

CODE: Adaptive Cursor Sharing

0:06:54

Adaptive Plans

0:09:13

CODE: Adaptive Plans

0:09:13

Dynamic Statistics (Dynamic Sampling)

0:03:41

CODE: Dynamic Statistics (Dynamic Sampling)

0:07:30

Section 13

Appendix: Software Installations

Time 1h 15m

Lectures 12

See All

About the Database Installation

0:09:13

Option 1: Having the Database with the Oracle VirtualBox Software

0:03:41

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

0:06:12

Option 2: What is Pluggable Database?

0:06:54

Option 2: Downloading and Installing the Oracle Database

0:09:13

Option 2: Unlocking the HR Schema

0:03:41

Option 2: Configuring and Using Oracle SQL Developer

0:03:41

Option 2: Installing Sample Schemas in Oracle Database

0:03:41

Extra: 12c Installation

0:09:13

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

0:03:41

Option 2: Oracle Database 12c Installation into Your Computer

0:06:54

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

0:09:13

Section 14

Bonus

Time 06m

Lectures 1

See All

About Tutor

Ansel Haley

5.00 (1 Reviews)

Courses 1

View Profile

Biography

My name is Ansel Haley and I've been working at the British Council Teaching Centre. I love teaching languages like English, Italian. My teaching career began as a schoolteacher, and I now have over 11 years of experience. Despite having a commerce degree, I chose to teach because I found classrooms to be a fascinating place where people of all ages and genders found themselves creating and discovering their identities.

Ratings & Reviews

0.00

0 Reviews

Channels

Channels

Oracle SQL Performance Tuning Masterclass (2023)

Become an Expert on Oracle SQL Tuning

This Course Includes:

Overview

What will students learn in your course?

What are the requirements or prerequisites for taking your course?

Who is the course for?

Description

Course Tags

Course Content

SQL & Perfomance Tuning Course Introduction

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

Oracle Database Architecture

SQL Tuning Basics

Execution Plans & Statistics

Table & Index Access Paths

Optimizer Hints

Join Operations

Other Optimizer Operators

SQL Tuning Techniques

Tuning with ADVANCED Indexing Techniques

Advanced SQL Tuning Techniques

Appendix: Software Installations

Bonus

About Tutor

Ansel Haley

Biography

Ratings & Reviews

Get In Touch

Follow Us

Support

Quick Links

Language & Currency

Channels

Oracle SQL Performance Tuning Masterclass (2023)

Become an Expert on Oracle SQL Tuning

This Course Includes:

Share This Course

Overview

What will students learn in your course?

What are the requirements or prerequisites for taking your course?

Who is the course for?

Description

Course Tags

Course Content

SQL & Perfomance Tuning Course Introduction

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

Oracle Database Architecture

SQL Tuning Basics

Execution Plans & Statistics

Table & Index Access Paths

Optimizer Hints

Join Operations

Other Optimizer Operators

SQL Tuning Techniques

Tuning with ADVANCED Indexing Techniques

Advanced SQL Tuning Techniques

Appendix: Software Installations

Bonus

About Tutor

Ansel Haley

Biography

Ratings & Reviews