Data 101 (Info 258): Data Engineering 💾

UC Berkeley, Spring 2025

Ed Lecture Recordings Gradescope Additional Extensions

Professor Aditya Parameswaran

He/Him

adityagp@berkeley.edu

Announcements

← Previous Week Next Week →

Week 10 Announcement

Mar 24

Week 9 Announcement

Mar 17

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

See Week 9 Ed announcement.

Week 8 Announcement

Mar 10

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

See Week 8 Ed announcement.

Week 7 Announcement

Mar 3

Project 2 is due this Wednesday! Be sure to read the Midterm Logistics post as well.

See Week 7 Ed announcement.

Week 6 Announcement

Feb 24

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

See Week 6 Ed announcement.

Week 5 Announcement

Feb 17

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

See Week 5 Ed announcement.

Week 4 Announcement

Feb 10

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

See Week 5 Ed announcement.

Week 3 Announcement

Feb 3

Project 0 is due this Friday and Homework 1 is released!

See Week 3 Ed announcement.

Week 2 Announcement

Jan 27

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. We’ve released the Data Scholars Interest Form
4. Project 0 is due Friday 2/7 at 5pm.
5. Homework 1 will be released on Gradescope on Friday 1/31 and is due on Wednesday 2/12 at 5pm.
6. Lecture attendance starts this week!
7. Discussion sections will start on Thursday and Friday. You can find specific hours on the calendar.

Week 1 Announcement

Jan 20

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

Week 0 Announcement

Jan 18

Welcome to data engineering! Check back on this site for more updates

Schedule

Week 1

Tue 1/21

Lecture 1 Introduction, Data Engineering Lifecycle

Pre-Semester Form

Thu 1/23

Lecture 2 SQL Review

Course Notes

Fri 1/24

Project 0 SQL Review

Due Fri 2/7, 5pm

Week 2

Tue 1/28

Lecture 3 SQL Review (continued), Relational Model & Algebra

Course Notes

Thu 1/30

Lecture 4 Relational Algebra (continued), CTEs, Views, Subqueries

Course Notes

Discussion 1 SQL Review

Code, Solution

Fri 1/31

Homework 1 Homework 1

Due Wed 2/12, 5pm

Week 3

Tue 2/4

Lecture 5 DML, DDL, Referential Integrity, Constraints

Course Notes

Thu 2/6

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

Course Notes

Discussion 2 Relational Algebra, Subqueries, CTEs, Joins

Solution

Fri 2/7

Project 0 Due, 5pm

Project 1 SQL

Due Wed 2/19, 5pm

Week 4

Tue 2/11

Lecture 7 Optimizing for Performance I

Course Notes

Wed 2/12

Homework 1 Due, 5pm

Thu 2/13

Lecture 8 Optimizing for Performance II

Course Notes

Discussion 3 DML/DDL, Bits Conversion, Query Performance

Solution, Code

Fri 2/14

Homework 2 Homework 2

Due Wed 2/26, 5pm

Week 5

Tue 2/18

Lecture 9 Optimizing for Performance III

Course Notes

Wed 2/19

Project 1 Due, 5pm

Thu 2/20

Lecture 10 Data Modeling I

Course Notes

Discussion 4 Query Performance

Solution, Code

Fri 2/21

Project 2 Query Performance

Due Wed 3/5, 5pm

Week 6

Tue 2/25

Lecture 11 Data Preparation I: Structural

Course Notes

Wed 2/26

Homework 2 Due, 5pm

Thu 2/27

Lecture 12 Data Preparation II: Numerical, Granularity, Window Functions

Course Notes

Discussion 5 Data Models, Data Preparation

Solution, Code

Fri 2/28

Homework 3 Homework 3

Due Wed 3/19, 5pm

Week 7

Tue 3/4

Lecture 13 Data Preparation III: Outliers

Course Notes

Wed 3/5

Project 2 Due, 5pm

Thu 3/6

Lecture 14 Data Preparation IV: Imputation, Entity Resolution

Course Notes

Discussion 6 Window Functions, Data Granularity

Solution, Code

Week 8

Tue 3/11

Lecture 15 Data Preparation IV: Imputation, Entity Resolution (Cont.)

Course Notes
Mid-Semester Form

Wed 3/12

Midterm Midterm Exam (6-8pm)

Thu 3/13

Lecture No Lecture

Discussion No Discussion

Week 9

Tue 3/18

Lecture No Lecture

Wed 3/19

Homework 3 Due, 5pm

Thu 3/20

Lecture 16 Data Modeling II: Normalization + ER

Discussion 7 Entity Resolution, ER Diagram, Hampel X84

Solution, Code

Fri 3/21

Project 3 Data Transformation

Due Fri 4/4, 5pm

Week 10

All Week

Spring Break

Week 11

Mon 3/31

Homework 4 Homework 4

Due Wed 4/9, 5pm

Tue 4/1

Lecture 17 Semistructured Data: NoSQL, JSON, XML

Thu 4/3

Lecture 18 MongoDB I

Discussion 8 TBA

Solution

Fri 4/4

Project 3 Due, 5pm

Project 4 Mongo

Due Wed 4/16, 5pm

Project 5 Optional* Final Project

Checkpoint due Mon 4/21, 5pm
Final Report due Fri 5/2, 5pm

Week 12

Tue 4/5

Lecture 19 MongoDB II

Wed 4/6

Homework 4 Due, 5pm

Thu 4/7

Lecture 20 Data Ops and Pipelines

Discussion 9 TBA

Solution

Week 13

Tue 4/15

Lecture 21 MapReduce, Sampling

Wed 4/16

Project 4 Due, 5pm

Thu 4/17

Lecture 22 Transactions, BI, OLAP

Fri 4/18

Homework 5 Homework 5

Due Wed 4/30, 5pm

Week 14

Mon 4/21

Project 5 Checkpoint due, 5pm

Tue 4/22

Lecture 23 Transactions, BI, OLAP

Thu 4/24

Lecture 24 Spreadsheets

Discussion 10 TBA

Solution

Week 15

Tue 4/29

Lecture 25 Parallel and Distributed Computing, CAP Theorem, VMs

End-of-Semester Form

Wed 4/30

Homework 5 Due, 5pm

Thu 5/1

Lecture 26 Graphs Databases and Knowledge Bases

Fri 5/2

Project 5 Final Report due, 5pm

RRR Week

All Week

RRR Week

Finals Week

Wed 5/14

Final Final Exam (11:30am-2:30pm)