Optimizing SQL Queries in Oracle
Offered By: Pluralsight
Course Description
Overview
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.
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 SystemIndian 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