Database

Database System Concepts #

Reference material: Database System Concepts - A. Silberschatz

Table Of Contents #

• Chapter 1: Introduction to the Relational Model
• Chapter 2: Structured Query Language (SQL)
• Chapter 3: Intermediate SQL
• Chapter 4: Physical Storage Systems
• Chapter 5: Data Storage Structures

PostgreSQL #

Reference material: Learn PostgreSQL, 2nd Edition

• Chapter 1: Introduction to PostgreSQL
• Chapter 2: The Cluster
• Chapter 3: Managing Users and Connections
• Chapter 4: Basic Statements
• Chapter 5: Advanced Statements
• Chapter 6: Window Functions
• Chapter 7: Partitioning