Lesson 2, Using psql to Explore a PostgreSQL Database
In this episode, Timescale team members David Kohn and Miranda Auhl explore a Postgres database using psql and other tools. You’ll learn how to describe tables, data types, schema qualification, and begin understanding constraints.
🛠 𝗥𝗲𝗹𝗲𝘃𝗮𝗻𝘁 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀
📌 Course forum ⇒ https://www.timescale.com/forum/t/dat...
📌 Foundations of PostgreSQL & TimescaleDB course playlist ⇒ https://tsdb.co/playlist-foundations-...
📌 postgres_air repo ⇒ https://github.com/hettie-d/postgres_air
📌 PostgreSQL documentation ⇒ https://www.postgresql.org/docs/curre...
𝗛𝗮𝗻𝗱𝘆 𝗹𝗶𝗻𝗸𝘀 𝘄𝗶𝘁𝗵𝗶𝗻 𝗣𝗼𝘀𝘁𝗴𝗿𝗲𝗦𝗤𝗟 𝗱𝗼𝗰𝘂𝗺𝗲𝗻𝘁𝗮𝘁𝗶𝗼𝗻
📌 Data Types ⇒ https://www.postgresql.org/docs/curre...
📌 Functions & Operators ⇒ https://www.postgresql.org/docs/curre...
🐯 𝗔𝗯𝗼𝘂𝘁 𝗧𝗶𝗺𝗲𝘀𝗰𝗮𝗹𝗲
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
🔍 Sign up for Timescale Cloud for free ⇒ https://tsdb.co/ts-cloud-signup
📚 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀:
⏱ 0:00 ⇒ Introduction
⏱ 2:13 ⇒ A quick recap
⏱ 3:56 ⇒ A scenario
⏱ 5:18 ⇒ Source & homework
⏱ 9:32 ⇒ What is a schema?
⏱ 11:26 ⇒ Demo in psql
⏱ 15:16 ⇒ Agenda
⏱ 16:21 ⇒ psql terminology and how to explore schemas (of both kinds)
⏱ 29:23 ⇒ Schema qualification & dot notation
⏱ 32:50 ⇒ PostgreSQL documentation introduction & tour
⏱ 34:50 ⇒ Data types / composite types
⏱ 53:23 ⇒ NULLs / filtering / not null constraints
⏱ 1:03:06 ⇒ Other types of constraints (UNIQUE/PRIMARY KEY)
⏱ 1:12:50 ⇒ What's next?
⏱ 1:13:10 ⇒ Outro
#database #sql #postgresql #psql #data #datatables #datatypes #schema #NULL #NULLif #NULLconstraints #sqlstatements #dataquerylanguage #DBMS #aggregates #join #createtable
Смотрите видео Lesson 2, Using psql to Explore a PostgreSQL Database онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Timescale 10 Март 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 2,812 раз и оно понравилось 36 людям.