Data 101 (CS 187): Data Engineering 💾

UC Berkeley, Fall 2026

Ed Office Hours Queue Jump to Current Week

Professor Aditya ParameswaranHe/Him/His

adityagp@berkeley.edu

Announcements

← Previous Week Announcements Next Week →

Schedule

Week 1: Introduction

Thu, Aug 27	Lecture 1 Introduction, Data Engineering Lifecycle
Fri, Aug 28	Project 0Project 0 (due 9/9)

Week 2

Tue, Sep 01	Lecture 2 SQL Review
Thu, Sep 03	Lecture 3 Relational Model & Algebra
Fri, Sep 04	Discussion 1SQL Review Homework 1Homework 1 (due 9/16)

Week 3: Pandas and API

Tue, Sep 08	Lecture 4 CTEs, Views, Subqueries
Thu, Sep 10	Lecture 5 DML, DDL, Referential Integrity, Constraints
Fri, Sep 11	Discussion 2Relational Algebra, Subqueries, CTEs, Joins Project 1Project 1 (due 9/23)

Week 4: Surveys and RCTs

Tue, Sep 15	Lecture 6 Performance and Index Selection
Thu, Sep 17	Lecture 7 Optimizing for Performance I
Fri, Sep 18	Discussion 3DML/DDL, Bits, Query Performance Homework 2Homework 2 (due 9/30)

Week 5: Visualization

Tue, Sep 22	Lecture 8 Optimizing for Performance II
Thu, Sep 24	Lecture 9 Data Modeling I: Relations, Tensors, Dataframes
Fri, Sep 25	Discussion 4Query Performance Project 2Project 2 (due 10/7)

Week 6

Tue, Sep 29	Lecture 10 Data Preparation I: Structural Transformations
Thu, Oct 01	Lecture 11 Data Preparation II: Numerical, Granularity, Windows
Fri, Oct 02	Discussion 5Data Models, Data Prep

Week 7

Mon, Oct 05	Homework 3Homework 3 (due 10/21)
Tue, Oct 06	Lecture 12 Data Preparation III: Outliers
Thu, Oct 08	Lecture 13 Data Preparation IV: Entity Resolution
Fri, Oct 09	Discussion 6Window Functions, Data Granularity

Week 8

Tue, Oct 13	Lecture 14 Data Modeling II: Normalization + ER
Thu, Oct 15	Lecture 15 Semistructured Data
Fri, Oct 16	No discussion

Week 9

Tue, Oct 20	Lecture 16 MongoDB I
Thu, Oct 22	Lecture 17 MongoDB II
Fri, Oct 23	Discussion 7Entity Resolution, ER Diagrams, Normalization Project 3Project 3 (due 11/4)

Week 10

Tue, Oct 27	Lecture 18 Sampling, MapReduce
Thu, Oct 29	Lecture 19 Parallel and Distributed Computing
Fri, Oct 30	Discussion 8Semistructured Data, MongoDB Homework 4Homework 4 (due 11/11)

Week 11

Tue, Nov 03	Lecture 20 Data Ops and Pipelines
Thu, Nov 05	Lecture 21 Transactions
Fri, Nov 06	Discussion 9Sampling, MapReduce Project 4Project 4 (due 11/18)

Week 12

Tue, Nov 10	Lecture 22 BI, OLAP
Thu, Nov 12	Lecture 23 Spreadsheets
Fri, Nov 13	Discussion 10Parallel Processing, Data Ops

Week 13

Tue, Nov 17	Lecture 24 Graph Databases
Thu, Nov 19	Lecture 25 Cloud Computing
Fri, Nov 20	Discussion 11Transactions Homework 5Homework 5 (due 12/2)

Week 14

Tue, Nov 24	Lecture 26 TBA
Thu, Nov 26	Holiday - No Lecture
Fri, Nov 27	Discussion 12TBA

Week 15

Tue, Dec 01	Lecture 27 TBA
Thu, Dec 03	Lecture 28 TBA
Fri, Dec 04	Discussion 13TBA

Week 16

Tue, Dec 08	RRR Week
Thu, Dec 10	RRR Week
Fri, Dec 11	RRR Week

Week 17

Tue, Dec 15	Finals Week
Thu, Dec 17	Finals Week
Fri, Dec 18	Finals Week