YoVDO

Optimizing SQL Queries in Oracle

Offered By: Pluralsight

Tags

Oracle Courses Data Normalization Courses Oracle Database Administration Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
This course introduces SQL programmers and new Oracle database administrators to several methods to make SQL queries execute faster.

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

Related Courses

Data Base Management System
Indian Institute of Technology, Kharagpur via Swayam
Healthcare Data Models
University of California, Davis via Coursera
Image Data Augmentation with Keras
Coursera Project Network via Coursera
Compare time series predictions of COVID-19 deaths
Coursera Project Network via Coursera
Practicing Machine Learning Interview Questions in R
DataCamp