I will share one that has served me well for over 20 years: learn RDBMS and SQL. Learn normal forms, good schema design, and how to write complex queries. NoSQL adopters often avoided schemas like the plague and ended up with unmaintainable messes after a few years. I have seen more than a few NoSQL -> SQL conversions by now. Data is the most important thing in your app. Give it a great design. Plus databases like Po…
Any references in particular you recommend to learn schema design, particularly with an orientation towards performance (e.g. for high-volume sites)? A couple years ago I got dinged on a take-home project that involved building a db schema, but didn't get any specific feedback on my work, and it's sort of haunted me to this day (especially since SQL is one of my primary languages)
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...