A Stanford database course offered on edX covering the relational model, SQL, and database fundamentals, including how to structure tables and design a schema.

Commenters point to it for solid relational model and SQL fundamentals, mixing computer science theory with practical exercises.

What commenters said (2)

1. Strongly recommendsfalcor842021in “Prolog for Beginners”

   Regarding intermediate level SQL, I'd highly recommend Jenniffer Widom's edx courses[0]. They have a good mix of cs theory and practical exercises, which combined gave me a big push in my approach to databases.

   [0] https://www.edx.org/course/databases-5-sql

2. Recommendspjacotg2024in “Ask HN: How to Learn Data Engineering?”

   You could try the Stanford database moocs [0], they're on EdX as well. This will focus more on the relational model, SQL and database fundamentals. These are the fundamentals you need to understand so you can structure your tables and design a schema.

   [0] https://online.stanford.edu/courses/soe-ydatabases0005-datab...

Related courses

• 15-445/645 Intro to Database SystemsCarnegie Mellon University · 17 recommenders
• Introduction to DatabasesStanford University · 16 recommenders
• 15-721 Advanced Database SystemsCarnegie Mellon University · 12 recommenders
• Intro to Database SystemsYouTube · 2 recommenders
• Introduction to DatabasesCoursera · 2 recommenders
• Introduction to Big Data with Apache SparkedX · 2 recommenders
• CS165 Data SystemsHarvard University · 1 recommender
• Introduction to Database Systems (Jennifer Widom)Stanford University · 1 recommender