Introduction to
Data Management

πŸ‘‹πŸ‘‹πŸ‘‹ Welcome πŸ‘‹πŸ‘‹πŸ‘‹! We are very excited to have you here; please get to know us at the staff info page and get to know the course at the syllabus.

Lectures: MWF, 9:30 - 10:20, in AND 223

  • First week: all three lectures will be online. Use the zoom link on canvas.

Sections:

  • AA Th 8:30 – 9:20 AM MGH 242

  • AB Th 9:30 – 10:20 AM SAV 156

  • AC Th10:30 – 11:20 AM JHN 175

  • AD Th 12:30 – 1:20 PM MEB 242

  • AE Th 9:30 – 10:20 AM SIG 226

The course calendar is here: we use it for lectures, sections, office hours, homework deadlines, and exams.

Lectures


See Canvas for the full list of lecture recordings

Week 1

Mon, Jan 3

2.1-2.3


Wed, Jan 5

6.1 - 6.2


Fri, Jan 7

Same (6.1 - 6.2)

Week 2

Mon, Jan 10

Same (6.1 - 6.2)


Fri, Jan 15

Subqueries: 6.3

Week 3

Mon, Jan 17

MLK Day -- no lecture



Wed, Jan 19

Lec07: Relational Algebra

2.4, 5.1-5.2


Fri, Jan 22

Lec08: Relational Algebra, cont

4.1-4.6

Week 4

Mon, Jan 24

Lec09: Logical Design with ER Diagrams

3.1-3.5


Wed, Jan 26

Lec10: Design Theory

18.1-18.2


Fri, Jan 29

Lec11: Transactions

18.3

Week 5

Mon, Jan 31

Lec12: Transactions (cont'd)



Wed, Feb 2

Midterm (in class)



Fri, Feb 4

Lec13: Transactions: Locks and Isolation Levels

18.4

15.1, 15.1.5, 15.3, 16.4-16.4.3

Week 6

Mon, Feb 7

Lec14: Performance Tuning: Cost Estimation

Same (15.1, 15.1.5, 15.3, 16.4-16.4.3)


Wed, Feb 9

Lec15: Performance Tuning: Indexes

8.3-8.4.3, 16.4.4


Fri, Feb 11

Lec16: Performance Tuning: Indexes (cont) and Performance Tuning: Query Tuning

N/A

Week 7

Mon, Feb 14

Lec17: Performance Tuning: Query Tuning and Data Governance

N/A


Wed, Feb 16

Lec18: Parallel Processing

N/A


Fri, Feb 18

Lec19: MapReduce and Spark

N/A

Week 8

Mon, Feb 21

Presidents' Day -- No lecture

N/A


Wed, Feb 23

Lec20: Introduction to NoSQL

N/A


Fri, Feb 25

TBD

N/A

Week 9

Mon, Feb 28

TBD

N/A


Wed, Mar 2

TBD

N/A


Fri, Mar 4

TBD

N/A

Week 10

Mon, Mar 7

TBD

N/A


Wed, Mar 8

TBD

N/A


Fri, Mar 11

TBD

N/A


Wed, Mar 16

Final

N/A

Sections


Week 1

Thu, Jan 6

N/A

Week 2

Thu, Jan 13

N/A

Week 3

Thu, Jan 20

TBD

N/A

Week 4

Thu, Jan 27

TBD

N/A

Week 5

Thu, Feb 3

TBD

N/A

Week 6

Thu, Feb 10

TBD

N/A

Week 7

Thu, Feb 17

TBD

N/A

Week 8

Thu, Feb 24

TBD

N/A

Week 9

Thu, Mar 3

TBD

N/A

Homework Assignments


HW2

Due: Mon, 1/17