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.

Conoce a tus instructores
Obtén un Certificado Verificado para destacar los conocimientos y las habilidades que adquieras$50 USD
Oficial y verificado
Obtén un certificado con la firma del instructor y el logotipo de la institución para demostrar tus logros y aumentar las posibilidades de conseguir trabajo
Fácil de compartir
Agrega el certificado a tu currículum o publícalo directamente en LinkedIn
Incentivo comprobado
El certificado te da un motivo más para completar el curso
Apoya nuestra labor
edX, una organización sin fines de lucro, se sustenta con los certificados verificados para financiar la educación gratuita para todo el mundo
Preguntas frecuentes
How long will it take to go through the course material?
All courses in the Databases series are self-paced and include videos, quizzes, and/or exercises. The courses vary considerably in length and complexity, and some students work faster than others, so we're not able to predict an individual time commitment.
What background do I need?
The series of courses does not assume prior knowledge of any specific topics, however a solid computer science foundation -- a reasonable amount of programming, as well as knowledge of basic computer science theory -- will make the material more accessible.
Do I need to buy a textbook?
Detailed lecture notes are provided. Having a textbook in addition to the notes is not necessary, but you might want to purchase one for reference, to reinforce the core material, and as a source of additional exercises. Suggested textbooks and readings are listed as part of the materials.