SQL → NoSQL
Relational Database → non-relational/distributed database
Table based → Document based/key-value pairs/graph database/ wide column stores
Pre-defined schema → dynamic schema
Vertically scalable → Horizontally scalable
Good fit for ccomplex queires → best for transactional applciations
What kind of data is a good fit for an SQL database?
SQL Databases are the best fit for complex queries and heavy duty transactional type applications
Give a real world example.
banking applications would be the best use of the sql database
What kind of data is a good fit a NoSQL database?
hierarchical data storage because it folllows a key-value pair way of storing data
Give a real world example.
Social Media Accounts.
Which type of database is best for hierarchical data storage?
NoSQL
Which type of database is best for scalability?
SQL
Videos
sql vs nosql (Video)
What does SQL stand for?
structured query language
What is a relational database?
A db that works that works a certain way and works with SQL. Database are stored in tables.
What type of structure does a relational database work with?
Tables
What is a ‘schema’?
what defines a table
What is a NoSQL database?
a DB built to efficiently store lots of data.
How does it work?
Things are store documents in collections vs tables.
What is inside of a MongoDB database?
Documents stored in Collections
Which is more flexible - SQL or MongoDB? and why.
MongoDB is more flexible because it doesnt have any set schemas defined and that needs to be adhere to.
What is the disadvantage of a NoSQL database?
Not being sure if a data adheres to a format because NoSQL databases dont have any scemna defined.