Oracle SQL Performance Tuning

Taught in English

Course

Gain insight into a topic and learn the fundamentals

Instructor: EDUCBA

Included with Coursera Plus

4.8

(21 reviews)

Intermediate level

Recommended experience

7 hours to complete

3 weeks at 2 hours a week

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

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

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

19 videos3 readings4 quizzes1 discussion prompt

19 videosTotal 96 minutes

Introduction of the Author - Mandar Mulay2 minutesPreview module
Introduction to Oracle SQL Performance Tuning - Part 16 minutes
Introduction to Oracle SQL Performance Tuning - Part 25 minutes
Introduction to Understanding Necessity of SQL Tuning0 minutes
Understanding Demography of Tables 1 - Part 15 minutes
Understanding Demography of Tables 1 - Part 25 minutes
Understanding Demography of Tables 25 minutes
Char Vs Varchar - Part 16 minutes
Char Vs Varchar - Part 25 minutes
All 6 clauses of Select Statement - Part 16 minutes
All 6 clauses of Select Statement - Part 26 minutes
All 6 clauses of Select Statement - Part 34 minutes
The Flow of Clauses Execution6 minutes
Performance Impact of Where vs Having Clause - Part 17 minutes
Performance Impact of Where vs Having Clause - Part 26 minutes
Performance impact of Distinct, Group By and Count - Part 13 minutes
Performance impact of Distinct, Group By and Count - Part 23 minutes
Benefits of Exists Operator 15 minutes
Benefits of Exists Operator 22 minutes

3 readingsTotal 13 minutes

Course Introduction - Oracle SQL Performance Tuning Overview3 minutes
Course Syllabus - Oracle SQL Performance Tuning Overview5 minutes
Data Types in Oracle5 minutes

4 quizzesTotal 34 minutes

Graded Quiz: Understanding Necessity of SQL Tuning25 minutes
Practice Quiz: Understanding Demography of Tables3 minutes
Practice Quiz: Data Types And Char Vs Varchar Datatypes from Performance Angle3 minutes
Practice Quiz: Understanding Necessity of SQL Tuning3 minutes

1 discussion promptTotal 5 minutes

Understanding Necessity of SQL Tuning5 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 quizzes1 discussion prompt

10 videosTotal 48 minutes

Introduction to Query Optimization Techniques1 minutePreview module
Compilation and Execution Part 13 minutes
Compilation and Execution Part 26 minutes
Compilation and Execution Part 34 minutes
Bind Variables 14 minutes
Bind Variables 25 minutes
Explain Plan part 15 minutes
Explain Plan part 27 minutes
AutoTrace Part 15 minutes
AutoTrace Part 24 minutes

1 readingTotal 3 minutes

Explain Plan - Compilation3 minutes

3 quizzesTotal 26 minutes

Graded Quiz: Tracing Query Execution Techniques20 minutes
Practice Quiz: Query Compilation & Execution3 minutes
Practice Quiz: Tracing Query Execution Techniques3 minutes

1 discussion promptTotal 5 minutes

Tracing Query Execution Techniques5 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 quizzes1 discussion prompt

12 videosTotal 55 minutes

Introduction to Indexing Strategies1 minutePreview module
Introducing Indexes 12 minutes
Introducing Indexes 26 minutes
Introducing Indexes 35 minutes
Bitmap Index Part 14 minutes
Bitmap Index Part 25 minutes
B-Tree Index Part 17 minutes
B-Tree Index Part 24 minutes
Composite Index 13 minutes
Composite Index 25 minutes
Function-Based Index part 15 minutes
Function-Based Index part 23 minutes

1 readingTotal 3 minutes

Bitmap Index3 minutes

4 quizzesTotal 29 minutes

Graded Quiz: Query Optimization - Indexes20 minutes
Practice Quiz: Introducing Indexes 3 minutes
Practice Quiz: Bitmap Index3 minutes
Practice Quiz: Query Optimization - Indexes3 minutes

1 discussion promptTotal 5 minutes

Query Optimization - Indexes5 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 quizzes2 discussion prompts

15 videosTotal 82 minutes

Introduction to Performance Tuning Tools and Techniques0 minutesPreview module
Understanding Hints Part 14 minutes
Understanding Hints Part 26 minutes
Understanding Hints Part 33 minutes
Inline Views Part 15 minutes
Inline Views Part 23 minutes
Temporary Tables 18 minutes
Temporary Tables 26 minutes
Common Table Expression Part 15 minutes
Common Table Expression Part 26 minutes
Materialized Views - Part 17 minutes
Materialized Views - Part 26 minutes
Materialized Views - Part 33 minutes
Materialized Views - Part 46 minutes
Conclusion to Oracle SQL Performance Tuning5 minutes

2 readingsTotal 6 minutes

Understanding Hints3 minutes
Common Table Expression3 minutes

6 quizzesTotal 42 minutes

Graded Quiz: Performance Tuning Tools and Techniques25 minutes
Practice Quiz: Understanding Hints3 minutes
Practice Quiz: Inline Views3 minutes
Practice Quiz: Temporary Tables4 minutes
Practice Quiz: Common Table Expression4 minutes
Practice Quiz: Materialized Views3 minutes

2 discussion promptsTotal 10 minutes

Query Optimization - Hints, Inline Views & Temporary Tables5 minutes
Query Optimization - Common Table Expressions & Materialized Views5 minutes

Instructor

EDUCBA

34 Courses10,809 learners

Offered by

EDUCBA

Recommended if you're interested in Data Management

EDUCBA
Persistent Memory Technology - Introduction and Deployment
Course
EDUCBA
Foundation to Multi-Cloud
Course
EDUCBA
AWS Database Specialty Certification
Course
EDUCBA
Empowering with web3.js: Web3 Applications
Course

Why people choose Coursera for their career

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."

Jennifer J.

Learner since 2020

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

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."

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

Showing 3 of 21

4.8

21 reviews

5 stars
85.71%
4 stars
9.52%
3 stars
4.76%
2 stars
0%
1 star
0%

Reviewed on Feb 5, 2024

Reviewed on Mar 23, 2024

Reviewed on Feb 4, 2024

View more reviews

New to Data Management? Start here.

Open new doors with Coursera Plus

Unlimited access to 7,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

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.

Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:

The course may not offer an audit option. 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. If you only want to read and view the course content, you can audit the course for free.

Oracle SQL Performance Tuning

Course

What you'll learn

Skills you'll gain

Details to know

See how employees at top companies are mastering in-demand skills

Earn a career certificate

There are 4 modules in this course

Understanding Necessity of SQL Tuning

What's included

Query Optimization Techniques

What's included

Indexing Strategies

What's included

Performance Tuning Tools and Techniques

What's included

Instructor

Offered by

Recommended if you're interested in Data Management

Persistent Memory Technology - Introduction and Deployment

Foundation to Multi-Cloud

AWS Database Specialty Certification

Empowering with web3.js: Web3 Applications

Why people choose Coursera for their career

Learner reviews

New to Data Management? Start here.

Open new doors with Coursera Plus

Advance your career with an online degree

Join over 3,400 global companies that choose Coursera for Business

Frequently asked questions

Which version of Oracle Database should be installed?

Which SQL Editor should be used?

Is a DBA login required?

More questions