VOOZH about

URL: https://www.coursera.org/learn/oracle-sql-performance

⇱ Oracle SQL Performance Tuning | Coursera

Oracle SQL Performance Tuning

Ends soon! Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.

Oracle SQL Performance Tuning

Instructor: EDUCBA

2,755 already enrolled

Included with

Ask Coursera

Gain insight into a topic and learn the fundamentals.
4.8

91 reviews

Intermediate level

Recommended experience

8 hours to complete
Flexible schedule
Learn at your own pace
Gain insight into a topic and learn the fundamentals.
4.8

91 reviews

Intermediate level

Recommended experience

8 hours to complete
Flexible schedule
Learn at your own pace

What you'll learn

  • Compose and optimize indexes for query performance

    Evaluate the utilization of indexes within your queries

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

17 assignments

Taught in English

There are 4 modules in this course

This course is designed to provide you with skills needed to improve query performance in Oracle databases.

In real-world scenarios, slow report generation and query execution often result from the sheer volume of data. To address this issue, this course covers topics such as Query Compilation and Execution, Indexing, Materialized Views, Common Table Expressions etc. Emphasis is on practical learning with step-by-step demonstrations. Upon completion, you will master SQL-level performance tuning and eliminating query bottlenecks. Our unique approach showcases query execution before and after applying tuning techniques, ensuring a comprehensive grasp of optimization methods. Course Pre-Requisite: You will need to be familiar with Relational Database Management System (RDBMS) concepts and have proficiency in SQL techniques, including joins, subqueries, set operators, GROUP BY and SQL functions. Target Learner: This course is designed for Database Administrators (DBAs), SQL Developers, Application Developers, Data Analysts seeking to enhance their Oracle SQL Performance Tuning skills. What Will You Learn: By the end of this course, you will be able to: • Compose and optimize indexes for enhanced query performance • Evaluate the utilization of indexes within your queries • Understand the factors influencing Query Compilation • Determine and apply appropriate data types for database columns

In this module, you will identify the demography of the tables. Different data types will be explored. Also, select statement execution will be elaborated.

What's included

18 videos3 readings4 assignments1 discussion prompt

18 videos•Total 91 minutes
  • Introduction of the Author - Mandar Mulay•2 minutes
  • Introduction to Oracle SQL Performance Tuning - Part 1•6 minutes
  • Introduction to Oracle SQL Performance Tuning - Part 2•6 minutes
  • Introduction to Understanding Necessity of SQL Tuning•1 minute
  • Understanding Demography of Tables 1•5 minutes
  • Understanding Demography of Tables 2•5 minutes
  • Char Vs Varchar - Part 1•7 minutes
  • Char Vs Varchar - Part 2•5 minutes
  • All 6 clauses of Select Statement - Part 1•6 minutes
  • All 6 clauses of Select Statement - Part 2•7 minutes
  • All 6 clauses of Select Statement - Part 3•4 minutes
  • The Flow of Clauses Execution•7 minutes
  • Performance Impact of Where vs Having Clause - Part 1•7 minutes
  • Performance Impact of Where vs Having Clause - Part 2•7 minutes
  • Performance impact of Distinct, Group By and Count - Part 1•4 minutes
  • Performance impact of Distinct, Group By and Count - Part 2•4 minutes
  • Benefits of Exists Operator 1•5 minutes
  • Benefits of Exists Operator 2•3 minutes
3 readings•Total 13 minutes
  • Course Introduction - Oracle SQL Performance Tuning Overview•3 minutes
  • Course Syllabus - Oracle SQL Performance Tuning Overview•5 minutes
  • Data Types in Oracle•5 minutes
4 assignments•Total 34 minutes
  • Graded Quiz: Understanding Necessity of SQL Tuning•25 minutes
  • Practice Quiz: Understanding Demography of Tables•3 minutes
  • Practice Quiz: Data Types And Char Vs Varchar Datatypes from Performance Angle•3 minutes
  • Practice Quiz: Understanding Necessity of SQL Tuning•3 minutes
1 discussion prompt•Total 5 minutes
  • Understanding Necessity of SQL Tuning•5 minutes

In this module, you will understand the different techniques offered by Oracle to know how any select statement gets executed internally. This module also describes the compilation process of any select statement.

What's included

10 videos1 reading3 assignments1 discussion prompt

10 videos•Total 49 minutes
  • Introduction to Query Optimization Techniques•1 minute
  • Compilation and Execution Part 1•3 minutes
  • Compilation and Execution Part 2•7 minutes
  • Compilation and Execution Part 3•5 minutes
  • Bind Variables 1•4 minutes
  • Bind Variables 2•5 minutes
  • Explain Plan part 1•6 minutes
  • Explain Plan part 2•8 minutes
  • AutoTrace Part 1•5 minutes
  • AutoTrace Part 2•5 minutes
