#924 overall
Relational Design Theory
Stanford Lagunita
1 recommender · 1 thread · recommended in 1 year, 2020 · score 0.7
A Stanford Lagunita self-paced course on relational database design theory, formalizing ideas about how relational schemas should be structured. It is offered as part of Stanford's database MOOC sequence, and the commenter notes some related sections may serve as prerequisites.
The commenter says it formalizes intuition that experienced SQL users already have, which makes it a challenge and a rewarding way to understand why good relational designs work.
Databases & Data Engineeringintermediatefreeself-paced text#relational design#database theory#normalization#stanford lagunita#relational algebra
Recommendations by year
20062026
Take a look at the "Relational Design Theory"[1] mini-course on Stanford/Lagunitas. Though I had used SQL for years, I took it as part of the early MOOC on databases that was offered in 2011. It is likely to match up with the intuition you already have about what works well in practice, but it can still be a challenge and rewarding to formalize your intuition and understanding.
The way the course is broken up now, you may need some of the other sections [2] like Intro to Relational Databases or Relational Algebra as prerequisites, since I do not remember if it used SQL syntax.
[1] https://lagunita.stanford.edu/courses/DB/RD/SelfPaced/about
[2] https://lagunita.stanford.edu/courses/DB/2014/SelfPaced/abou...