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))