Follow this order for design interview prep:
Connect to Arslan Ahmad on linked in, lot of good quick cheet sheets you get from Arslan on some design concepts.
CAP: https://www.interviewbit.com/system-design-interview-questions/#cap-theorem
SQLVs No-SQL: https://www.interviewbit.com/blog/sql-vs-nosql/
Kafka: http://cloudurable.com/blog/what-is-kafka/index.html
Kafka Vs RabbitMQ: https://dattell.com/data-architecture-blog/kafka-vs-rabbitmq-how-to-choose-an-open-source-message-broker/
Sharding disadvantages: https://thinkscholar.com/programming/database-concepts/disadvantages-of-sharding/
CodeKarle Designs: https://github.com/codekarle/system-design/tree/master/system-design-prep-material/architecture-diagrams
AWS Services for 3Tier Arch : https://www.youtube.com/watch?v=FDEpdNdFglI
Paid Courses:
https://www.designgurus.io/course/grokking-the-advanced-system-design-interview
