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/database-fundamentals-with-david-kohn-lesson-2-foundations-of-postgresql-and-timescaledb/356
? Foundations of PostgreSQL & TimescaleDB course playlist ⇒ https://tsdb.co/playlist-foundations-course
? postgres_air repo ⇒ https://github.com/hettie-d/postgres_air
? PostgreSQL documentation ⇒ https://www.postgresql.org/docs/current/index.html
????? ????? ?????? ?????????? ?????????????
? Data Types ⇒ https://www.postgresql.org/docs/current/datatype.html
? Functions & Operators ⇒ https://www.postgresql.org/docs/current/functions.html

? ????? ?????????
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 ⇒ https://twitter.com/timescaledb
? Twitch ⇒ https://www.twitch.tv/timescaledb
? LinkedIn ⇒ https://www.linkedin.com/company/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