Oracle SQL Performance Tuning Masterclass (2023)

Ana Sayfa
Kurs
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 İnceleme(ler)

0 Kayıtlı öğrenci

Uzman

İngilizce

Ansel Haley

Oracle SQL Performance Tuning Masterclass (2023)

Bu kurs şunları içerir:

25h 39m
234 Konferans
350 İndirilebilir varlıklar
Tam ömür boyu erişim
Mobil ve TV'de Erişim
Tamamlama sertifikası

Tam fiyatına ₺527.00

Şimdi kaydolun

Favori

Genel Bakış

Öğrenciler kursunuzda ne öğrenecekler?

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!

Kursunuzu almak için gereklilikler veya önkoşullar nelerdir?

SQL Knowledge
Basic PL/SQL Knowledge

Kurs kimin için?

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

Açıklama

Kurs etiketleri

Kurs içeriği

14 Bölümler
234 Konferans
25h 39m Toplam uzunluk

Bölüm 1

SQL & Perfomance Tuning Course Introduction

Time 11m

Konferans 3

Tümünü gör

SQL & Performance Tuning Course Overview

Önizleme 0:03:41

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

0:03:41

Welcome Gift! + Course Document

0:03:41

Bölüm 2

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

Time 15m

Konferans 2

Tümünü gör

Bölüm 3

Oracle Database Architecture

Time 1h 51m

Konferans 15

Tümünü gör

Do You Have a Running Database in Your PC?

0:07:30

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

0:09:13

Oracle Database Architecture Overview (Part 1)

Önizleme 0:09:13

Oracle Database Architecture Overview (Part 2)

0:06:54

Database Data Blocks in Detail

0:06:54

What is PGA?

Önizleme 0:09:13

What is Shared Pool?

0:07:30

What is Buffer Cache?

0:07:30

What is Redo Log Buffer?

0:06:12

What is Undo?

0:06:12

How a DML is processed and committed

0:09:13

Automatic Memory Management

0:03:41

Oracle Database Storage Architecture

0:06:12

Logical and Physical Database Structure

0:06:54

Quiz - Database Architecture

0:09:13

Bölüm 4

SQL Tuning Basics

Time 1h 37m

Konferans 15

Tümünü gör

When to Tune?

0:07:30

What is a Bad SQL?

0:03:41

Effective Schema Design

0:07:30

Table Partitioning

0:09:13

How an SQL Statement is Processed?

0:03:41

Why do we need the Optimizer?

0:09:13

Optimizer Overview

0:06:12

Query Transformer

0:06:54

Selectivity & Cardinality

0:06:54

What is "cost" in detail?

0:07:30

Plan Generator

0:03:41

Row Source Generator

0:09:13

SQL Tuning Principles and Strategies

0:03:41

Query Analysis Strategy

0:03:41

SQL Tuning Basics Assessment Test

0:09:13

Bölüm 5

Execution Plans & Statistics

Time 1h 43m

Konferans 17

Tümünü gör

Execution Plan and Explain Plan in Details

0:09:13

Generating Statistics (Part 1)

0:06:12

Generating Statistics (Part 2)

0:03:41

Generating Statistics (Part 3)

0:06:54

Generating Statistics (Code Samples)

0:09:13

Generating Execution Plan

0:03:41

Generating Execution Plan (Code Samples)

0:03:41

Autotrace

Önizleme 0:03:41

Autotrace (Code Samples)

0:06:12

V$SQL_PLAN View

Önizleme 0:07:30

V$SQL_PLAN (Code Samples)

0:03:41

Reading the Execution Plans (Part 1)

0:06:12

Reading the Execution Plans (Part 2)

0:03:41

Reading the Execution Plans (Code Samples)

0:06:54

Analyzing the Execution Plans

0:06:12

Analyzing the Execution Plans (Code Samples)

0:07:30

Execution Plans & Statistics

0:09:13

Bölüm 6

Table & Index Access Paths

Time 1h 58m

Konferans 18

Tümünü gör

What are Indexes and How They work in details?

0:06:12

Types of Table and Index Access Paths

0:09:13

Table Access Full

0:03:41

Table Access Full (Code Samples)

0:03:41

Table Access by ROWID

0:07:30

Table Access by ROWID (Code Samples)

0:09:13

Index Unique Scan

0:09:13

Index Range Scan

0:06:54

Index Range Scan (Code Samples)

0:09:13

Index Full Scan

Önizleme 0:07:30

Index Full Scan (Code Samples)

0:07:30

Index Fast Full Scan

0:03:41

Index Fast Full Scan (Code Samples)

0:03:41

Index Skip Scan

0:03:41

Index Skip Scan (Code Samples)

0:06:54

Index Join Scan

0:07:30

