💡

What all we’ll learn today -

Simple - SQL vs NoSQL, how to create Postgres Databases, How to do CRUD on them

Advance - Relationships, Joins, Transactions

There are a few types of databases, all service different types of use-cases

NoSQL databases

  1. Store data in a schema-less fashion. Extremely lean and fast way to store data.
  2. Examples - MongoDB,

notion image

Graph databases

  1. Data is stored in the form of a graph. Specially useful in cases where relationships need to be stored (social networks
  2. Examples - Neo4j

notion image

Vector databases

  1. Stores data in the form of vectors
  2. Useful in Machine learning
  3. Examples - Pinecone

notion image

SQL databases

  1. Stores data in the form of rows