Foundations Docker & Setup Architecture SQL Basics

Foundations

Foundations

Get it running, understand the process model, and write your first schema.

Get it running, understand the process model, and write your first schema.

Sections

2.1
Docker & SetupRunning PostgreSQL locally
2.2
ArchitectureClient/server model, processes, clusters, databases, schemas
2.3
SQL BasicsCREATE, INSERT, SELECT — DDL and DML fundamentals

Why PostgreSQL

OLTP vs OLAP, ACID, history, when it's the wrong choice

Docker & Setup

Running PostgreSQL locally