When to use NoSQL, document modelling patterns, MongoDB aggregations, Atlas search, and the CAP tradeoffs that determine which database to choose in a system design interview.