Register Now

Login

Lost Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Login

Register Now

It will take less than 1 minute to register for lifetime. Bonus Tip - We don't send OTP to your email id Make Sure to use your own email id for free books and giveaways

Difference between SQL and NoSQL

Difference between SQL and NoSQL
There are two types of databases that are used predominantly across all the domains. Your organization might be using SQL or NoSQL or both. You might hear about these types of databases from the data engineers/engineering manager in your team

Let’s discuss the difference between SQL and NoSQL one by one

Difference between SQL and NoSQL
Difference between SQL and NoSQL

Difference between SQL and NoSQL

  1. Let’s assume you are creating a database for a small school/class and you already know what are the columns you need and the datatype associated with the columns. You alos understand that you need keys which needs to be in relation to other tables, then you need SQL database as these are Relational Databases

    NoSQL on the other hand is Non-relational database and you use such databases when you data is unstructured, you are not sure about the fileds which you need to extract from the complete dump.

    Example running an app like Amazon, you can not have a definite definition to all the fields which you want to extract from the user’s clickstream data. So, one solution could be to store every thing in a key-value pair or a graph database and then retrieve the data.
  2. SQL databases are table-based on the other hand NoSQL databases are either key-value pairs, document-based, graph databases or wide-column stores
  3. SQL follows an ACID property where as NoSQL believes in CAP theorem (Consistency, Availability and Partition tolerance)
  4. There is one catch in using NoSQL i.e. you can not write complex queries on these databases, why? because the data itself is un-structured and when you have Big Data that too and unstructed one, then you can not fire a complex query(it won’t run)

    SQL – The tables are sorted, you can use comeplxe queries
  5. Scalability – In almost all situations SQL databases are vertically scalable. This means that you can increase the load on a single server by increasing things like RAM, CPU or SSD. But on the other hand NoSQL databases are horizontally scalable.
    This means that you handle more traffic by sharding, or adding more servers in your NoSQL database.
  6. SQL = MySQL, Oracle, PostgreSQL, and Microsoft SQL Server.
    NoSQL = MongoDB, BigTable, Redis, RavenDB Cassandra, HBase, Neo4j, and CouchDB

Difference between SQL and NoSQL

The Data Monk E-shop

Now we have our own portal to buy all the available books – Please check out the Shop section, where you can download any book in PDF format

The Data Monk – E-shop

SQL Quick revision Videos

About TheDataMonkGrand Master

I am the Co-Founder of The Data Monk. I have a total of 6+ years of analytics experience 3+ years at Mu Sigma 2 years at OYO 1 year and counting at The Data Monk I am an active trader and a logically sarcastic idiot :)

Follow Me

Leave a reply