01 - Course Introduction & Relational Model (CMU Databases Systems / Fall 2019)
Channel:CMU Database Group · Length:1:06:44 · Published:2019-08-28 · Views:248265
Summary
The first lecture of Andy Pavlo's CMU 15-445 Intro to Database Systems (Fall 2019), covering course introduction and the relational model.
Why HN recommends it
Frequently recommended as the best free university course on database internals, praised for depth and Pavlo's presentation.
Highly recommended both for the depth and how Andy Pavlo presents the topic. — HN, 2020
Databases & storage · University lectures & courses
Subtitles (excerpt)
[Music] welcome to News EMU 1545 6:45 introduction to database systems my name is Andy I'm the instructor for this course as I said on Piazza I can't be in Pittsburgh right now we are getting ready for Matt's cage fight on Wednesday so we had to be out here in LA to prepare for that fight so rather than just not having classes this entire first week I wanted to record this while I'm on the road posted online and then that way when we start having in-class lectures next week we can get started on the good stuff so before we get into today's lecture I first want to talk about how Oracle is helping us out this semester with course of course development so Oracle is actually won the first relational database management systems that came out in the 1970s and I'll explain what a relational database is in a few slides there's one of the original ones but it's still widely used and sold today right it's probably the second most deployed database system in the world it's certainly the most deployed commercial system in the world and so even though it's from the 1970s and there's other systems of the 1970s that are still sort of around or was actually still under active development and they're adding a lot of you know interesting new modern
On Hacker News
[VIDEO] There are multiple years available for his first DB class but that’s the one I watched. I almost called it his ‘basic’ class but there’s literally only like one or two classes on SQL before he dives into all the various layers of the internals. There’s also a few of his advanced courses. And then you’ll see guest lectures from industry on about every one of the new DB platforms you can th… — runlaszlorun, 2023-04
Obligatory recommendation for the CMU Databases Systems lecture series by Andy Pavlo. [VIDEO] Here's the lecture on tree indexes: [LINK] — maxmcd, 2022-03
Agreed. I finished watching them at the start of this year and it's significantly helped me in using and making choices about databases. I've also since started implementing my own database for learning off the back of them. Couldn't be more grateful for those courses being public. link if anyone is interested: [VIDEO] — alistairw, 2021-04
I'd start with CMU's "Intro to Database Systems", their lectures are on youtube. Highly recommended both for the depth and how Andy Pavlo presents the topic. [VIDEO] — ptr, 2020-01
Intro to Database Systems by Andy Pavlo - [VIDEO] MIT 6.824 Distributed Systems by Robert Morris - [LINK] Designing Data-Intensive Applications (DDIA) - [LINK] Crafting Interpreters - [LINK] — avinassh, 2023-08
Related videos
- Distributed Systems 1.1: Introduction · Martin Kleppmann · 14:35
- Lecture 1: Introduction · MIT 6.824: Distributed Systems · 1:19:35
- "Turning the database inside out with Apache Samza" by Martin Kleppmann · Strange Loop Conference · 47:42
- Preface | MIT Calculus Revisited: Single Variable Calculus · MIT OpenCourseWare · 32:06
- How to Speak · MIT OpenCourseWare · 1:03:42
- 1. Introduction to Human Behavioral Biology · Stanford · 57:14
- LEADERSHIP LAB: The Craft of Writing Effectively · UChicago Social Sciences · 1:21:51
- MIT's Pathway to Fusion Energy (IAP 2017) - Zach Hartwig · MIT Plasma Science and Fusion Center · 1:11:39
- Stanford's Sapolsky On Depression in U.S. (Full Lecture) · Stanford · 52:28
- Justice: What's The Right Thing To Do? Episode 01 "THE MORAL SIDE OF MURDER" · Harvard University · 54:56
- Lec 1 | MIT 18.06 Linear Algebra, Spring 2005 · MIT OpenCourseWare · 39:49
- "Testing Distributed Systems w/ Deterministic Simulation" by Will Wilson · Strange Loop Conference · 40:20
- The Value of Values with Rich Hickey · InfoQ · 31:43
- Randy Pausch's Last Lecture: Achieving Your Childhood Dreams · Carnegie Mellon University · 1:16:27
- Lecture 1A: Overview and Introduction to Lisp · MIT OpenCourseWare · 1:12:55
- Lecture 1A | MIT 6.001 Structure and Interpretation, 1986 · MIT OpenCourseWare · 1:12:55