Optimizing SQL Queries in Oracle

This course introduces SQL programmers and new Oracle database administrators to several methods to make SQL queries execute faster.
Course info
Level
Intermediate
Updated
Apr 15, 2014
Duration
3h 47m
Table of contents
Optimizing SQL Queries in Oracle
Basic SQL Optimization Part I
Basic SQL Optimization Part II
Overview of Indexes
B-Tree Indexes
Bitmap Indexes
Additional Index Types
Overview of Partitions
Simple Partitions
Composite Partitions
Partition/Index Interaction
Description
Course info
Level
Intermediate
Updated
Apr 15, 2014
Duration
3h 47m
Description

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.

About the author
About the author

Scott is a statistical computer programmer specializing in SAS and SQL. An admitted dilettante, Scott occupies his time learning various programming languages such as Java, Android, C#, C, PL/SQL, R, SPSS, to name a few. Scott becomes visibly upset if you don't line up your code syntax!

More from the author
SQL Data Wrangling in Oracle: Table Data
Intermediate
5h 18m
Nov 27, 2014
Introduction to Dates and Times in SQL Server
Intermediate
2h 58m
Jan 14, 2014
More courses by Scott Hecht