System Design – Technology Selection

Technology selection is a core component of system design. Once an architect identifies the components needed for the system, he/she needs to select a technology for each component. This course will help aspiring architects select the appropriate technology for each of the component. This course is structured into the following topics.

1. Database selection – We explain how SQL and NoSQL technologies are architecturally different and the scenarios under which each should be used. We also cover specialized databases that handle specific scenarios like Text search, Compound search and persistent data structures. We define a decision framework that leverages all these aspects to select the database for every scenario.

2. Data warehouses and data lakes – We cover why the OLAP queries that data warehouses run requires a fundamentally data layout pattern. We discuss how data lakes and warehouses need to be designed and provide a reference architecture. We also discuss the Event Hub pattern that is becoming very relevant in modern platforms.

3. Compute selection and Cache design – In this topic, we cover the tradeoffs associated with various compute platforms and how an architect should make the selection. We also discuss the need for caching and the aspects that need to be kept in mind, while designing a caching solution.

Rating Distribution

• 1 stars: 1 votes
• 2 stars: 1 votes
• 3 stars: 2 votes
• 4 stars: 2 votes
• 5 stars: 13 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!