• CASCADE

Lock

• Understanding Locks
• Table Locks
• Row Locks

Join

• Introduction to Joins
• Cross Join
• Inner Join
• Left Join
• Right Join
• Full Outer Join
• Lateral Join
• Self Join

Transaction

• Understanding ACID in PostgreSQL
• Introducing transactions
• Transaction Identifiers
• Multi-Version Concurrency Control
• Non-Repeatable vs Phantom Reads: What’s the Real Difference?
• Savepoints
• Isolation levels
• Deadlocks
• Write-Ahead Logging (WAL)
• VACUUM

---

Home