Basic - Mongo Questions

  1. What is SQL and NoSQL?
  2. Basic diff between SQL and NoSQL…?
    3 Refer this link for more understanding :-
1 Like

SQL requires vertical scaling to handle large volumes of data
NoSQL Horizontal scaling is possible to handle large volumes of data

NoSQL and SQL databases have many similarities. In addition to supporting data storage and queries, they both also allow one to retrieve, update, and delete stored data.

  1. sql is a relational database management
    nosql is a non-relational database management system
  2. SQL databases use a structured schema and are suitable for complex queries
    NoSQL provide flexible schema and are ideal for handling structure
  1. Structured query language (SQL) is a programming language for storing and processing
    information in a relational database** .
    “no-SQL”, is an approach to database design that enables the storage and querying of data
    outside the traditional structures found in relational databases.
  2. SQL is the programming language used to interface with relational databases.
    NoSQL is a class of DBMs that are non-relational and generally do not use SQL.