TimescaleDB Course – PostgreSQL for Time-Series Data
Beau Carnes
Managing massive, rapidly growing datasets efficiently is a critical skill for modern developers. Whether you are tracking API request logs, monitoring IoT fleet telemetry, or building dashboards for AI agents, unoptimized time-series data can quickly slow standard PostgreSQL queries to a crawl. We just posted a new course on the freeCodeCamp.org YouTube channel that will teach you all about TimescaleDB
You'll get hands-on experience with TimescaleDB in this course, discovering how to upgrade PostgreSQL into an optimized time-series database. You will learn to optimize query speeds, drastically reduce storage footprints, and ensure your dashboards stay fast at scale.
Key concepts and hands-on projects include:
Hypertables & Chunk Management
Learn how TimescaleDB automatically partitions your data by time to speed up queries and streamline data retention without painful row deletions.
Columnar Storage & Compression
Discover how converting older row data into column-oriented batches can shrink your database size by over 90% and massively speed up analytical queries.
Continuous Aggregates
Stop recalculating identical data! You'll build incremental, automatically updating materialized views (and aggregate "ladders") that keep dashboards returning results in milliseconds.
Hyperfunctions & Gap Filling
Master specialized time-series functions for calculating percentiles, distinct counts, handling counter resets, and smoothing out data gaps for clean frontend charting.
Data Tiering & Vector Search
Explore moving older, cold data out of expensive local SSDs into cheaper S3 object storage seamlessly, and see how to combine standard time-series queries with AI vector search.
The course walks you through building two complete, production-ready projects from scratch:
An AI Agent Flight Recorder
Track millions of language model inferences, tool calls, costs, and latencies locally in Docker.
An EV Charger Fleet Telemetry System
Monitor 2,000 devices reporting every 10 seconds, deployed directly on the fully-managed Tiger Cloud platform.
Watch the full TimescaleDB Course on the freeCodeCamp.org YouTube channel (4-hour watch).
Beau Carnes
I'm a teacher and developer with freeCodeCamp.org. I run the freeCodeCamp.org YouTube channel.
If this article was helpful, .
Learn to code for free. freeCodeCamp's open source curriculum has helped more than 40,000 people get jobs as developers. Get started
ADVERTISEMENT