Types of DB: SQL, NoSQL, Vector
SQL Databases
Examples:
  PostgreSQL:
   Install, Commands(Create/Connect/List/Delete database, tables. Insert data)
   Stored procedures, Function, Extensions (pg_trgm), pgmq(Postgres Inbuilt MessageQueue), PgBouncer(Connection Pooler)
MariaDB, MySQL, Amazon RDS, Amazon Aurora
CockroachDB
SQL Database Issues
NoSQL Databases
Examples: Columnar DB, Graph DB(Cypher, GraphDB)
DB: Couchbase(Introduction, N1QL)
Vector Databases
Introduction
DB Scaling: Replication, Federation, Sharding
DB Schema
Terms:
ACID(Atomicity, Consistency, Isolation, Durability)
Indexing(Forward, Reverse)
Isolation(Read Committed, Snapshot Isolation)
JOIN(Left, Right, Inner, Full, Cross)
Transaction(Dirty Read, Dirty Write, Read Skew, Write Skew, 2PC(Two Phase Commit))