If you have a KINDLE EDITION subscription, you can read the following books, SQL Tuning and SQL Beginner's, for free:

1) Oracle SQL Performance Tuning and Optimization: It’s all about the cardinalities
https://amzn.to/3GUDhld

2) Oracle SQL and PL/SQL Performance Tuning: Query tuning and optimization
https://amzn.to/3VrcxwM

3) SQL: 3 Books in 1: Learn SQL Basics for Beginners Create Complex SQL Queries Advanced SQL Query Optimization Techniques
https://amzn.to/3gBc9go
——————————————————————————-
Below you will find some helpful reference works on the topic of SQL tuning.

1) SQL TUNING (INCLUDES ORACLE, DB2 AND SQL SERVER)
https://amzn.to/3F9SBsB

——————————————————————————-

Materials for this video can be found below:
https://drive.google.com/drive/folders/1ZaWrau0jiKNCOoF2FbCGIsbg8AlQvz9v

——————————————————————————–

To learn SQL tuning from scratch, take the Oracle SQL Performance Tuning – From Scratch To Tuner course on Udemy. Check out the link below for the course details.

Use the link below to get this course at a special price of 499 INR.
https://www.udemy.com/course/sql-tuning-beginner/?couponCodeDEC2022

Do share your valuable feedback with us. And if you have any doubts regarding the course, please share them in the comments section. We will take care of it.

Facebook page: https://www.facebook.com/Virsess/
LinkedIn page: https://www.linkedin.com/company/virsess/

Udemy course module:

introduction
Types of indices
RBO vs CBO
Implementation plan
Access methods
Join methods
Cardinality
Histograms
Basic approach to query optimization
Hints
Baselines
Useful scripts
Case studies
——————————————————————————-

Please take the opportunity to connect with your friends and family and share this video with them if you find it useful.