Lesson 1, PostgreSQL 101: Tables and Data Queries With PostgreSQL

Get an overview of database fundamentals, including aggregates and joins, creating tables and inserting data, creating views... and much more!

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.

🛠 𝗥𝗲𝗹𝗲𝘃𝗮𝗻𝘁 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀
📌 Lesson 1 Presentation Slides: https://tsdb.co/lesson-1-slides
📌 Watch Lesson 0: https://youtu.be/JOrXRsES3mk
📌 Foundations of PostgreSQL & TimescaleDB course playlist ⇒ https://www.youtube.com/playlist?list=PLsceB9ac9MHRnmNZrCn_TWkUrCBCPR3mc
📌 Stonebraker & Hellerstein 2005. What Goes Around Comes Around ⇒ https://people.cs.umass.edu/~yanlei/courses/CS691LL-f06/papers/SH05.pdf
📌 Sign up for Timescale Cloud for free ⇒ https://tsdb.co/ts-cloud-signup

🐯 𝗔𝗯𝗼𝘂𝘁 𝗧𝗶𝗺𝗲𝘀𝗰𝗮𝗹𝗲
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

📚 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀:
⏱ 0:00 ⇒ Introduction
⏱ 4:19 ⇒ Data sampling
⏱ 7:05 ⇒ Data wrangling
⏱ 11:02 ⇒ Creating tables
⏱ 13:30 ⇒ Inserting data with INSERT INTO
⏱ 14:22 ⇒ Looking at data with SELECT & FROM
⏱ 17:08 ⇒ Using data aggregates
⏱ 18:03 ⇒ Create a view
⏱ 19:05 ⇒ Join tables with JOIN
⏱ 22:20 ⇒ Conditional statements with WHERE
⏱ 24:00 ⇒ Terminology
⏱ 40:15 ⇒ History of the English language
⏱ 44:50 ⇒ More history (of relational databases)
⏱ 57:46 ⇒ Some homework
⏱ 59:03 ⇒ Outro

#database #sql #postgresql #psql #data #datatables #sqlstatements #dataquerylanguage #DBMS #aggregates #join #createtable

Видео Lesson 1, PostgreSQL 101: Tables and Data Queries With PostgreSQL канала Timescale