Data 101 (CS 187): Data Engineering 💾

UC Berkeley, Fall 2025

Ed Gradescope Lecture Recordings Additional Extensions Office Hours Queue Jump to Current Week

Professor Aditya Parameswaran

He/Him

adityagp@berkeley.edu

Announcements

← Previous Week Next Week →

Week 13 Announcement

Nov 17

1. Project 4 has been released and will be due this Saturday 11/22 @ 5pm
2. Homework 5 has been released and will be due on Wednesday 12/3 @ 5pm

Week 12 Announcement

Nov 10

1. Project 4 has been released and will be due on Saturday 11/22!
2. There is no class on Tuesday
3. Homework 5 will be released this Friday

Week 11 Announcement

Nov 1

1. Project 3 is due this Friday 11/7!
2. Homework 4 was been released Friday 10/31 and will be due next Wednesday 11/13.

Week 10 Announcement

Oct 27

1. Project 3 is due next Friday 11/7!
2. Homework 4 will be released on Friday 10/31 and will be due Wednesday 11/13.

See the Week 10 Ed announcement.

Week 9 Announcement

Oct 20

Homework 3 is due this Wednesday! Project 3 will also be released this week.

Week 8 Announcement

Oct 13

The midterm exam is this week! Be sure to read the Midterm Logistics post. Homework 3 was also released and is due next Wednesday.

Week 7 Announcement

Oct 6

1. Project 2 is due this Wednesday. Be sure to read the Midterm Logistics post as well.
2. Midterm Seating Assignments will be released by the end of this week!

Week 6 Announcement

Sep 29

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

See Week 6 Ed Announcement.

Week 5 Announcement

Sep 22

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

See Week 5 Ed announcement.

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, Solution

Fri 9/26

Project 2 Query Performance

Due Wed 10/8, 5pm

Week 6

Tue 9/30

Lecture 10 Data Preparation I: Structural Transformations

Wed 10/1

Homework 2 Due, 5pm

Thu 10/2

Lecture 11 Data Preparation II: Value Transformations

Discussion 5 Data Models, Data Preparation

Code, Solution

Fri 10/3

Homework 3 Homework 3

Due Wed 10/22, 5pm

Week 7

Tue 10/7

Lecture 12a Data Preparation II: Value Transformations

Lecture 12b Data Preparation III: Outliers and Imputation

Wed 10/8

Project 2 Due, 5pm

Thu 10/9

Lecture 13 Data Preparation III: Outliers and Imputation

Discussion 6 Window Functions, Data Granularity

Code, Solution

Week 8

Tue 10/14

Lecture 14a Data Preparation IV: Entity Resolution

Lecture 14b Data Modeling II: Normalization + ER

Thu 10/16

Lecture No Lecture

Discussion No Discussion

Midterm Midterm Exam (7-9pm)

Week 9

Tue 10/21

Lecture 15 Data Modeling II: Normalization + ER

Wed 10/22

Homework 3 Due, 5pm

Thu 10/23

Lecture 16a Semistructured Data

Lecture 16b MongoDB I

Discussion 7 Entity Resolution, ER Diagram, Normalization

Code, Solution

Fri 10/24

Project 3 Data Transformation

Due Fri 11/7, 5pm

Week 10

Tue 10/28

Lecture 17a Semistructured Data

Lecture 17b MongoDB I

Thu 10/30

Lecture 18 MongoDB II

Discussion 8 Semi-Structured Data, MongoDB

Solution

Fri 10/31

Homework 4 Homework 4

Due Wed 11/12, 5pm

Week 11

Tue 11/4

Lecture 19a Sampling

Lecture 19b MapReduce

Thu 11/6

Lecture 20 Parallel and Distributed Computing

Discussion 9 MapReduce, Sampling

Solution

Fri 11/7

Project 3 Due 5pm

Week 12

Mon 11/10

Project 4 Mongo

Due Sat 11/22 5pm

Tue 11/11

Lecture Holiday: No Lecture

Wed 11/12

Homework 4 Due 5pm

Thu 11/13

Lecture 21 Data Ops and Pipelines

Discussion 10 Parallel Processing, Data Ops

Solution

Week 13

Tue 11/18

Lecture 22a Data Ops and Pipelines

Lecture 22b Transactions

Weds 11/19

Project 4 Due 5pm

Thu 11/20

Lecture 23 BI, OLAP

Discussion 11 Transactions

Solution

Fri 11/21

Lecture 24 Spreadsheets (Special Makeup Lecture)

Homework 5 Homework 5

Due Weds 12/3, 5pm

Week 14

Tue 11/25

Lecture No Lecture (Made up 11/21)

Thu 11/27

Lecture Holiday: No Lecture

Week 15

Tue 12/2

Lecture 25 Graphs Databases and Knowledge Bases

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)