Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Relational Model and Algebra - Introduction to Database Systems - Lecture 1

CMU Database Group via YouTube

Overview

Dive into the fundamentals of database systems with this comprehensive lecture on the Relational Model and Algebra from Carnegie Mellon University's Intro to Database Systems course. Explore key concepts including data models, primary and foreign keys, constraints, and relational algebra operators. Learn about the differences between relational models and databases, understand database implementation issues, and gain insights into SQL Server. Taught by Professor Andy Pavlo, this video lecture provides a solid foundation for understanding database systems, complete with practical examples and in-depth explanations of core database concepts.

Syllabus

Introduction
Core Sponsor
waitlist
Announcements
I am from Baltimore
Logistics
Agenda
SQL Server
Relational Model vs Database
Database Example
Database Implementation Issues
Why this course
Data Model
Data Models
Relation Model
Primary Key
Foreign Keys
Constraints
Interaction
Algebra
Select
Projection
Operators
Cross
Join
Rename

Taught by

CMU Database Group

Reviews

Start your review of Relational Model and Algebra - Introduction to Database Systems - Lecture 1

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.