Databases: OLAP and Recursion

Course Cover
compare button icon

Course Features

icon

Duration

2 weeks

icon

Delivery Method

Online

icon

Available on

Limited Access

icon

Accessibility

Mobile, Desktop, Laptop

icon

Language

English

icon

Subtitles

English

icon

Level

Beginner

icon

Effort

10 hours per week

icon

Teaching Type

Self Paced

Course Description

The Database Series of Courses, offered by Stanford University, provides comprehensive training on various aspects of databases. The series includes five self-paced courses, with "Relational Databases" being the most popular. This course aims to teach learners about relational databases and master SQL, the standard query language for relational data systems.

The courses in the series are delivered through video lectures and demonstrations. They also include quizzes and interactive exercises to check understanding. Each course has a discussion forum and provides resources for further learning.

Databases play a crucial role in technology, with many websites and software systems relying on them. They offer advantages such as persistence, efficiency, concurrency control, reliability, and scalability. Data abstractions and high-level query language support make databases convenient and useful.

Databases are considered important and ubiquitous in the field of computer science. Many graduates credit their database class as being the most helpful in their careers or graduate school journeys.

The Database Series of Courses covers a wide range of topics, including advanced concepts in relational databases and SQL, formal foundations, design methodologies, and semistructured information. Professor Jennifer Widom teaches the curriculum and draws from Stanford's long-standing Databases course.

Overall, the courses in the Database Series provide a comprehensive understanding of databases, relational database management systems, and SQL. They are suitable for learners interested in data science and those looking to enhance their skills in working with databases.

Course Overview

projects-img

International Faculty

projects-img

Post Course Interactions

projects-img

Instructor-Moderated Discussions

Skills You Will Gain

What You Will Learn

An introduction to the XSLT rule-based language for querying and transforming XML data

Authorization in relational databases

Comprehensive coverage of SQL, the long-accepted standard query language for relational database management systems

Creating indexes for increased query performance

Database constraints: key, referential integrity, and "check" constraints

Database triggers

Dependency theory and normal forms in relational databases as the basis of schema design

How views are created, used, and updated in relational databases

Introduction to the relational model and concepts in relational databases and relational database management systems

Relational algebra – the algebraic query language that provides the formal foundations of SQL

Star schemas, the data cube concept, and On-Line Analytical Processing (OLAP) features in relational databases including the Cube and Rollup operators

The JSON model for human-readable structured or semistructured data

The SQL standard for queries over recursively-defined relations

The XML model for semistructured and self-describing data, including DTDs and some features of XML Schema

The XPath language for processing XML data, and many features of the more advanced XQuery language

The data-modeling component of the Unified Modeling Language (UML), how UML diagrams are translated to relations

Using transactions for concurrency control and failure recovery

Course Instructors

Author Image

Jennifer Widom

Dean, School of Engineering at Stanford University

Jennifer Widom is the Frederick Emmons Terman Dean of the School of Engineering and the Fletcher Jones Professor in Computer Science and Electrical Engineering at Stanford University. She served as C...
Course Cover