Data 101 (CS 187): Data Engineering 💾
UC Berkeley, Fall 2025
Ed Gradescope Lecture Recordings Additional Extensions Jump to Current Week
Announcements
Week 1 Announcement
- Welcome to Data 101!
- Sections start next Thursday 9/4 and Friday 9/5. Join us for a review of SQL, and meet some study partners!
- Sections times/locations will be updated on the calendar by the end of the weekend.
- Office hours start next week! You can find the times and locations on the calendar.
- Please make sure to check the “Welcome to Data C101 / Compsci 187!” post on Ed! This details the Pre-Semester survey and other logistics.
- Check out our cool logo (top left) designed by one of our former TA’s, Li Zhang!
Schedule
Week 1
- Thu 8/28
- Lecture 1 Introduction, Data Engineering Lifecycle
- Fri 8/29
-
- Project 0 SQL Review
- Due Wed 9/10, 5pm
Week 2
- Tue 9/2
- Lecture 2 SQL Review (at VLDB; recorded 8/29)
- Thu 9/4
- Lecture 3 Relational Model & Algebra (at VLDB; recorded 8/29)
-
- Discussion 1 SQL Review
- Code
- Fri 9/5
-
- Homework 1 Homework 1
- Due Wed 9/17, 5pm
Week 3
- Tue 9/9
- Lecture 4 CTEs, Views, Subqueries
- Wed 9/10
- Project 0 Due, 5pm
- Thu 9/11
- Lecture 5 DML, DDL, Referential Integrity, Constraints
- Discussion 2 Relational Algebra, Subqueries, CTEs, Joins
- Fri 9/12
-
- Project 1 SQL
- Due Wed 9/24, 5pm
Week 4
- Tue 9/16
- Lecture 6 Optimizing for Performance I
- Wed 9/17
- Homework 1 Due, 5pm
- Thu 9/18
- Lecture 7 Optimizing for Performance II
- Discussion 3 DML/DDL, Bits, Query Performance
- Fri 9/19
-
- Homework 2 Homework 2
- Due Wed 10/1, 5pm
Week 5
- Tue 9/23
- Lecture 8 Optimizing for Performance III
- Wed 9/24
- Project 1 Due, 5pm
- Thu 9/25
- Lecture 9 Data Modeling I
- Discussion 4 Query Performance
- Fri 9/26
-
- Project 2 Query Performance
- Due Wed 10/8, 5pm
Week 6
- Tue 9/30
- Lecture 10 Data Preparation I: Structural
- Wed 10/1
- Homework 2 Due, 5pm
- Thu 10/2
- Lecture 11 Data Preparation II: Numerical, Granularity, Window Functions
- Discussion 5 Data Models, Data Preparation
- Fri 10/3
-
- Homework 3 Homework 3
- Due Wed 10/22, 5pm
Week 7
- Tue 10/7
- Lecture 11 TBA
- Wed 10/8
- Project 2 Due, 5pm
- Thu 10/9
- Lecture 12 TBA
- Discussion 6 Window Functions, Data Granularity
Week 8
- Tue 10/14
- Lecture 13 TBA
- Thu 10/16
- Lecture 13b TBA
- Midterm Midterm Exam (7-9pm)
Week 9
- Tue 10/21
- Lecture 14 TBA
- Wed 10/22
- Homework 3 Due, 5pm
- Thu 10/23
- Lecture 15 TBA
- Discussion 7
- Fri 10/24
-
- Project 3
- Due Wed 11/5, 5pm
Week 10
- Tue 10/28
- Lecture 16 TBA
- Thu 10/30
- Lecture 17 TBA
- Discussion 8
- Fri 10/31
-
- Homework 4 Homework 4
- Due Wed 11/12, 5pm
Week 11
- Tue 11/4
- Lecture 18 TBA
- Wed 11/5
- Project 3 Due 5pm
- Thu 11/6
- Lecture 19 TBA
- Discussion 9
- Fri 11/7
-
- Project 4
- Due Wed 11/19 5pm
Week 12
- Tue 11/12
- Lecture 20 TBA
- Wed 11/13
- Homework 4 Due 5pm
- Thu 11/14
- Lecture 21 TBA
- Discussion 10
Week 13
- Tue 11/18
- Lecture 22 TBA
- Weds 11/19
- Project 4 Due 5pm
- Thu 11/20
- Lecture 23 TBA
- Discussion 11
- Fri 11/21
-
- Homework 5 Homework 5
- Due Weds 12/3, 5pm
Week 14
- Tue 11/25
- Lecture 24 TBA
- Thu 11/27
- Lecture Holiday: No Lecture
Week 15
- Tue 12/2
- Lecture 25 TBA
- Wed 12/3
- Homework 5 Due 5pm
- Thu 12/4
- Lecture 26 TBA
- Discussion 12
Week 16
- All Week
- RRR Week
Week 17
- All Week
- Finals Week
- Tu 12/16
- Final Final Exam (8-11am)