Index Join Scan (Code Samples)

0:06:54

Table & Index Access Paths

0:06:12

Bölüm 7

Optimizer Hints

Time 31m

Konferans 5

Tümünü gör

What are Hints and Why to Use Them?

0:06:54

How to use Hints

0:03:41

How to use Hints (Code Samples)

0:06:12

List of Some Useful Hints

0:06:54

Using Hints

0:07:30

Bölüm 8

Join Operations

Time 2h 03m

Konferans 19

Tümünü gör

Join Methods Overview

0:09:13

Nested Loop Joins

0:09:13

Nested Loop Join (Code Samples)

0:06:54

Sort Merge Joins

0:03:41

Sort Merge Join (Code Samples)

0:06:54

Hash Joins

0:06:12

CODE: Hash Joins

0:06:12

Cartesian Joins

0:06:54

CODE: Cartesian Joins

0:07:30

Join Types Overview

0:06:12

Equijoins & Nonequijoins

0:07:30

CODE: Equijoins & Nonequijoins

0:03:41

Outer Joins

0:06:54

CODE: Outer Joins

0:09:13

Semijoins

0:03:41

CODE: Semijoins

0:03:41

Antijoins

0:03:41

CODE: Antijoins

0:06:54

Join Operations

0:09:13

Bölüm 9

Other Optimizer Operators

Time 2h 40m

Konferans 25

Tümünü gör

Result Cache Operator

0:09:13

CODE: Result Cache Operator

0:06:54

View Operator

0:06:12

CODE: View Operator

0:03:41

Clusters

0:07:30

CODE: Clusters

0:06:12

Sort Operators

0:03:41

CODE: Sort Operators

0:07:30

INLIST Operator

0:06:54

CODE: INLIST Operator

0:07:30

Count Stopkey Operator

0:06:54

CODE: Count Stopkey Operator

0:06:12

First Row Operator

0:03:41

CODE: First Row Operator

0:03:41

Filter Operator

0:09:13

CODE: Filter Operator

0:07:30

Concatenation Operator

0:07:30

CODE: Concatenation Operator

0:06:12

UNION Operators

0:07:30

CODE: Union Operators

0:07:30

Intersect Operator

0:07:30

CODE: Intersect Operator

0:03:41

Minus Operator

0:07:30

CODE: Minus Operator

0:06:54

Other Optimizer Operators

0:03:41

Bölüm 10

SQL Tuning Techniques

Time 6h 19m

Konferans 59

Tümünü gör

How to find a performance problem and its tuning solution?

0:07:30

Ways of Getting the Execution Plan and the Statistics

0:09:13

Using the Real-Time SQL Monitoring Tool Part 1

0:09:13

Using the Real-Time SQL Monitoring Tool Part 2

0:03:41

Using the Real-Time SQL Monitoring Tool Part 3

0:09:13

CODE: Using the Real-Time SQL Monitoring Tool

0:03:41

Using the Trace Files & TKPROF Utility - Part 1

0:03:41

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:09:13

Get What You Need Only

0:06:12

CODE: Get What You Need Only

0:03:41

Index Usage

0:03:41

CODE: Index Usage

0:07:30

Using Concatenation Operator

0:09:13

CODE: Using Concatenation Operator

0:06:54

Using Arithmetic Operators

0:03:41

CODE: Using Arithmetic Operators

0:03:41

Using Like Conditions

0:06:54

CODE: Using Like Conditions

0:06:12

Using Functions on the Indexed Columns

0:06:54

CODE: Using Functions on the Indexed Columns

0:06:54

Handling NULL-Based Performance Problems

0:06:12

CODE: Handling NULL-Based Performance Problems

0:09:13

Using EXISTS instead of IN Clause

0:06:12

Using TRUNCATE instead of DELETE command

0:03:41

CODE: Using TRUNCATE instead of DELETE command

0:03:41

Data Type Mismatch

0:06:54

CODE: Data Type Mismatch

0:07:30

Tuning Ordered Queries

0:03:41

CODE: Tuning Ordered Queries

0:06:12

Retrieving the MIN & MAX Values

0:09:13

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:07:30

Avoid Using the HAVING Clause!

0:09:13

CODE: Avoid Using the HAVING Clause!

0:09:13

Be Careful on Views!

Önizleme 0:03:41

CODE: Be Careful on Views!

0:06:54

Create Materialized Views

0:06:12

CODE: Create Materialized Views

0:03:41

Avoid Commit Too Much or Too Less!

0:07:30

Partition Pruning

0:07:30

CODE: Partition Pruning

0:06:54

Using BULK COLLECT

0:06:12

CODE: Using BULK COLLECT

0:07:30

Tuning the Join Order

0:09:13

CODE: Tuning the Join Order