1 reading•Total 3 minutes
  • Explain Plan - Compilation•3 minutes
3 assignments•Total 26 minutes
  • Graded Quiz: Tracing Query Execution Techniques•20 minutes
  • Practice Quiz: Query Compilation & Execution•3 minutes
  • Practice Quiz: Tracing Query Execution Techniques•3 minutes
1 discussion prompt•Total 5 minutes
  • Tracing Query Execution Techniques•5 minutes

In this module, you will interpret how indexes contribute to enhancing the performance of a query, and the hazards of a full table scan are covered.

What's included

12 videos1 reading4 assignments1 discussion prompt

12 videos•Total 56 minutes
  • Introduction to Indexing Strategies•2 minutes
  • Introducing Indexes 1•3 minutes
  • Introducing Indexes 2•7 minutes
  • Introducing Indexes 3•5 minutes
  • Bitmap Index Part 1•4 minutes
  • Bitmap Index Part 2•5 minutes
  • B-Tree Index Part 1•7 minutes
  • B-Tree Index Part 2•5 minutes
  • Composite Index 1•4 minutes
  • Composite Index 2•5 minutes
  • Function-Based Index part 1•5 minutes
  • Function-Based Index part 2•4 minutes
1 reading•Total 3 minutes
  • Bitmap Index•3 minutes
4 assignments•Total 29 minutes
  • Graded Quiz: Query Optimization - Indexes•20 minutes
  • Practice Quiz: Introducing Indexes •3 minutes
  • Practice Quiz: Bitmap Index•3 minutes
  • Practice Quiz: Query Optimization - Indexes•3 minutes
1 discussion prompt•Total 5 minutes
  • Query Optimization - Indexes•5 minutes

In this module, you will understand how hints can be useful to uplift the query execution process. A querying technique known as Inline view is covered. An Oracle object temporary table’s usage for solving real-life problems is depicted.

What's included

15 videos2 readings6 assignments2 discussion prompts

15 videos•Total 83 minutes
  • Introduction to Performance Tuning Tools and Techniques•0 minutes
  • Understanding Hints Part 1•5 minutes
  • Understanding Hints Part 2•7 minutes
  • Understanding Hints Part 3•4 minutes
  • Inline Views Part 1•5 minutes
  • Inline Views Part 2•4 minutes
  • Temporary Tables 1•8 minutes
  • Temporary Tables 2•7 minutes
  • Common Table Expression Part 1•6 minutes
  • Common Table Expression Part 2•7 minutes
  • Materialized Views - Part 1•7 minutes
  • Materialized Views - Part 2•7 minutes
  • Materialized Views - Part 3•4 minutes
  • Materialized Views - Part 4•6 minutes
  • Conclusion to Oracle SQL Performance Tuning•6 minutes
2 readings•Total 6 minutes
  • Understanding Hints•3 minutes
  • Common Table Expression•3 minutes
6 assignments•Total 42 minutes
  • Graded Quiz: Performance Tuning Tools and Techniques•25 minutes
  • Practice Quiz: Understanding Hints•3 minutes
  • Practice Quiz: Inline Views•3 minutes
  • Practice Quiz: Temporary Tables•4 minutes
  • Practice Quiz: Common Table Expression•4 minutes
  • Practice Quiz: Materialized Views•3 minutes
2 discussion prompts•Total 10 minutes
  • Query Optimization - Hints, Inline Views & Temporary Tables•5 minutes
  • Query Optimization - Common Table Expressions & Materialized Views•5 minutes

Instructor

Instructor ratings
4.2 (16 ratings)
EDUCBA
1,657 Courses•337,648 learners

Explore more from Data Management

Why people choose Coursera for their career

👁 Image

Felipe M.

Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
👁 Image

Jennifer J.

Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
👁 Image

Larry W.

Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
👁 Image

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

  • 5 stars

    82.41%

  • 4 stars

    13.18%

  • 3 stars

    3.29%

  • 2 stars

    1.09%

  • 1 star

    0%

Showing 3 of 91

SG
·

Reviewed on Jun 20, 2025

I was impressed by how comprehensive yet digestible this course is. Every concept is backed by a real-world example, making it incredibly useful.

RG
·

Reviewed on Jul 13, 2025

This course helped me understand how small changes can have a big impact on query performance. The coverage of SQL internals was especially enlightening.

S
·

Reviewed on Mar 24, 2025

I've been working with Oracle databases for years, but this course took my skills to the next level. The step-by-step demonstrations really helped me understand how to optimize queries effectively

Frequently asked questions

Oracle 19c Enterprise Edition is recommended.

SQL Plus will be used as the SQL Editor. It is the default command prompt-based editor available once Oracle 19c Enterprise Edition is installed.

Yes, a DBA login is required as this course covers performance-tuning techniques.

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

Financial aid available,