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

The Data Monk Interview Books – Don’t Miss

Now we are also available on our website where you can directly download the PDF of the topic you are interested in. At Amazon, each book costs ~299, on our website we have put it at a 60-80% discount. There are ~4000 solved interview questions prepared for you.

10 e-book bundle with 1400 interview questions spread across SQL, Python, Statistics, Case Studies, and Machine Learning Algorithms – Ideal for 0-3 years experienced candidates

23 E-book with ~2000 interview questions spread across AWS, SQL, Python, 10+ ML algorithms, MS Excel, and Case Studies – Complete Package for someone between 0 to 8 years of experience (The above 10 e-book bundle has a completely different set of e-books)

12 E-books for 12 Machine Learning algorithms with 1000+ interview questions – For those candidates who want to include any Machine Learning Algorithm in their resume and to learn/revise the important concepts. These 12 e-books are a part of the 23 e-book package

Individual 50+ e-books on separate topics

Important Resources to crack interviews (Mostly Free)

There are a few things which might be very useful for your preparation

The Data Monk Youtube channel – Here you will get only those videos that are asked in interviews for Data Analysts, Data Scientists, Machine Learning Engineers, Business Intelligence Engineers, Analytics Manager, etc.
Go through the watchlist which makes you uncomfortable:-

All the list of 200 videos
Complete Python Playlist for Data Science
Company-wise Data Science Interview Questions – Must Watch
All important Machine Learning Algorithm with code in Python
Complete Python Numpy Playlist
Complete Python Pandas Playlist
SQL Complete Playlist
Case Study and Guesstimates Complete Playlist
Complete Playlist of Statistics

Author: TheDataMonk

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 :)