SQL & Performance Tuning Course Overview

UDEMY 101: How to Use Udemy? + Some Useful Tips

What is SQL Tuning and Why to Do That?

What to Know Before Starting the Course?

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

Oracle Database Architecture Overview

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

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

Execution Plan and Explain Plan in Details

Generating Statistics

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

Reading the Execution Plans (Code Samples)

Analyzing the Execution Plans

Analyzing the Execution Plans (Code Samples)

Execution Plans & Statistics

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

What are Hints and Why to Use Them?

How to Use Hints

How to Use Hints (Code Samples)

List of Some Useful Hints

Join Methods Overview

Nested Loop Joins

Nested Loop Join (Code Samples)

Sort Merge Joins

Sort Merge Join (Code Samples)

Hash Joins

Hash Joins (Code Samples)

Cartesian Joins

Cartesian Joins (Code Samples)

Join Types Overview

Equijoins & Nonequijoins

Equijoins & Nonequijoins (Code Samples)

Outer Joins

Outer Joins (Code Samples)

Semijoins

Semijoins (Code Samples)

Antijoins

Result Cache Operator

Result Cache Operator (Code Samples)

View Operator

View Operator (Code Samples)

Clusters

Clusters (Code Samples)

Sort Operators

Sort Operators (Code Samples)

INLIST Operator

INLIST Operator (Code Samples)

Count Stopkey Operator

Count Stopkey Operator (Code Samples)

First Row Operator

First Row Operator (Code Samples)

Filter Operator

Filter Operator (Code Samples)

Concatenation Operator

Concatenation Operator (Code Samples)

UNION Operators

UNION Operators (Code Samples)

Intersect Operator

Intersect Operator (Code Samples)

Minus Operator

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

Using the Real-Time SQL Monitoring Tool (Code Samples)

Using the Trace Files & TKPROF Utility - Part 1

Using the Trace Files & TKPROF Utility - Part 2

Using the Trace Files & TKPROF Utility - Part 3

Using the Trace Files & TKPROF Utility (Code Samples)

Get What You Need Only

Get What You Need Only (Code Samples)

Index Usage

Index Usage (Code Samples)

Using Concatenation Operator

Using Concatenation Operator (Code Samples)

Using Arithmetic Operators

Using Arithmetic Operators (Code Samples)

Using Like Conditions

Using Like Conditions (Code Samples)

Using Functions on the Indexed Columns

Using Functions on the Indexed Columns (Code Samples)

Handling NULL-Based Performance Problems

Handling NULL-Based Performance Problems (Code Samples)

Using EXISTS instead of IN Clause

Using TRUNCATE instead of DELETE command

Using TRUNCATE instead of DELETE command (Code Samples)

Data Type Mismatch

Data Type Mismatch (Code Samples)

Tuning Ordered Queries

Tuning Ordered Queries (Code Samples)

Retrieving the MIN & MAX Values

Retrieving the MIN & MAX Values (Code Samples)

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

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

Avoid Using the HAVING Clause!

Avoid Using the HAVING Clause! (Code Samples)

Be Careful on Views!

Be Careful on Views! (Code Samples)

Create Materialized Views

Create Materialized Views (Code Samples)

Avoid Commit Too Much or Too Less!

Partition Pruning

Partition Pruning (Code Samples)

Using BULK COLLECT

Using BULK COLLECT (Code Samples)

Tuning the Join Order

Tuning the Join Order (Code Samples)

Multitable DML Operations

Multitable DML Operations (Code Samples)

Using Temporary Tables

Using Temporary Tables (Code Samples)

Combining SQL Statements

Combining SQL Statements (Code Samples)

Using "WITH" Clause

Using "WITH" Clause (Code Samples)

Using Analytical Functions

Why Indexing is Important?

Index Selectivity & Cardinality

B-Tree Indexes in Details

B-Tree Indexes in Details (Code Samples)

Bitmap Indexes in Details

Bitmap Indexes in Details (Code Samples)

Bitmap Operations

Composite Indexes and Order of Indexed Columns

Composite Indexes and Order of Indexed Columns (Code Samples)

Covering Indexes

Covering Indexes (Code Samples)

Reverse Key Indexes

Bitmap Join Indexes

Bitmap Join Indexes (Code Samples)

Combining Bitmap Indexes

Combining Bitmap Indexes (Code Samples)

Function-Based Indexes

Function-Based Indexes (Code Samples)

Index-Organized Tables

Index-Organized Tables (Code Samples)

Cluster Indexes

Cluster Indexes (Code Samples)

Invisible Indexes

Invisible Indexes (Code Samples)

Index Key Compression- Part 1

Index Key Compression- Part 2

Index Key Compression (Code Samples)

Full-Text Searches

Tuning Star Queries

Using Bind Variables

Beware of Bind Variable Peeking

Cursor Sharing

Adaptive Cursor Sharing

Adaptive Plans

Dynamic Statistics

Database Performance Tuning Program

Check Your Course Fee

KEY POINTS

90+

18+

1500+

5+

ZebLearn Certification Partners – Globally Recognized Credentials!

Course content

Why Should You Learn Database Performance Tuning Training?

Request more information

What you will get at Zeblearnindia Learning?

() 60 Minutes WEBINAR with CERTIFICATE

Explore Our Courses Across India - Flexible batches

DSP & Microcontrollers

Computer Hardware

Cisco

Cisco & Networking Certifications

Database Performance Tuning Program

Check Your Course Fee

KEY POINTS

90+

18+

1500+

5+

ZebLearn Certification Partners – Globally Recognized Credentials!

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

Why Should You Learn Database Performance Tuning Training?

Request more information

What you will get at Zeblearnindia Learning?

() 60 Minutes WEBINAR with CERTIFICATE

Explore Our Courses Across India - Flexible batches