I am really good at algo interviews but I suck at system design, especially choosing nosql vs sql and designing tables for given use case scenario. any resources that you recommend for databases? (i checked grokking but it wasn’t enough. i don’t want to memorize the solutions. ) do you think I should know BCNF, 3nf, etc? yoe: 3 tc: non-us
Practice more. There is no secret guide that you read once and suddenly become expert. Stop looking for one.
You should read the data models chapter from the designing data intensive applications book. About 20-30 pages and you will understand a lot more. I don’t think you need to learn those normal form stuff. Just what denormalization means and when to use it.
Learn the idea of normalization, but no need to memorize forms. Then think about how much what will be accessed and what your space restrictions are. Normalize/denormalize just enough
This post talks about the difference between both and their pros and cons, as well as examples of companies such as StackOverflow and Uber who managed to scale with either https://nodeflair.com/blog/sql-vs-nosql-databases-system-design-interview
Tech Industry
Yesterday
773
Chances of meta clearing E5 with screwing up one coding one round and acing all other
Tech Industry
2d
54682
Goog Employees Arrested
2024 Tax
Yesterday
3989
Biden’s new tax proposal is wild
Tech Industry
Yesterday
24939
Google doing more layoffs, restructuring including country moves
India
Yesterday
1689
Please vote sensibly 🙏
Nope. You should know SQL vs NoSQL, and how to define indexes.