Optimizing SQL Queries in Oracle

MP4 | AVC 236kbps | English | 1024x768 | 15fps | 3h 46mins | AAC stereo 101kbps | 421 MB

Genre: Video Training

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.

Optimizing SQL Queries in Oracle22m 15s

Basic SQL Optimization Part I28m 25s

Basic SQL Optimization Part II22m 41s

Overview of Indexes25m 3s

B-Tree Indexes30m 18s

Bitmap Indexes11m 58s

Additional Index Types19m 15s

Overview of Partitions16m 3s

Simple Partitions23m 57s

Composite Partitions15m 43s

Partition/Index Interaction10m 58s