EP90: How do SQL Joins Work?

This week’ system design refresher:


Get paid to build full-stack Zero-Knowledge applications on Aleo (Sponsored)

Unlock the future of dApps with Aleo's Layer-1 blockchain, where zero-knowledge tech is baked in—not tacked on. Enjoy the best of both worlds: bulletproof privacy and scalable performance, no crypto PhD required. Our language, Leo, and web-friendly SDK make it a breeze to integrate.

Aleo has deployed over $1 Million in grants.

Apply here today!


How Does Linux Boot Process Work?


How do SQL Joins Work?

The diagram below shows how 4 types of SQL joins work in detail.


Latest articles

If you’re not a paid subscriber, here’s what you missed this month.

  1. 7 Microservices Interview Questions

  2. Why the Internet Is Both Robust and Fragile

  3. Unlock Highly Relevant Search with AI

  4. Does Serverless Have Servers?

  5. A Crash Course in Docker

To receive all the full articles and support ByteByteGo, consider subscribing:

Subscribe now


What are the differences between cookies and sessions?

The diagram below shows how they work.

No alt text provided for this image

Cookies and sessions are both used to carry user information over HTTP requests, including user login status, user permissions, etc.


How do DevOps, NoOps change the software development lifecycle (SDLC)?

The diagram below compares traditional SDLC, DevOps and NoOps.

No alt text provided for this image

In a traditional software development, code, build, test, release and monitoring are siloed functions. Each stage works independently and hands over to the next stage.

DevOps, on the other hand, encourages continuous development and collaboration between developers and operations. This shortens the overall life cycle and provides continuous software delivery.

NoOps is a newer concept with the development of serverless computing. Since we can architect the system using FaaS (Function-as-a-Service) and BaaS (Backend-as-a-Service), the cloud service providers can take care of most operations tasks. The developers can focus on feature development and automate operations tasks.

NoOps is a pragmatic and effective methodology for startups or smaller-scale applications, which moves shortens the SDLC even more than DevOps.