TimescaleDB Course – PostgreSQL for Time-Series Data

Learn how to supercharge PostgreSQL for time-series data and heavy analytics workloads using the TimescaleDB extension. In this comprehensive course, you will master hypertables, continuous aggregates, and columnar storage by building real-world projects like an AI agent flight recorder and an EV fleet telemetry dashboard.

Created by @beau

????️ Tiger Data provided a grant to make this course possible.

Get $1,000 credit on Tiger Cloud to follow along: https://tsdb.co/fcc-learn-tsdb

Chapters
- 0:00:00 Introduction & Database Comparison
- 0:01:06 Course Overview
- 0:01:28 Sponsor (Tiger Data & Tigercloud)
- 0:02:27 What is Time Series Data?
- 0:04:19 Projects Overview
- 0:05:24 It's Just PostgreSQL
- 0:06:54 Example Data Setup
- 0:10:20 The 20% of SQL You Need
- 0:19:34 Understanding EXPLAIN & ANALYZE
- 0:24:59 Pages & Row Storage
- 0:26:09 MVCC, Dead Rows & Vacuuming
- 0:29:27 Native Postgres Partitioning vs. TimescaleDB
- 0:32:42 What is a Hypertable?
- 0:33:14 Materialized Views & Summary Tables
- 0:37:05 The Dashboard Problem (Web Analytics Scenario)
- 0:44:14 Creating a Hypertable
- 0:48:43 The Golden Rule: Always Filter by Time
- 0:49:31 How Big Should a Chunk Be?
- 0:54:21...