Data 101 (CS 187): Data Engineering 💾

UC Berkeley, Fall 2026

Ed Jump to Current Week

Professor Aditya ParameswaranHe/Him/His

adityagp@berkeley.edu

Schedule

Week 1

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

Week 2

Tue, Sep 01	No Lecture - Aditya at VLDB — SQL Review (Makeup Tue 9/8)
Thu, Sep 03	No Lecture - Aditya at VLDB — Relational Model & Algebra (Makeup Thu 9/10)
Fri, Sep 04	Discussion 1SQL Review (Solutions) Homework 1Homework 1 (due 9/16)

Week 3

Tue, Sep 08	Lecture 2SQL Review
Thu, Sep 10	Lecture 3Relational Model & Algebra
Fri, Sep 11	Lecture 4 CTEs, Views, Subqueries Lecture 5 DML, DDL, Referential Integrity, Constraints (Special Makeup Lecture, 12-2:30pm in Gateway 1210 — note the different location) Discussion 2Relational Algebra, Subqueries, CTEs, Joins (Solutions) Project 1Project 1 (due 9/23)

Week 4

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

Week 5

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

Week 6

Tue, Sep 29	Lecture 10Data Preparation I: Structural Transformations
Thu, Oct 01	Lecture 11Data Preparation II: Numerical, Granularity, Windows
Fri, Oct 02	Exam Midterm I, 7-9pm No Discussion - Midterm I

Week 7

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

Week 8

Tue, Oct 13	Lecture 14Data Modeling II: Normalization + ER
Thu, Oct 15	Lecture 15Semistructured Data
Fri, Oct 16	Discussion 6Window Functions, Data Granularity

Week 9

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

Week 10

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

Week 11

Tue, Nov 03	Lecture 20Data Ops and Pipelines
Thu, Nov 05	Lecture 21Transactions
Fri, Nov 06	Exam Midterm II, 7-9pm No Discussion - Midterm II Project 4Project 4 (due 11/18)

Week 12

Tue, Nov 10	Lecture 22BI, OLAP
Thu, Nov 12	Lecture 23Spreadsheets
Fri, Nov 13	Discussion 9Sampling, MapReduce

Week 13

Tue, Nov 17	Lecture 24Graph Databases
Thu, Nov 19	Lecture 25Cloud Computing
Fri, Nov 20	Discussion 10Parallel Processing, Data Ops Homework 5Homework 5 (due 12/2)

Week 14

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

Week 15

Tue, Dec 01	Lecture 27TBA
Thu, Dec 03	Lecture 28TBA
Fri, Dec 04	Discussion 11Transactions, OLAP, Spreadsheets, and Graph DB

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	Exam Final Exam, 8-11am