How to design a scalable DB Schema

I used to think database design was mostly about knowing SQL. You know: CREATE TABLE users (...); CREATE TABLE posts (...); Then add a few foreign keys, write some joins, and you're done. But after d