Coursera Plus Annual is 40% Off — Ends July 13.

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Optimizing SQL Queries in Oracle

via Pluralsight

Write review
DataCamp Ad

Power BI Fundamentals - Create visualizations and dashboards from scratch

Learn More → Boot.dev Ad

The Fastest Way to Become a Backend Developer Online

Learn More →

Overview

Build a Learning Habit
Download Class Central's free printable study calendar
Download for Free


This course introduces SQL programmers and new Oracle database administrators to several methods to make SQL queries execute faster, such as transforming your data to normal form, using more efficient SQL code, and using indexes, as well as how to work with partitions.

Syllabus

  • Optimizing SQL Queries in Oracle 22mins
  • Basic SQL Optimization Part I 28mins
  • Basic SQL Optimization Part II 22mins
  • Overview of Indexes 25mins
  • B-Tree Indexes 30mins
  • Bitmap Indexes 11mins
  • Additional Index Types 19mins
  • Overview of Partitions 16mins
  • Simple Partitions 23mins
  • Composite Partitions 15mins
  • Partition/Index Interaction 10mins

Taught by

Scott Hecht

Reviews

4.4 rating at Pluralsight based on 258 ratings

Start your review of Optimizing SQL Queries in Oracle

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.