SQL vs NoSQL
SQL Databases
DB Types: PostgreSQL, MariaDB, MySQL, Amazon RDS, Amazon Aurora
Installing Postgres (Linux/Windows)
DB Commands: Create/Connect/List/Delete database, tables. Insert data
SQL Database Issues
Stored procedures, Function
NoSQL Databases:
DB Types: Columnar DB, Graph DB(Cypher, GraphDB)
DB: Couchbase(Introduction, N1QL)
DB Scaling: Replication, Federation, Sharding
DB Schema
Terms:
ACID(Atomicity, Consistency, Isolation, Durability)
Indexing(Forward, Reverse)
Isolation(Read Committed, Snapshot Isolation)
Transaction(Dirty Read, Dirty Write, Read Skew, Write Skew, 2PC(Two Phase Commit))
Database Join(Left, Right, Inner, Full, Cross)