0:06:12

Multitable DML Operations

0:06:54

CODE: Multitable DML Operations

0:07:30

Using Temporary Tables

0:06:12

CODE: Using Temporary Tables

0:06:12

Combining SQL Statements

0:06:12

CODE: Combining SQL Statements

0:03:41

Using "WITH" Clause

0:06:54

CODE: Using WITH Clause

0:07:30

Using Analytical Functions

0:07:30

CODE: Using Analytical Functions

0:09:13

SQL Tuning Techniques

0:03:41

Bölüm 11

Tuning with ADVANCED Indexing Techniques

Time 3h 15m

Konferans 29

Tümünü gör

Why Indexing is Important?

Önizleme 0:07:30

Index Selectivity & Cardinality

0:06:54

B-Tree Indexes in Details

0:07:30

CODE: B-Tree Indexes in Details

0:06:12

Bitmap Indexes in Details

0:03:41

CODE: Bitmap Indexes in Details

0:09:13

Bitmap Operations

0:07:30

Composite Indexes and Order of Indexed Columns

0:06:54

CODE: Composite Indexes and Order of Indexed Columns

0:03:41

Covering Indexes

0:06:54

CODE: Covering Indexes

0:07:30

Reverse Key Indexes

0:03:41

Bitmap Join Indexes

0:03:41

CODE: Bitmap Join Indexes

0:09:13

Combining Bitmap Indexes

0:07:30

CODE: Combining Bitmap Indexes

0:07:30

Function-Based Indexes

0:07:30

CODE: Function-Based Indexes

0:07:30

Index-Organized Tables

0:06:12

CODE: Index-Organized Tables

0:09:13

Cluster Indexes

0:03:41

CODE: Cluster Indexes

0:09:13

Invisible Indexes

0:06:12

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:09:13

Full-Text Searches

0:03:41

CODE: Full-Text Search Indexes

0:07:30

Bölüm 12

Advanced SQL Tuning Techniques

Time 1h 37m

Konferans 14

Tümünü gör

Tuning Star Queries

0:07:30

CODE: Tuning Star Queries

0:03:41

Using Bind Variables

0:06:54

CODE: Using Bind Variables

0:07:30

Beware of Bind Variable Peeking

0:09:13

CODE: Beware of Bind Variable Peeking

0:06:12

Cursor Sharing

0:06:12

CODE: Cursor Sharing

0:06:54

Adaptive Cursor Sharing

0:07:30

CODE: Adaptive Cursor Sharing

0:06:54

Adaptive Plans

0:06:54

CODE: Adaptive Plans

0:06:12

Dynamic Statistics (Dynamic Sampling)

0:09:13

CODE: Dynamic Statistics (Dynamic Sampling)

0:06:12

Bölüm 13

Appendix: Software Installations

Time 1h 25m

Konferans 12

Tümünü gör

About the Database Installation

0:06:12

Option 1: Having the Database with the Oracle VirtualBox Software

0:06:12

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

0:09:13

Option 2: What is Pluggable Database?

0:07:30

Option 2: Downloading and Installing the Oracle Database

0:06:54

Option 2: Unlocking the HR Schema

0:09:13

Option 2: Configuring and Using Oracle SQL Developer

0:03:41

Option 2: Installing Sample Schemas in Oracle Database

0:06:12

Extra: 12c Installation

0:06:54

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

0:09:13

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:07:30

Bölüm 14

Bonus

Time 09m

Konferans 1

Tümünü gör

Öğretmen hakkında

Ansel Haley

5.00 (1 Yorum)

Kurs 1

Profili görüntüle

Derecelendirmeler ve incelemeler

0.00

0 Yorum

Oracle SQL Performance Tuning Masterclass (2023)

Become an Expert on Oracle SQL Tuning

Bu kurs şunları içerir:

Genel Bakış

Öğrenciler kursunuzda ne öğrenecekler?

Kursunuzu almak için gereklilikler veya önkoşullar nelerdir?

Kurs kimin için?

Açıklama

Kurs etiketleri

Kurs içeriği

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

Öğretmen hakkında

Ansel Haley

Derecelendirmeler ve incelemeler

İletişime geçin

Bizi takip edin

Support

Quick Links

Dil ve para birimi

Oracle SQL Performance Tuning Masterclass (2023)

Become an Expert on Oracle SQL Tuning

Bu kurs şunları içerir:

Bu kursu paylaş

Genel Bakış

Öğrenciler kursunuzda ne öğrenecekler?

Kursunuzu almak için gereklilikler veya önkoşullar nelerdir?

Kurs kimin için?

Açıklama

Kurs etiketleri

Kurs içeriği

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

Öğretmen hakkında

Ansel Haley

Derecelendirmeler ve incelemeler