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
Watch video Lesson 2, Using psql to Explore a PostgreSQL Database online without registration, duration hours minute second in high quality. This video was added by user Timescale 10 March 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,81 once and liked it 3 people.