Basic SQL Queries in TimescaleDB
At this point in the series, you should have data ingested into your TimescaleDB instance. Now it’s time to query it! In this video, we walk you through some basic SQL queries, and show some more advanced TimescaleDB functions you can use.
🛠 𝗥𝗲𝗹𝗲𝘃𝗮𝗻𝘁 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀
📌 Watch the full playlist ⇒ https://tsdb.co/getting-started-playlist
📌 Getting started docs ⇒ https://tsdb.co/getting-started-query...
📌 DBeaver ⇒ https://dbeaver.io/
📌 first() function docs ⇒ https://tsdb.co/api-reference-first
📌 last() function docs ⇒ https://tsdb.co/api-reference-last
📌 time_bucket() docs ⇒ https://tsdb.co/api-reference-time-bu...
📚 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀:
⏱ 0:10 ⇒ Introduction
⏱ 0:48 ⇒ Query 1: SELECT statement
⏱ 1:42 ⇒ Query 2: ORDER BY and LIMIT
⏱ 3:09 ⇒ Query 3: AVG(), JOINs, and WHERE clause
⏱ 4:50 ⇒ TimescaleDB first() and last() function overview
⏱ 6:09 ⇒ Query 4: first() and last() functions, GROUP BY
⏱ 7:39 ⇒ TimescaleDB time_bucket() function overview
⏱ 10:14 ⇒ Query 6: time_bucket() function
⏱ 12:18 ⇒ Outro
🐯 𝗔𝗯𝗼𝘂𝘁 𝗧𝗶𝗺𝗲𝘀𝗰𝗮𝗹𝗲
Timescale is the company behind TimescaleDB, the relational database for time-series. With time-series data, developers can understand what is happening right now, how that is changing, and why that is changing. The best way to get TimescaleDB is Timescale Cloud. Try for free today at https://tsdb.co/timescale-cloud.
Timescale is a remote-first company with a global workforce and is currently hiring in all departments: https://tsdb.co/timescale-careers
💻 𝗙𝗶𝗻𝗱 𝗨𝘀 𝗢𝗻𝗹𝗶𝗻𝗲!
🔍 Website ⇒ https://tsdb.co/homepage
🔍 Slack ⇒ https://slack.timescale.com
🔍 GitHub ⇒ https://github.com/timescale
🔍 Twitter ⇒ / timescaledb
🔍 Twitch ⇒ / timescaledb
🔍 LinkedIn ⇒ / timescaledb
🔍 Timescale Blog ⇒ https://tsdb.co/blog
🔍 Timescale Documentation ⇒ https://tsdb.co/docs