CSE 414: Introduction to Data Management

Lecture Room: Mondays, Wednesdays and Fridays at 3:30 - 4:20 PM

Q&A: Following class

Discussion Board

Announcement:

Apr 3: An additional evening section was allocated for stduents not in the North American time-zone.

March 28: Account activation is needed before logging into the Discussion Board. Look for the email "Activate your Ed account for CSE 414". Contact staff if additional help is needed.

CSE 414 Staff

cse414-staff@cs

Mark Friedman

He/him pronouns, mbfried@cs

Alternative email: markf@demandtech.com

OH:Wednesday 2:00 PM - 3:00 PM via Zoom

Steve Ma

He/him pronouns, bochenma@cs

OH: Friday 11:30 AM - 12:30 PM via Zoom

Chloe Wen

She/her pronouns, wenchloe@cs

OH:Tuesday 12:30 PM - 1:30 PM via Zoom

Gibbs Geng

He/him pronouns, zg44@cs

OH:Tuesday 3:00 PM - 4:00 PM via Zoom

Tanish Kapur

He/him pronouns, tan33sh@cs

OH: Tuesday 7:00 PM - 8:00 PM via Zoom

Shana Hutchison

She/her pronouns, shutchis@cs

OH: Thursday 10:30am PT via Zoom

Xinyue Chen

She/her pronouns, chenxy20@cs

OH:Thursday 7:00 PM - 8:00 PM via Zoom

Prati Dhamija

He/Him pronouns, prati13@cs

OH: Tuesday 10:30 AM - 11:30 AM via Zoom

Apurv Goel

He/Him pronouns, ag2304@cs

OH:Monday 7:00 PM - 8:00 PM via Zoom

Chris Nie

She/her pronouns, nies@cs

OH:Monday 1:30 PM - 2:30 PM via Zoom

Nalin Gupta

He/Him pronouns, nalin97@cs

OH:Wednesday 5:00 PM - 6:00 PM via Zoom

Josh Curtis

He/Him pronouns, curtijd@cs

OH: Monday 10:00-11:00 AM via Zoom

Patrick Render

He/Him pronouns, rendep@cs

OH:Wednesday 1:00 PM - 2:00 PM via Zoom

Calendar

View on Google Calendar

Lecture MWF, 3:30-4:20, Mark Friedman Lecture Q&A

Section AE/BE: Steve & Prati, TH 11:30 - 12:20 PM via Zoom

Section AA/BA: Chloe & Apurv, TH 12:30 - 1:20 PM via Zoom

Section AB/BB : Shana & Nalin, TH 1:30 - 2:20 PM via Zoom

Section AC/BC: Xinyue & Chris, TH 2:30 - 3:20 PM via Zoom

Section AD/BD: Gibbs & Tanish, TH 3:30 - 4:20 PM via Zoom

Section AF/BF: Josh & Patrick, TH 8:00 - 8:50 PM via Zoom

Lecture Resources:

PowerPoint font

  • Monday, March 30, Introduction

PDF PowerPoint Video

  • Wednesday, April 1, Joins

PDF PowerPoint Video

  • Friday, April 3, Joins

PDF PowerPoint Video

  • Monday, Apr 6, Aggregates

PDF PowerPoint Video

  • Wednesday, April 8, Subqueries

PDF PowerPoint Video

  • Friday, April 10, ER diagram

PDF PowerPoint Video

  • Monday, April 13, Subqueries & Logical Database Design

PDF PowerPoint Video

PDF PowerPoint

  • Wednesday, April 15, Logical Database Design

PDF PowerPoint Video

  • Friday, April 17, Demo

PDF PowerPoint Video

  • Monday, April 20, Design Theory

PDF PowerPoint Video

  • Wednesday, April 22, Relational Algebra

PDF PowerPoint Video

  • Friday, April 24, Exploring Data

PDF PowerPoint Video

  • Monday, April 27, SQL Query Execution

PDF PowerPoint Video

  • Wednesday, April 29, Cost Estimation

PDF PowerPoint Video

  • Monday, May 4th, Serializability

PDF PowerPoint Video

  • Wednesday, May 6th, Serializability

PDF PowerPoint Video

  • Friday, May 8th, Serializability

PDF PowerPoint Video demo

  • Monday, May 11th, Serializability

PDF PowerPoint Video

  • Wednesday, May 13th, Serializability

PDF PowerPoint Video

  • Friday, May 15th, Serializability

PDF PowerPoint Video

  • Monday, May 18th, Physical Database

PDF PowerPoint Video

  • Wednesday, May 20th, Physical Database

PDF PowerPoint Video

  • Friday, May 22nd, Physical Database

PDF PowerPoint Video

  • Wednesday, May 27th, Physical Database

PDF PowerPoint Video

  • Friday, May 29th, Beyond SQL

PDF PowerPoint Video

  • Monday, June 1st, Beyond SQL

PDF PowerPoint Video

  • Wednesday, June 3rd, Beyond SQL

PDF PowerPoint Video

  • Friday, June 5th, Beyond SQL

PDF PowerPoint Video

Section Resources:

Readings

  • ch1, ch 2-2.5, ch 6-6.5

Due Date: April 6th

  • ch3, ch4.1 - 4.8

Due Date: April 18th

  • Indexes: section 8.3 & 8.4

SQL database servers: 9.1 – 9.4

Index structures (b-trees and Hash tables): 14.1 – 14.3

Assignments