Query Optimization Techniques in SQL

person icon Veronika Golubeva, Nikita Vasilev, Arsen Petrenko

Query Optimization Techniques in SQL

This is an advanced course which embodies an aggregation of all the neccessery techniques to write optimized queries.

updated on icon Updated on Sep, 2023

language icon Language - English

person icon Veronika Golubeva, Nikita Vasilev, Arsen Petrenko

architecture icon Oracle SQL,SQL,PL/SQL,Development,Database Management


Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

Course Description

This course is designed for people who want to master SQL at the middle and senior levels. We will discuss the Oracle database as an example, but all the working and research methods can be applied to other relational databases.

In our course, we will talk about such an important aspect as query optimization and will deeper analyze the theoretical questions that may be useful not only for successful work, but also for the interviews. The focus will be on the technical implementation of the acquired knowledge, paying the most attention to the "under the hood" operation.

What you should already be able to do

- write basic SQL queries

⁃ use aggregate functions

⁃ use analytical functions

⁃ write your own functions (in PLSQL or, speaking of Oracle, using the with construction: a new feature introduced by Oracle, and according to the presentation, it should work 4 times faster than PLSQL variant).

In this course we will go through:

- query plan and how to read it

- join algorithms

- hints and statistics

- indexing

- caching

- partitioning

- use of temporary, intermediate tables and materialized views

Mastering the topics mentioned above will drastically improve an overall perfomance of your SQL queries and will allow you to properly time manage your applications with the most efficient use of available resources. 


What will you learn in this course:

  • To learn how to read and use the query plan in SQL.
  • To study different join algorithms and best conditions of it application.
  • To master the optimal usage of indexing depending on the task
  • To master superior features and functionality of SQL by using partitioning, hints, caching, e.t.c


What are the prerequisites for this course?

  • Basic SQL knowledge including the ability to write basic SQL queries, to use aggregate and analytical functions and to write your own functions.
Query Optimization Techniques in SQL


Check out the detailed breakdown of what’s inside the course

3 Lectures
  • play icon Introduction 00:55 00:55
  • play icon Query Plan 03:22 03:22
  • play icon How to read the query plan 04:46 04:46
Main part
7 Lectures

Instructor Details

user profile image

Veronika Golubeva

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best



Sambasiva Rao Gattu

very good explanation

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us