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.

There is one session available:
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.

There is one session available:
Databases: OLAP and Recursion
At a glance
- Institution: StanfordOnline
- Subject: Computer Science
- Level: Introductory
- Prerequisites: None
- Language: English
- Video Transcript: English
- Associated skills: SQL (Programming Language), Data Abstraction, Query Languages, Data Cube, Relational Databases, Computer Science, Star Schema, Online Analytical Processing, Telecommunications, Database Design, Database Systems, Concurrency Controls, Scalability, Reliability, Persistence, Lecturing