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

preview_player
Показать описание

15-445/645 Intro to Database Systems (Fall 2024)
Carnegie Mellon University
  1. CMU Database Group
  2. databases
  3. carnegie mellon university
Рекомендации по теме
Introduction to Relational 0:06:53

Introduction to Relational Data Model

01 - Relational 1:19:39

01 - Relational Model & Relational Algebra (CMU Intro to Database Systems / Fall 2022)

01 - Course 1:06:44

01 - Course Introduction & Relational Model (CMU Databases Systems / Fall 2019)

01 - Course 1:13:34

01 - Course Introduction & Relational Model (CMU Intro to Database Systems / Fall 2021)

What is a 0:07:54

What is a Relational Database?

DBMS 1 to 0:05:32

DBMS 1 to many,many to many,1 to 1 relationships

Relational Database Concepts 0:05:25

Relational Database Concepts

Introduction to Relational 0:12:08

Introduction to Relational Databases

01- Intro to 2:00:45

01- Intro to Database & DBMS, Oracle installation, Simple Oracle queries

Relational Database Relationships 0:06:19

Relational Database Relationships (Updated)

Relational Database 0:03:28

Relational Database

Introduction to Data 0:16:24

Introduction to Data Models

CMU Database Systems 1:07:29

CMU Database Systems - 01 Course introduction & Relational Data Model (Fall 2018)

CMU Database Systems 0:50:06

CMU Database Systems - 01 Course introduction & Relational Data Model (Fall 2017)

Relational Model Constraints 0:12:48

Relational Model Constraints

Basic Concepts of 0:08:49

Basic Concepts of Entity-Relationship Model

Lec 01: Relational 0:45:14

Lec 01: Relational Development and Maintenance - I

Introduction to Relational 0:31:45

Introduction to Relational Model/1

3. What is 0:12:14

3. What is a data model? Hierarchical | Network | Relational | Entity-relationship model

Relational Model in 0:11:26

Relational Model in DBMS || Data Base Management Systems

Exercises based on 0:12:29

Exercises based on Relational Model (Part 1)

SQL Server Tutorial 0:09:51

SQL Server Tutorial - One-to-many and many-to-many table relationships

NoSQL vs SQL: 0:00:45

NoSQL vs SQL: What's better?

Basics of Relational 0:07:53

Basics of Relational Algebra

Комментарии
Автор

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.

CalifornianViking
Автор

Just discovered this and I'm hyped!

Rohinthas
Автор

That intro is 🔥 hahaha

Great course, actually way better than the one I had on my uni here in Brazil

MrDaniloko
Автор

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

karthicksridhar
Автор

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)

sultgky
Автор

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

LanceEnglandSQL
Автор

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

mephistotel
Автор

woulda loved the hot takes on database companies

humaidkidwai
Автор

I’ll watch despite your political ignorance

LanceEnglandSQL