Data 101 (CS 187): Data Engineering 💾

UC Berkeley, Fall 2025

Ed Gradescope Lecture Recordings Additional Extensions Jump to Current Week

Professor Aditya Parameswaran

He/Him

adityagp@berkeley.edu

Announcements

← Previous Week Next Week →

Week 4 Announcement

Sep 15

1. Homework 1 is due this Wednesday! Project 1 is also released.

Week 3 Announcement

Sep 8

1. Project 0 is due this Wednesday (9/10) and Homework 1 has been released!
2. See the Week 3 Ed announcement

Week 2 Announcement

Sep 1

1. Welcome to back to the second week of classes! See Week 02 Announcements on Ed.
2. Office hours start this week at Warren 101B!
3. Project 0 is due Wednesday 9/10 at 5pm.
4. Homework 1 will be released on Gradescope on Friday 9/5 and is due on Wednesday 9/17 at 5pm.
5. Discussion sections will start on Thursday and Friday. You can find specific hours on the calendar.

Week 1 Announcement

Aug 25

1. Welcome to Data 101!
2. Sections start next Thursday 9/4 and Friday 9/5. Join us for a review of SQL, and meet some study partners!
3. Sections times/locations will be updated on the calendar by the end of the weekend.
4. Office hours start next week! You can find the times and locations on the calendar.
5. Please make sure to check the “Welcome to Data C101 / Compsci 187!” post on Ed! This details the Pre-Semester survey and other logistics.
6. Check out our cool logo (top left) designed by one of our former TA’s, Li Zhang!

Week 0 Announcement

Aug 18

Welcome to DATA C101: data engineering! Check back on this site for more updates. Information on this site is not final until the first day of class.

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)

Course Notes

Thu 9/4

Lecture 3 Relational Model & Algebra (at VLDB; recorded 8/29)

Course Notes

Discussion 1 SQL Review

Code, Solution

Fri 9/5

Homework 1 Homework 1

Due Wed 9/17, 5pm

Week 3

Tue 9/9

Lecture 4a CTEs, Views, Subqueries

Course Notes

Lecture 4b DML, DDL, Referential Integrity, Constraints

Course Notes

Wed 9/10

Project 0 Due, 5pm

Thu 9/11

Lecture 5a DML, DDL, Referential Integrity, Constraints

Lecture 5b Bits/memory model, Performance Tuning, Index Selection

Course Notes

Discussion 2 Relational Algebra, Subqueries, CTEs

Solution

Fri 9/12

Project 1 SQL

Due Wed 9/24, 5pm

Week 4

Tue 9/16

Lecture 6a Bits/memory model, Performance Tuning, Index Selection

Lecture 6b Optimizing for Performance I - Logical

Course Notes

Wed 9/17

Homework 1 Due, 5pm

Thu 9/18

Lecture 7a Optimizing for Performance I - Logical

Lecture 7b Optimizing for Performance II

Course Notes

Discussion 3 DML/DDL, Cascade, Bits, Query Performance

Code, Solution

Fri 9/19

Homework 2 Homework 2

Due Wed 10/1, 5pm

Week 5

Tue 9/23

Lecture 8 Optimizing for Performance II

Wed 9/24

Project 1 Due, 5pm

Thu 9/25

Lecture 9 Data Modeling I

Discussion 4 Query Performance

Code

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)