#01 - Relational Model & Algebra (CMU Intro to Database Systems)

[@CalifornianViking]

This lecture series is incredibly good. Thank you, Professor Andy Pavlo. I have been preaching the same for decades. I love how honest you are (blockchain) and how you cut through the distractions of document databases, graph databases, and vector databases, which are just modeling techniques in multi modal databases like Postgres. I love Postgres and the culture that surrounds it.

[@rammrras9683]

I've never understood document databases hype

[@Rohinthas]

Just discovered this and I'm hyped!

[@MrDaniloko23]

That intro is 🔥 hahaha Great course, actually way better than the one I had on my uni here in Brazil

[@karthicksridhar840]

At 53:15 , UNION - removes duplicates. UNION ALL - keeps the duplicates.

[@LanceEnglandSQL]

Min 53 he has the definitions of UNION and UNION ALL backwards.UNIONS removes duplicates and UNION ALL keeps them.

[@user-su6lt4gk8y]

Seeing this on a Sunday evening. This is so nice. I wish to see how individual people can contribute to DB engines (and the list of business problems related to DB engines; not just some consulting CRUD work)

[@hariikrishnan]

A lot to unpack from that intro lol

[@humaidkidwai]

woulda loved the hot takes on database companies

[@mephistotel87]

"The most tested and reliable software in the world" ... can easily loose your data on primary key update.

[@rosendo3219]

what is the beef with enterprisedb ?

[@MohammadhosseinMalekpour]

Amazing!

[@ivan.jeremic]

wow... just wow... the world is ......😢

[@LanceEnglandSQL]

I’ll watch despite your political ignorance

[@urmom8322]

wah wah wah

[@Simas1234]

Imagine his relief

[@LanceEnglandSQL]

@@Simas1234 Yeah, I know he could not care less. I just get sick of the leftist crap

[@Simas1234]

Save it for your therapist

[@LanceEnglandSQL]

@@Simas1234 nah, complaining on KZbin costs less