Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Stanford University

Databases: Introduction to Relational Databases

Stanford University via edX

This course may be unavailable.

Overview

About the Database Series of Courses

"Databases" was one of Stanford's three inaugural massive open online courses in the fall of 2011; it was offered again in MOOC format in 2013 and 2014. The course is now being offered as a set of smaller self-paced courses, which can be assembled in a variety of ways to learn about different aspects of databases. All of the courses are based around video lectures and/or video demos. Many of them include in-video quizzes to check understanding, in-depth standalone quizzes, and/or a variety of automatically-checked interactive programming exercises. Each course also includes a discussion forum and pointers to readings and resources. The courses are described briefly below, along with suggested pathways through them. Taught by Professor Jennifer Widom, the overall curriculum draws from Stanford's popular Databases course.

Why Learn About Databases

Databases are incredibly prevalent -- they underlie technology used by most people every day if not every hour. Databases reside behind a huge fraction of websites; they're a crucial component of telecommunications systems, banking systems, video games, and just about any other software system or electronic device that maintains some amount of persistent information. In addition to persistence, database systems provide a number of other properties that make them exceptionally useful and convenient: reliability, efficiency, scalability, concurrency control, data abstractions, and high-level query languages. Databases are so ubiquitous and important that computer science graduates frequently cite their database class as the one most useful to them in their industry or graduate-school careers.

Course Pathways

The following are a number of suggested pathways through the courses, depending on the topics and depth desired. Of course you are welcome to mix and match the courses any way you like!

Practical Relational Databases and SQL

Basic: INTRODUCTION AND RELATIONAL DATABASES, SQL

Extended version add: INDEXES AND TRANSACTIONS, CONSTRAINTS AND TRIGGERS, VIEWS AND AUTHORIZATION

Comprehensive version also add: ON-LINE ANALYTICAL PROCESSING, RECURSION IN SQL

Practical Relational Databases and SQL with UML Design

Basic: INTRODUCTION AND RELATIONAL DATABASES, UNIFIED MODELING LANGUAGE (UML), SQL

Extended version add: INDEXES AND TRANSACTIONS, CONSTRAINTS AND TRIGGERS, VIEWS AND AUTHORIZATION

Comprehensive version also add: ON-LINE ANALYTICAL PROCESSING, RECURSION IN SQL

Relational Databases and SQL: Foundations and Practice

Basic: INTRODUCTION AND RELATIONAL DATABASES, RELATIONAL ALGEBRA, SQL, RELATIONAL DESIGN THEORY, UNIFIED MODELING LANGUAGE (UML)

Extended version add: INDEXES AND TRANSACTIONS, CONSTRAINTS AND TRIGGERS, VIEWS AND AUTHORIZATION

Comprehensive version also add: ON-LINE ANALYTICAL PROCESSING, RECURSION IN SQL

Semistructured Data

Basic: XML DATA, JSON DATA

With querying add: XPATH AND XQUERY

With querying, comprehensive version add: XSLT

Taught by

Jennifer Widom

Reviews

4.6 rating, based on 15 Class Central reviews

Start your review of Databases: Introduction to Relational Databases

  • School is Broken
    Jennifer Widom is a phenomenal MOOC teacher. She is able to condense a very complex subject matter into succinct videos including detailed examples. If you have never worked with databases or tables before, then it may be a bit difficult to pick up initially, but Widom does a great job of onboarding laypeople

    To date, this has been my favorite and most rewarding MOOC. I would honestly recommend it to everyone. I would argue that it is essential for anyone in a Computer Science or Engineering program, regardless of whether you want to specialize in databases or not.
  • Anna K
    I liked the course as it allowed me to cover a lot of new things, and go deep in the topics I was interested in. The lectures were clear and engaging, and the tasks were though challenging but interesting. I think it is a really good course, as it's leading you smoothly through the materials and motivating to accomplish most you can.
  • The way she explains is just awesome, You can take this course without any doubt, I have taken a course in coursera on the same topic, only god knows what he was teaching.
  • Victor W. Gonzalez-Lauck
  • Nida
  • John Walsh
  • Profile image for Ilya Rudyak
    Ilya Rudyak
  • John Walsh
  • James Garner
  • Andrew Pribram
  • Profile image for Ignat Petrenko
    Ignat Petrenko
  • Martha Quevedo

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.