#02 - Modern SQL (CMU Intro to Database Systems)

[@billywojcicki]

Thanks for repeating students' questions into the mic. Very helpful for us online listeners who cannot hear them!

[@Rohinthas]

Love the presentation style!

[@vincentjacquet2927]

At 34:25, if you type SELECT CAST(DATE('2024-08-28') AS int) in mysql, it returns 20240828, which is a decimal representation of the date. 20240828-20240101=727. So, my guess is that dates are coerced to int before substracting them.

[@PianoSkillBoy]

Intro makes me wanna enroll

[@JetLagRecords]

CMU Database Group, wanna collab it was really entertaining

[@christianstork1049]

What Google paper is he talking about at 6:42 ?

[@phantruong1217]

“SQL Has Problems. We Can Fix Them: Pipe Syntax In SQL“ 2024

[@vinimdocarmo]

Notes link in the description is broken

[@hdrkn5247]

that intro is fire🔥🔥🔥

[@omarbousbia6916]

really nice course, good presentation skills

[@BAHO39rus]

Everyone is so delighted about intro, but anyone saw the outro? It's a fire too tho

[@daver94]

Amazing! Thank u

[@muxintian8110]

what software to choose so many database?

[@utyubish]

The link to the Notes section is not working.

[@BRUNORABELLOMONTEIRO]

Does anyone know which CLI interface Pavlo is using in the prompt?

[@simpleandminimalmaybe]

SmarTTY

[@offYears]

the thumbnail tells me most of this class refers to women as 'females' 👍

[@zartajmajeed]

28:37 is wrong - select now() works in duckdb - now() is documented in Timestamp with Time Zone Functions - syntax error at or near "" suggests duckdb repl was messed up from previous error