EDUCBA

Oracle SQL Performance Tuning

Taught in English

Course

Gain insight into a topic and learn the fundamentals

EDUCBA

Instructor: EDUCBA

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

Details to know

Shareable certificate

Add to your LinkedIn profile

Recently updated!

November 2023

Assessments

17 quizzes

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

Placeholder
Placeholder

Earn a career certificate

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

Share it on social media and in your performance review

Placeholder

There are 4 modules in this course

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

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

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

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

Instructor

EDUCBA
EDUCBA
34 Courses10,090 learners

Offered by

EDUCBA

Recommended if you're interested in Data Management

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%

KK
5

Reviewed on Feb 5, 2024

SR
5

Reviewed on Feb 5, 2024

NB
5

Reviewed on Feb 11, 2024

New to Data Management? Start here.

Placeholder

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

Advance your career with an online degree

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

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

Upskill your employees to excel in the digital economy

Frequently asked questions