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.
Author Name: Scott Hecht
Author Description:
Scott is a statistical computer programmer specializing in SAS and SQL, but has learned many other languages such as Java, Android, C#, C, PL/SQL, R, and SPSS to name a few. His personal website, sheepsqueezers.com, features documents and presentations on a variety of topics he has learned over the years. Scott is also the author of “Android from A to D,” which is his take on how a newbie should be taught Android programming, as well as “Poor Man’s Data Dictionary,” which describes how to quickl… more

Table of Contents

• 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