Mongo and Mongoose

nosql vs sql part 1

1. Fill in the chart below with five differences between SQL and NoSQL databases:

SQL	NoSQL
primarily called as Relational Databases (RDBMS);	primarily called as non-relational or distributed database.
are table based databases	document based
have predefined schema	have dynamic schema
vertically scalable	horizontally scalable
uses SQL ( structured query language ) for defining and manipulating the data	queries are focused on collection of documents

 

2. What kind of data is a good fit for an SQL database?

complex queries

 

3. Give a real world example.

MySQL database

 

4. What kind of data is a good fit a NoSQL database?

large data sets

 

5. Give a real world example.

Hbase

 

6. Which type of database is best for hierarchical data storage?

NoSQL

 

7. Which type of database is best for scalability?

NoSQL

 

---

sql vs nosql part 2

1. What does SQL stand for?

Structured Query Language

 

2. What is a realational database?

a type of database that stores and provides access to data points that are related to one another

 

3. What type of structure does a relational database work with?

tables

 

4. What is a ‘schema’?

database schema is the structure described in a formal language supported by the database management system

 

5. What is a NoSQL database?

not only SQL

 

6. Howo does it work?

Doesn’t stand use SQL, so it’s more flexible.

 

7. What is inside of a Mongo database?

NoSQL

 

8. Which is more flexible - SQL or MongoDB? and why.

MongoDB, because it doesn’t only use the SQL language.

 

9. What is the disadvantage of a NoSQL database?

not compatible with SQL

 

---

   

Get back to EMAM’S HOMEPAGE

I have created this page as a part of my project using Github, Please visit my profile, I will be more than happy to hear from you all.                       © Emam Shararah 2021