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