What is SQL and No SQL databases? Which one should I learn first?

SQL (Structured Query Language) is a language used to interact with a relational database. It is used to store, manipulate, and retrieve data from the database.

NoSQL (Not Only SQL) is a type of non-relational database that does not use SQL for data manipulation. It is used for storing and retrieving data in a non-tabular format.

SQL databases are relational databases which means that data is stored in tables with relationships between tables defined by foreign keys.

NoSQL databases are non-relational databases which means that data is stored in a non-tabular format such as document-oriented, graph-oriented, or key-value stores.

SQL databases are better suited for structured data where the data structure is known and data is not expected to change frequently.

NoSQL databases are better suited for unstructured data where the data structure is not known in advance and data is expected to change frequently.

If you are just starting out, it is recommended to learn SQL first as it is more widely used and better understood.

Thank you for reading. Create summary videos with Kimavi.