Databases: OLAP and Recursion

This course is one of five self-paced courses on the topic of Databases, originating as one of Stanford's three inaugural massive open online courses released in the fall of 2011. The original "Databases" courses are now all available on edx.org.
This course builds on concepts introduced in Databases: Relational Databases and SQL and is recommended for learners seeking to understand On-Line Analytical Processing (OLAP) and/or recursion in the SQL language.

The On-Line Analytical Processing section of this course introduces star schemas, the data cube concept, and OLAP features in relational databases including the Cube and Rollup operators.
The Recursion section of this course covers the SQL standard for queries over recursively-defined relations.