Home
EN - USD
Site language
Site currency
Oracle SQL Performance Tuning Masterclass (2023)
  • Home
  • Courses
  • Oracle SQL Performance Tuning Masterclass (2023)
Oracle SQL Performance Tuning Masterclass (2023)
0.00 (0)
Office Productivity / Oracle

Oracle SQL Performance Tuning Masterclass (2023)

Become an Expert on Oracle SQL Tuning

Ansel Haley
Ansel Haley
8 Students enrolled
Expert
English
This course includes:
  • 25h 39m
  • 234 Lectures
  • 350 Downloadable assets
  • Full lifetime access
  • Access on Mobile and TV
  • Certificate on completion
$527.00

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 39m Total length
SQL & Perfomance Tuning Course Introduction
11m
3 Lectures

SQL & Perfomance Tuning Course Introduction

SQL & Performance Tuning Course Overview
Preview 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
What is SQL Tuning and Why to Do That?
Preview 0:09:13
What to Know Before Starting the Course?
Preview 0:06:12
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)
Preview 0:09:13
Oracle Database Architecture Overview (Part 2)
0:06:54
Database Data Blocks in Detail
0:06:54
What is PGA?
Preview 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
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
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
Preview 0:03:41
Autotrace (Code Samples)
0:06:12
V$SQL_PLAN View
Preview 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
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
Preview 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
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
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
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
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!
Preview 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
Why Indexing is Important?
Preview 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
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
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
Bonus Lecture
0:09:13

About tutor

Ansel Haley
5.00 (1)

Ansel Haley

Courses 1

My name is Ansel Haley and I've been working at the Al-Iraqia University . I love teaching languages like English, Italian. My teaching career began as a school teacher, 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.

View profile
The website uses cookies to provide the best user experience while browsing safely. You can read more about cookies in the Privacy Policy. Cookies policy
Accept cookies Choose cookies