Sql is a relationship database, and Nosql is not. The main difference is how data is linked in a relationship database, It pretty much always looks like a table because it has to. Like if you had an object, person, and that person had a favorite color, then ever instance of person would have that favorite color field.
Name | Favorite Color
I mean, I could have made a table I guess but yeah.
Key highlights on SQL vs NoSQL:
|RELATIONAL DATABASE MANAGEMENT SYSTEM (RDBMS)||Non-relational or distributed database system.|
|These databases have fixed or static or predefined schema||They have have dynamic schema|
|These databases are not suited for hierarchical data storage.||These databases are best suited for hierarchical data storage.|
|These databases are best suited for complex queries||These databases are not so good for complex queries|
|Vertically scalable||Horizontally scalable|
Nice, we learned.