NoSQL and SQL

Closer Look at NoSQL

Multiple Choice

What does the Acronym NoSQL stand for?

• NoSQL

  There is no SQL

  FInally! Thankfully, no SQL

• Hmm..well, I just woke up, no I am not sure

• Not SQL

• Not Only SQL

Difference between SQL and NoSQL

SQL databases are well suited for structured data, complex relationships and transactional systems.

NoSQL databases are well suited for unstructured, big data and real-time analytics applications.

Multiple Choice

NoSQL database use a fixed table schema and rely on SQL to query the data.

True or False?

• TRUE

• FALSE

Relationships

How do NoSQL Databases handle data relationships?

Instead of using foreign keys, NoSQL databases use embedded documents or denormalized data.

<Show the video: Normalised and de-normalised data Lectures:Database:2023:videos>

​Source: Datacamp.com

Multiple Select

Disadvantages of NoSQL

• Data integrity

• performance

• limited querying capability

• scalability

Multiple Select

Advantages of NoSQL

• Scalability

• flexibility

• difficulty to handle complex relationships

• No clue.

Types of NoSQl Databases

​Source: Datacamp.com

​Source: www.webassessts.mongodb.com

​Document Database

​Key-Value database

​Source: Datacamp.com

​Graph Database

​Source: Datacamp.com

Column Database

​Source: Datacamp.com

Multiple Choice

Advantage of graph database over a traditional relational database?

• Better at handling unstructured data

• Better at handling complex relationships between data

• faster at performing complex queries

​Source: Beginnersbook.com

​Source: crocodillion.com

Multiple Choice

Explain the difference between JSON and BSON

• JSON: Binary Format

  BSON: text-based Format

• BSON: Designed to store data in document-oriented database while JSON is not

• JSON: data interchange format.

  BSON: data storage format

• BSON: more efficient format for storing data than JSON