Uploaded September 2026 | Updated November 2026, 39 minutes ago
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: 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 Testing Hypertable Performance
- 0:59:14 Indexing & Chunk Skipping
- 1:03:50 Global Unique Indexes & UUID v7
- 1:13:45 Data Locality & Reordering
- 1:15:42 The Column Store
- 1:18:36 Columnar Compression Techniques
- 1:22:58 Segment By & Order By
- 1:26:15 Converting Chunks to Column Store
- 1:29:03 Compressed Indexes & Bloom Filters
- 1:32:27 Continuous Aggregates
- 1:38:08 Real-Time Aggregates
- 1:40:30 Aggregate Ladders
- 1:44:50 Hyperfunctions & Gap Filling
- 1:50:16 State Aggregates
- 1:52:28 Approximate Aggregates & Percentiles
- 1:55:58 HyperLogLog (Approximate Count Distinct)
- 1:57:26 Other Toolkit Features
- 1:59:30 Data Retention Policies
- 2:04:47 Tiered Storage
- 2:08:42 Docker Setup & Environment Configuration
- 2:16:35 Project 1: AI Agent Flight Recorder
- 2:22:04 Project 1: Schema Design
- 2:28:22 Project 1: Ingestion Script & Batch Copy
- 2:35:45 Project 1: Optimizing the Database
- 2:50:56 Project 1: Querying Raw Data
- 3:00:13 Project 1: API & Dashboard Integration
- 3:15:54 Project 2: EV Fleet Telemetry & TigerCloud
- 3:22:20 Project 2: Schema Design
- 3:25:52 Project 2: The Analytics Join Myth
- 3:27:26 Project 2: Segment By Benchmarking
- 3:42:32 Project 2: Finding Anomalies
- 4:02:13 Project 2: Semantic Search (pgvector)
- 4:08:47 TigerCloud Console Overview
- 4:14:26 12-Step Production Checklist
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: 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 Testing Hypertable Performance
- 0:59:14 Indexing & Chunk Skipping
- 1:03:50 Global Unique Indexes & UUID v7
- 1:13:45 Data Locality & Reordering
- 1:15:42 The Column Store
- 1:18:36 Columnar Compression Techniques
- 1:22:58 Segment By & Order By
- 1:26:15 Converting Chunks to Column Store
- 1:29:03 Compressed Indexes & Bloom Filters
- 1:32:27 Continuous Aggregates
- 1:38:08 Real-Time Aggregates
- 1:40:30 Aggregate Ladders
- 1:44:50 Hyperfunctions & Gap Filling
- 1:50:16 State Aggregates
- 1:52:28 Approximate Aggregates & Percentiles
- 1:55:58 HyperLogLog (Approximate Count Distinct)
- 1:57:26 Other Toolkit Features
- 1:59:30 Data Retention Policies
- 2:04:47 Tiered Storage
- 2:08:42 Docker Setup & Environment Configuration
- 2:16:35 Project 1: AI Agent Flight Recorder
- 2:22:04 Project 1: Schema Design
- 2:28:22 Project 1: Ingestion Script & Batch Copy
- 2:35:45 Project 1: Optimizing the Database
- 2:50:56 Project 1: Querying Raw Data
- 3:00:13 Project 1: API & Dashboard Integration
- 3:15:54 Project 2: EV Fleet Telemetry & TigerCloud
- 3:22:20 Project 2: Schema Design
- 3:25:52 Project 2: The Analytics Join Myth
- 3:27:26 Project 2: Segment By Benchmarking
- 3:42:32 Project 2: Finding Anomalies
- 4:02:13 Project 2: Semantic Search (pgvector)
- 4:08:47 TigerCloud Console Overview
- 4:14:26 12-Step Production Checklist

![Claude Code for Beginners Tutorial [Full Course]
Learn all about Claude Code. This is the ultimate guide to turning Anthropicβs Claude into a seamless part of your development workflow. Whether youre scaffolding a brand-new project or navigating a complex, multi-file codebase, this is how you code faster without sacrificing quality.
π IMPORTANT LINKS
π¬ Practice with Hands-On Labs: https://kode.wiki/claude-code
π Get the Full Course here: https://kode.wiki/claude-code-course
β€οΈ Support for this channel comes from our friends at Scrimba β the coding platform thats reinvented interactive learning: https://scrimba.com/freecodecamp
βοΈ Contents βοΈ
0:00:00 Introduction
0:00:30 Prerequisites and Initial Setup
0:09:25 Start your first session
0:23:58 Understanding Codebases with Claude
0:32:21 Installing Claude on Ubuntu Virtual Machines
0:49:34 Building a project from scratch
0:49:34 Getting project ready for public release
0:56:49 Creating Unit Tests for our Project
1:03:20 Autonomous Task Completion
1:17:11 Environment and Configuration Management
1:30:17 Managing Long Sessions Effectively
2:07:52 Writing Effective Development Prompts
2:23:39 Multi-file Project Navigation
2:32:10 Working with APIs and External Services
2:46:16 Initial Project Analysis
2:56:24 Design Pattern Implementation Review
3:05:50 SOLID Principles Evaluation
3:24:04 Error Handling & Resilience Audit
3:36:04 Exception Flow Analysis
3:52:12 Resilience & Fault Tolerance
3:53:09 Code Quality Metrics & Standards
4:02:17 Code Duplication Detection
4:12:14 Naming Conventions & Readability
4:19:23 Test Coverage & Quality Analysis
π Thanks to our Champion and Sponsor supporters:
πΎ @omerhattapoglu1158
πΎ @goddardtan
πΎ @akihayashi6629
πΎ @kikilogsin
πΎ @anthonycampbell2148
πΎ @tobymiller7790
πΎ @rajibdassharma497
πΎ @CloudVirtualizationEnthusiast
πΎ @adilsoncarlosvianacarlos
πΎ @martinmacchia1564
πΎ @ulisesmoralez4160
πΎ @_Oscar_
πΎ @jedi-or-sith2728
πΎ @justinhual1290
Learn to code for free and get a developer job: https://www.freecodecamp.org
Read hundreds of articles on programming: https://freecodecamp.org/news Claude Code for Beginners Tutorial [Full Course]](https://i.ytimg.com/vi/gh2_PhgZGsM/mqdefault.jpg)








