In this article we will discuss how to translate some advanced fundamentals of SQL into NoSQL in the context of Cloud Firestore.