Lesson 0, Database Fundamentals: Memory, Storage and ACID Guarantees
Get an overview of database fundamentals, including memory and storage as well as ACID guarantees.
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.
🛠 𝗥𝗲𝗹𝗲𝘃𝗮𝗻𝘁 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀
📌 Course forum ⇒ https://www.timescale.com/forum/t/dat...
📌 Foundations of PostgreSQL & TimescaleDB course playlist ⇒ https://tsdb.co/playlist-foundations-...
📌 Sign up for Timescale Cloud for free ⇒ https://tsdb.co/ts-cloud-signup
📌 Slides from this presentation: https://tsdb.co/Lesson-0
🐯 𝗔𝗯𝗼𝘂𝘁 𝗧𝗶𝗺𝗲𝘀𝗰𝗮𝗹𝗲
Timescale is the modern Postgres database for time-series. 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
📚 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀:
⏱ 0:00 ⇒ Introduction
⏱ 11:35 ⇒ The Alchemy of Air
⏱ 12:21 ⇒ Context leads to understanding
⏱ 12:57 ⇒ Goal: Build high-level internal knowledge
⏱ 14:39 ⇒ What is a database?
⏱ 15:16 ⇒ Database Management System
⏱ 18:10 ⇒ High-level computer architecture
⏱ 19:17 ⇒ Memory & storage
⏱ 20:24 ⇒ Volatile & non-volatile storage
⏱ 21:38 ⇒ Useful naming and definitions
⏱ 28:48 ⇒ Database history & context
⏱ 30:53 ⇒ ACID guarantees
⏱ 40:18 ⇒ Keys and indexes
⏱ 45:20 ⇒ What's next?
⏱ 48:38 ⇒ Outro
#database #postgresql #sql