Lesson 8, Materialized Views and Continuous Aggregates

📝 𝗔𝗯𝗼𝘂𝘁 𝗙𝗼𝘂𝗻𝗱𝗮𝘁𝗶𝗼𝗻𝘀 𝗼𝗳 𝗣𝗼𝘀𝘁𝗴𝗿𝗲𝗦𝗤𝗟 & 𝗧𝗶𝗺𝗲𝘀𝗰𝗮𝗹𝗲𝗗𝗕 𝗖𝗼𝘂𝗿𝘀𝗲
This course is designed for beginners to SQL and database management systems. Throughout the course, we’ll be looking at various topics including schema design, basic schema design, compression, JOINs, and much more.

🛠 𝗥𝗲𝗹𝗲𝘃𝗮𝗻𝘁 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀
📌 Foundations of PostgreSQL & TimescaleDB course playlist ⇒    • Course: Foundations of PostgreSQL & T...  
📌 Lesson slides ⇒ https://docs.google.com/presentation/...

📚 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀
⏱ 0:00 ⇒ Introduction
⏱ 6:19 ⇒ Views
⏱ 6:30 ⇒ JOIN in a View
⏱ 7:00 ⇒ JOIN in a CTE
⏱ 7:12 ⇒ JOIN in a Subselect
⏱ 11:23 ⇒ Views - Function Calls
⏱ 20:19 ⇒ Materialized Views
⏱ 27:54 ⇒ Continuous Aggregates
⏱ 27:54 ⇒ Scheduled aggregation
⏱ 30:57 ⇒ Real-time views
⏱ 34:58 ⇒ Invalidation for out-of-order data
⏱ 39:31 ⇒ Downsampling older data

🐯 𝗔𝗯𝗼𝘂𝘁 𝗧𝗶𝗺𝗲𝘀𝗰𝗮𝗹𝗲
At Timescale, we are dedicated to serving developers worldwide, enabling them to build exceptional data-driven products that measure everything that matters. Analyzing this data across the time dimension ("time-series data") enables developers to understand what is happening right now, how that is changing, and why that is changing. We are backed by top-tier investors with a track record of success in the industry.

💻 𝗙𝗶𝗻𝗱 𝗨𝘀 𝗢𝗻𝗹𝗶𝗻𝗲!
🔍 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