This Oracle advanced SQL course provides an overview of the recent additions to the SQL language that have been added over the last few years, but that may have slipped under your radar.

We will describe;
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

• Analytic Functions – Part 1
  25mins
• Analytic Functions – Part 2
  25mins
• Analytic Functions – Part 3
  27mins
• Analytic Functions – Part 4
  30mins
• Extensions to GROUP BY
  36mins
• The WITH Clause – Part 1
  11mins
• The WITH Clause – Part 2
  45mins
• The PIVOT and UNPIVOT Features
  29mins
• The MERGE Statement
  17mins
• PARTITION BY/RIGHT OUTER JOIN
  16mins